Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
A simple formula A2 = A1+1. Cell A1 contains your starting number. Then copy
this down the column. When you insert a new row the row below the inserted one will need to point to the new row instead of the old row. Hope this helps. "Melanie needs help" wrote: How do I setup a formula that will automatically update my number sequence if I add or delete a row. for instance...I have rows numbered 1,2,3,4......etc.. I insert a row between 2 and 3 I need that row to automatically update to the appropriate sequence. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic Numbering | Excel Worksheet Functions | |||
Automatic numbering | Excel Discussion (Misc queries) | |||
Automatic Numbering | Excel Worksheet Functions | |||
automatic numbering | Excel Worksheet Functions | |||
Automatic Numbering. | Excel Discussion (Misc queries) |