Automatic row numbering

J

Judy

is there a way to automatically number items in excel. i
tried using the autofill option but when a row is deleted
or inserted the numbering does not update. For example, i
auto filled rows 1 - 10 in column A and then deleted row
7, the numbering didn't update, it went from 6 to 8. i
tried to create a link so that the cell on the row below
would increment by one for example =a2+1, the problem is
when a row is deleted a reference error will appear on all
the rows underneath. Please let me know if this is
possible thanks.
 
P

Paul B

Judy, how about =ROW() in A2 and copy down?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Sequential Numbering System 0
align row numbers with row data 1
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
automatic table row numbering 3
Row Numbering - do not want to count first row 2
Row Numbering 6
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Auto-update row numbers after inserting new row 5

Top