Auto update row numbers after inserting new row

Auto update row numbers after inserting new row

Post by Y2FydXNzb » Wed, 28 Jan 2009 00:53:04


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
 
 
 

Auto update row numbers after inserting new row

Post by Fred Smit » Wed, 28 Jan 2009 01:05:27

Yes. Use the formula:
=row()

Regards,
Fred.

 
 
 

Auto update row numbers after inserting new row

Post by Y2FydXNzb » Wed, 28 Jan 2009 01:55:01

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
 
 
 

Auto update row numbers after inserting new row

Post by Gord Dibbe » Wed, 28 Jan 2009 05:01:40

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
 
 
 

Auto update row numbers after inserting new row

Post by Fred Smit » Wed, 28 Jan 2009 05:08:59

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.