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
|