ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   set up auto numbering of cells (https://www.excelbanter.com/excel-discussion-misc-queries/162696-set-up-auto-numbering-cells.html)

graylyn45

set up auto numbering of cells
 
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?

Gary''s Student

set up auto numbering of cells
 
If you want to set up a unique number for each row, the pick a column, say
column A, and enter:

=ROW()
--
Gary''s Student - gsnu200750


"graylyn45" wrote:

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?



All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com