Maintaining numerical order when deleting row
 

Hi. Could someone help? I am trying to keep the numerical order I have in
column A when deleting a row. Any tips? Thanks

Maintaining numerical order when deleting row
 

put a formula in column A

row 1 : 1
row 2 : =A1 + 1
row 3 : =A2 + 1
row 4 : =A3 + 1

You just copy cell in A2 (A1+ 1) to the other rows in column A. the copy
will increment the row numbers automatically. the only problem is when you
delete row 1, the you havve to put the 1 back into row 1.

Second method
row 1 : =row(A1)
row 2 : =row(A2)
row 3 : =row(A3)


Just copy the formula from A1 to all the other cells in column A


If you counting starts at 100
row 1 : =row(A1) + 99
row 2 : =row(A2) + 100
row 3 : =row(A3) + 101



"Russ" wrote:

Hi. Could someone help? I am trying to keep the numerical order I have in
column A when deleting a row. Any tips? Thanks

Maintaining numerical order when deleting row
 

Just to add to Joel's response.

If I had headers in row 1 and started my numbering in A2 with 1, I'd just use:

=row()-1
(and drag down the column)

The only difference between what Joel suggestion and mine is that I'd drop the
cell reference.

Russ wrote:

Hi. Could someone help? I am trying to keep the numerical order I have in
column A when deleting a row. Any tips? Thanks

--

Dave Peterson