I have a sign up sheet and the Row line begins with the #3!!??

  • Thread starter How can I change line numbers in Excel??
  • Start date
H

How can I change line numbers in Excel??

I am going crazy trying to figure out how to make the list start with the #1.
Row 1 is the Company Name, Row 2 has the Column titles . I don't want Comany
Name or headers to have a line #, so I can have the first customer sign up on
Line 1............PLEASE help.
 
G

Gord Dibben

In A3 enter =ROW()-2

Drag/copy down.

Tools>Options>View. Uncheck Row and Column Headers.


Gord Dibben MS Excel MVP
 
B

bj

you can't change the row numbers in EXCEL. but you can make the first column
be any list you want and not show the row numbers by going to
tools-options-view and deslecting row & column headers
 
Top