Discussion on:

Add autonumbering to your Excel spreadsheet

Mary Ann - I am confused. When you say, step 8, Go To Data | List do you mean menu item Data then item List because I do not have a list item in my data menu. I use Excel 2003. (Also no list on the Go To dialogue)

I think the List feature is new to Excel 2003. Please make sure you're really using 2003. If List isn't available on your Data menu, click the triangular arrow at the bottom of the menu to display all the items on your menu. If you're using 2003, it should be there.

ssharkins - thanks v much. Actually using 2000 at the office so not surprising! -- Simon

Since we're on the subject of numbering, I have semi-related comments. I get frustrated that MS Word does not truly "number" a table, though you can use an outlining feature to number the rows. If you sort, however, the numbers don't move with the associated item/entry. I very often work with data in Word, where I want to sort by various columns, and be able to return the table to its original order afterward. To do this, I do a "workaround" by generating a column of numbers in Excel, specifying the format of the cells as text, and copying that into the Word table. The reason for specifying text format is that Word cannot accurately sort numbers with varying numbers of digits--it has to be uniform (all numbers having 4 digits, for example).
You may ask why I don't do the entire project in Excel, but very often the edits I do to a table/spreadsheet cannot be done in Excel.
Am I making unnecessary work? Is there a REAL (sort-able) numbering utility for Word tables?

Off the top of my head, I don't have any answers for you, but I'll see what I can come up with.

I think that's a great idea...just remember that if a row (record) is deleted or added in this example, unlike what happens in Access, the autonumber column value does not stay associated with the data in its row. Otherwise, it's great.

If you click "My List has Headers," the first row of data will automatically be reformatted as Header (Style = Bold; Alignment: Horizontal = Center). After changes are Saved, reformatting Row 1 to match Row 2 can be difficult.

That's a keen catch -- thank you for sharing it with us.

Thanks for the note!

Sweet! Great tip. I will use it tomorrow.

Good Tip, how can you generate consequential serial numbers (Invoice Numbers) from a template invoice

download internet download manager(reg) from www.softwarehomes.com its surprisingly free and no need for registration

New my auto invoice number example.


Auto numbering with txt
Auto total
Auto date
Price List

examples in http://www.netmerkez.wordpress.com
View from http://hotfile.com/dl/139670745/2ff1e4b/Auto-Invoice-Number.rar.html

I know this post is old but never the less it was exactly what I need to auto number a list the I constantly had to either insert or remove rows from. Works perfectly.

Thanks rbsmith2000