#1
|
|||
|
|||
Autonumbering each row
Hello,
I'd like to set up autonumbering for each row in my Excel spreadsheet. This Excel Serial number would be the first column. There is data in all the other columns. I also want the numbering to recalculate if I insert rows with new data. Thanks for your help, Gef |
#2
|
|||
|
|||
How about putting the formula =row() in the A column? If you use the Format as Table function (Home tab), the table will even insert the formula when you insert a new line.
|
Tags |
auto numbering |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Autonumbering in right hand column | Markb384 | Word | 1 | 11-29-2013 01:18 PM |
Exhibit numbering with hyperlinks and autonumbering | Fenemorel | Word | 1 | 09-08-2012 10:42 AM |
How to do intelligent autonumbering? | nwong1288 | Word | 0 | 02-26-2010 01:25 PM |