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

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Graham Hill" <(E-Mail Removed)> wrote in message
news:ckNtb.405246$pl3.186910@pd7tw3no...
> 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
>
>

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

On Sun, 16 Nov 2003 16:10:48 GMT, "Graham Hill" <(E-Mail Removed)> wrote:

>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
>

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.

<Gord Dibben> wrote in message news:(E-Mail Removed)...
> In A1(or A2 if you have titles in row 1) enter =ROW() and drag/copy down.
>
> "Graham Hill" <(E-Mail Removed)> wrote:
> >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?