Re: numbering cell names in Excel

(Using Excel97) Try:

Set a cell value ending in a number, e.g., "Dog1".

Select a series of adjoining cells starting with the "Dog1" cell.

Edit->Fill->Series
Select "Series in" Rows or Columns, as appropriate
Select Step Value 1
Select "AutoFill"
Select OK

Get "Dog1" Dog2", etc. in the selected cells.

Note: This only seems to work if all the adjoining cells except the first
("Dog1")
are initially empty. Non-empty cells appear to disrupt the auto-fill series
values.

Bill Stubblebine

> [EMAIL PROTECTED] (Zaphod Beeblebrox) wrote in message
news:<[EMAIL PROTECTED]>...
> > Thank you Peo, the only problem is that when I try that it only copies
> > "Dog1" over and over and doesn't increase the numbers. Am I doing it
> > wrong, or is there a default formula I need to activate? (I tried it
> > both with and without a space before the number and with the number
> > befor and after)
> >   thanks again,
> > zaphod