If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
numbering rows
Is there a way to number each row in Excel so that when
it prints out the rows all have numbers? I couldn't find it in Msft online Help but I guess that's no surprise. thanks! |
#2
|
|||
|
|||
numbering rows
Jane
Two options. 1. In page setupsheet select "row and column headers". Note this will print the column headsers also. 2. Insert a column to left of your original columns(will become column A) Enter in A1 =ROW() and drag/copy down the column as far as you wish. Gord Dibben Excel MVP On Fri, 23 Apr 2004 17:15:10 -0700, "jane" wrote: Is there a way to number each row in Excel so that when it prints out the rows all have numbers? I couldn't find it in Msft online Help but I guess that's no surprise. thanks! |
#3
|
|||
|
|||
numbering rows
One way:
In A1, enter =ROW() and copy down as far as necessary. In article , "jane" wrote: Is there a way to number each row in Excel so that when it prints out the rows all have numbers? I couldn't find it in Msft online Help but I guess that's no surprise. thanks! |
Thread Tools | |
Display Modes | |
|
|