#1
|
|||
|
|||
need autonumber in my excel file
hi,
I have an excel file with data,I need to add an Id column and create numbers from 1 to .... (as much as records It has).like autonumber in access. It has already had data,I do not want to enter data for other columns. |
#2
|
|||
|
|||
Hi
Please find herewith a solution. I have put an auto number formula in the first 100,000 rows. When you enter a value in each consecutive cell in column B from B2 downwards the number in column 1 will automatically increase by 1 from the previous row. Bear in mind that if you use this you will need to specify which pages to print when you want to print the document or you will end up printing 100,000 rows. Hope this helps. Tony (OTPM) |
#3
|
|||
|
|||
or you can view this thread for another option..
https://www.msofficeforums.com/excel...numbering.html |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel File Association | freeworld | Excel | 3 | 12-09-2011 10:07 AM |
File 'Versions' in Excel 2010 | keithg | Excel | 2 | 02-19-2011 07:44 AM |
Help with Excel file | cjv4life | Excel | 2 | 01-24-2011 12:53 PM |
Need an Automated sql query for the Excel file | Karthick | Excel | 3 | 12-20-2010 04:52 AM |
Some Excel File Will Not Open | cgoodlein | Excel | 5 | 05-19-2009 04:46 AM |