Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel, How do I make column A renumber itself if I remove a row?
Column A will be numbers starting at 1 and continuing on. I will have to
remove some rows (ex. #10, #21, #45 etc.) but I want Column A to automatically renumber in sequence once I remove the various rows. Is there a way to do this? -- clacount |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel, How do I make column A renumber itself if I remove a row?
Maybe you could use a formula in each cell in column A:
=row() or =row()+5 =row()-2 (or add/subtract some number so that it starts on the value you want) You'll have to add this formula (dragdown from the previous row???) if you add a row. clacount wrote: Column A will be numbers starting at 1 and continuing on. I will have to remove some rows (ex. #10, #21, #45 etc.) but I want Column A to automatically renumber in sequence once I remove the various rows. Is there a way to do this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Formula to renumber column | Excel Discussion (Misc queries) | |||
Remove Chart Canvas or make transparent in Excel 07 on XP | Charts and Charting in Excel | |||
Sort and Renumber | Excel Programming | |||
How do I renumber a worksheet | Excel Programming | |||
how do you renumber column in your excel table | Excel Discussion (Misc queries) |