Excel Column Renumbering Question

[clacount]

If I put numbers in Column A (1, 2, 3 etc.) and then I will have to remove
various rows from Column A (#10, #15, #34, #45 etc.) can I get Column A to
automatically renumber in sequence after I remove variuos rows?

 

[Jim Thomlinson]

You can use the Row() function to deteremine the row that the formula is in.
Using an offset such as
=row() + 3
will allow you to get the numbering you want. Note however that row() is a
volatile function and if you have thoushads of these functions you could
adversely affect performance.

 

[Gary''s Student]

In Aa1, enter:

=ROW() and copy down

 

[dlw]

put a 1 in A1, then highlight A1 and the rest you want to renumber, then Edit