| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Microsoft Excel 2003
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Microsoft Excel 2003
"clark" wrote:
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. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Microsoft Excel 2003
ToolsOptionsView.
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 On Fri, 30 May 2008 16:27:00 -0700, clark wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Microsoft Excel 2003 | New Users to Excel | |||
| my microsoft excel 2003 does not open | Excel Discussion (Misc queries) | |||
| Help on Microsoft Excel 2003 | Excel Discussion (Misc queries) | |||
| Microsoft Excel 2003 | Excel Worksheet Functions | |||
| Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
