You cannot remove rows and start a new row 1 anywhere you wish.

If you want to see 1 in row 5 and 2 in row 6............

In A5 enter =ROW()-4

Drag/Copy down as far as you wish.

Turn off Display of row and column headings.

But that would be visual only.

Row 5 is still row 5


Gord Dibben MS Excel MVP

On Thu, 4 Mar 2010 11:05:01 -0800, Volunteer_Atwork
wrote:

Hello,

I would like counting of the rows to start at row 5, instead of row 1,
because it is just titles that do not need to be counted, in other words,
there is no data until row 5. How do I do this?