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

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

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

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

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