delete row and automatically renumber column

  • Thread starter Thread starter Graham Hill
  • Start date Start date
G

Graham Hill

This is probably a piece of cake for this NG : -

(For example) I have a small data base (any # of columns by any # of rows)
I wish to delete an entry and have the left side column automatically
renumber itself rather than having to manually (drag) to renumber the
column. Is this possible? Please help.

Thanks,
Gra
 
The numbers do not change when you delete a row. If you are using a column
with row numbers in in why not substitute the row function in the formula
instead

or
=row()
or
=row(a5) and copy down
 
Graham

Assuming you have your numbers in Column A.

In A1(or A2 if you have titles in row 1) enter =ROW() and drag/copy down.

When you delete a row the numbers will update.

When you insert a row you will have to copy just from the row above to the
inserted row.

Gord Dibben XL2002
 
Hi Graham,
A slight variation of Gord's reply is probably what you are
looking for.
A1: '#
A2: =ROW() -1
since you probably want to avoid numbering the row with
your own column labels. ROW() is going to report the row
number that the formula is in.
 
Back
Top