numbering rows

[jane]

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!

 

[Gord Dibben]

Jane

Two options.

1. In page setup>sheet 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

 

[JE McGimpsey]

One way:

In A1, enter

=ROW()

and copy down as far as necessary.