Microsoft Excel 2003

[clark]

How do I change the row reference numbers on the left of the worksheet so
that the first row #1 is blank and then the row numbers start on row 2 but
with #1?

 

[Max]

How do I change the row reference numbers on the left of the worksheet so
that the first row #1 is blank and then the row numbers start on row 2 but
with #1?

You can't. Just use col A for your row numbering, to taste.

 

[Gord Dibben]

Tools>Options>View.

Uncheck row and column headers. In A2 enter this formula.

=ROW()-1

Copy down as far as you wish.

This is for appearance only.

Row 1 is still row 1


Gord Dibben MS Excel MVP