Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-copy of formula on inserted lines | Excel Discussion (Misc queries) | |||
AUTO INSERT A COLUMN'S FORMULA IN MANUALLY INSERTED ROWS | Excel Worksheet Functions | |||
auto numbering | Excel Discussion (Misc queries) | |||
How to have formulas and formats auto copy to new inserted rows | Excel Discussion (Misc queries) | |||
Auto sum does not add inserted figures in colum | Excel Worksheet Functions |