Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto update row numbers after inserting new row
I have a spreadsheet with Column A rows numbered sequentially using auto fill
series [have also tried Row()]. If someone adds a new row BETWEEN 2 existing numbered rows (not after the last populated row), is there any way to have the row numbers automatically renumber to include the new inserted row? Thanks! -- carusso |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto update row numbers after inserting new row
Yes. Use the formula:
=row() Regards, Fred. "carusso" wrote in message ... I have a spreadsheet with Column A rows numbered sequentially using auto fill series [have also tried Row()]. If someone adds a new row BETWEEN 2 existing numbered rows (not after the last populated row), is there any way to have the row numbers automatically renumber to include the new inserted row? Thanks! -- carusso |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto update row numbers after inserting new row
Hi Fred, thanks for your repsonse. I already tried the =row(), but that still
won't automatically update row numbers if a new row is inserted between 2 existing rows. The user would have to know to copy down the formula after inserting the new row....and most of these users don't have a clue what to do in Excel... ;-) Cheryl -- carusso "Fred Smith" wrote: Yes. Use the formula: =row() Regards, Fred. "carusso" wrote in message ... I have a spreadsheet with Column A rows numbered sequentially using auto fill series [have also tried Row()]. If someone adds a new row BETWEEN 2 existing numbered rows (not after the last populated row), is there any way to have the row numbers automatically renumber to include the new inserted row? Thanks! -- carusso |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto update row numbers after inserting new row
You have replies at your posting in other new group.
Please don't multi-post. Gord Dibben MS Excel MVP On Mon, 26 Jan 2009 08:55:01 -0800, carusso wrote: Hi Fred, thanks for your repsonse. I already tried the =row(), but that still won't automatically update row numbers if a new row is inserted between 2 existing rows. The user would have to know to copy down the formula after inserting the new row....and most of these users don't have a clue what to do in Excel... ;-) Cheryl |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto update row numbers after inserting new row
In my experience users have a harder time with row insert that they do with
copying a formula. If they can insert a row, they can typically copy the formula with the fill handle. However, if this is beyond your users, you would need a macro to do what you want. Or, eliminate the column completely, and use the row numbers Excel provides. Regards, Fred. "carusso" wrote in message ... Hi Fred, thanks for your repsonse. I already tried the =row(), but that still won't automatically update row numbers if a new row is inserted between 2 existing rows. The user would have to know to copy down the formula after inserting the new row....and most of these users don't have a clue what to do in Excel... ;-) Cheryl -- carusso "Fred Smith" wrote: Yes. Use the formula: =row() Regards, Fred. "carusso" wrote in message ... I have a spreadsheet with Column A rows numbered sequentially using auto fill series [have also tried Row()]. If someone adds a new row BETWEEN 2 existing numbered rows (not after the last populated row), is there any way to have the row numbers automatically renumber to include the new inserted row? Thanks! -- carusso |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-update row numbers after inserting new row | Excel Worksheet Functions | |||
auto update formula when inserting additional columns | Excel Worksheet Functions | |||
Auto Inserting numbers | Excel Worksheet Functions | |||
Auto Update upon shifting, inserting or deleting | Excel Worksheet Functions | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |