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

Paragraph numbering in Word 1
MS Project Import Error Row 1 Column 5 2
Section and Page numbering 0
Weigh tasks 0
Finding the right style field in VBA 0
Mail Merge Help 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Finding the proper style field and the numbered paragraph value within the style 0

Top