set up auto numbering of cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm new to Excel. I want to set up a spreadsheet as a database for keeping
track of work on a monthly basis. This means at the end of each month I want
to calculate what individual totals are and print them, but retain the
original spreadsheet. I want to set up auto numbering for each row. I don't
know that I have explained it too clearly but can anyone help me?
 
If you want to set up a unique number for each row, the pick a column, say
column A, and enter:

=ROW()
 
Back
Top