Excel provides some help on AutoNumbeing by filling in series or using ROW
formula. Well both have negative point thar they do not update when you add,
remove or modify rows. Well, using a different kind of ROW formula given
below you can make your autonumber update when you add, modify or remove row.
The formula is '=1+ROW()-1'. Insert this formula where you want the first
autonumber to come. You will have to change the last offset to suit the
number of row you left from top. ex. If you want to start autonumbeing from
3rd row put '=1+ROW()-3' then fill in the series till you want to. If you
insert any row inbetween you will have to fill just that series. The
belownumber will be updated. If you remove all number are updated. If you cut
a row and insert in below, if will be inserted updated with you only have to
fill series the inserted blank one.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions