If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto numbering inserted rows.
I need to have newly inserted rows auto-number upon insertion. I've searched
for any tips and the closest I can find is the List function on the Data menu, but all it does for me is create a drop down sort option. Can anyone give me any pointers. I'm fairly literate in excel, but seem to have a 'block' for this piece. Thanks!! -- Sherrill |
#2
|
|||
|
|||
Auto numbering inserted rows.
Hi,
The solution depends on exactly how auto you want it. If you are willing to copy a formal down then your formula would be =MAX($A$1:$A1)+1 Enter 1 in cell A1. Enter the formula in A2 and copy it down as far as you want. When you insert a row fill the formula to that row. If this is not Auto enough you will need to consider VBA most likely. If this helps, please click the Yes button Cheers, Shane Devenshire "Sherrill" wrote: I need to have newly inserted rows auto-number upon insertion. I've searched for any tips and the closest I can find is the List function on the Data menu, but all it does for me is create a drop down sort option. Can anyone give me any pointers. I'm fairly literate in excel, but seem to have a 'block' for this piece. Thanks!! -- Sherrill |
Thread Tools | |
Display Modes | |
|
|