| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weekly sign in sheet for my daycare.... | Excel Discussion (Misc queries) | |||
| Change the sign on all numbers in a spread sheet | Excel Discussion (Misc queries) | |||
| XL invoice replace the dollar sign with euro sign | New Users to Excel | |||
| IF Function - Begins With | Excel Discussion (Misc queries) | |||
| How do I type number that begins with a zero to keep zero? | Excel Discussion (Misc queries) | |||
Linear Mode
