Auto update row numbers after inserting new row

[carusso]

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!

 

[Fred Smith]

Yes. Use the formula:
=row()

Regards,
Fred.

 

[carusso]

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

Yes. Use the formula:
=row()

Regards,
Fred.

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!

 

[Gord Dibben]

You have replies at your posting in other new group.

Please don't multi-post.


Gord Dibben MS Excel MVP

 

[Fred Smith]

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.

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

Yes. Use the formula:
=row()

Regards,
Fred.

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!