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

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.

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

In A3 enter =ROW()-2

Drag/copy down.

ToolsOptionsView. Uncheck Row and Column Headers.


Gord Dibben MS Excel MVP

On Mon, 19 Mar 2007 10:54:40 -0700, How can I change line numbers in Excel??
<How can I change line numbers in wrote:

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.

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

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

"How can I change line numbers in Excel??" wrote:

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.