How To Auto Number Merged Cells In Excel?

How could we fill series numbers into a list of different size merged cells in Excel? First in our mind is to drag the Autofill handle to fill the merged cells, but, in this case, we will get the following warning message, and can’t fill the merged cells.

doc-fill-merged-cells-1

Since the fill handle does not support the merged cells, here, I can talk about some other tricks for solving this problem.

Auto number / fill merged cells with VBA code

Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...

Read More... Free Download...