numbering rows

  • Thread starter Thread starter jane
  • Start date Start date
J

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!
 
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
 
Back
Top