Numbers?

  • Thread starter Thread starter danni
  • Start date Start date
D

danni

If i am making a list of things and it goes in numerical
order, e.g. 1-25 and i had to delete 23, wot do i have to
do in order for the numbers to automatically change or
recognise that the number has been deleted and should
therefore go down in number?

Any help would be most appreciated.

Thankx.
 
Hi Danni

Instead of entering numbers, you could perhaps use a formula like =ROW() ?
 
The other option, assuming you don't have any blank rows in your numbering, is to:-

Assuming you have 1 at say A6, in A7 put the following and copy down as far as needed:-

=OFFSET(A7,-1,)+1

Then when you delete a row it will automatically adjust.

Using the ROW() function, assuming you have 1 in A6, then in A7 put the following and copy down:-

=ROW()-ROW($A$6)+1

That way even if you add rows prior to the first number, the numbering system will stay whole.
 
Back
Top