Microsoft Excel 2003

  • Thread starter Thread starter clark
  • Start date Start date
C

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?
 
clark said:
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?
Click to expand...

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

---
 
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
 
Back
Top