Consecutive numbers

[JamesChamp]

Can someone tell me, is there an easy way to fill down the first colum
with consecutive numbers?

Thanks
Jame

 

[Nick Hodge]

James

Sure, enter 1 in A1 and 2 in A2 and then select both cells and drag the
'fill handle' (The small square in the bottom right of the selected cells)
as far as you want. This will increment the numbers...does the same for
dates, days of weeks or even numbers t the end of words, e.g. test1, test2,
etc

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]

 

[JamesChamp]

Thanks a ton Nick!!

Jame

 

[JamesChamp]

One more question... I tried usuing that trick with web addresses lik
so,

www.address.com/ab.001.htm
www.address.com/ab.002.htm

but all it wanted to do was list 001 and 002 alternately over an
over.
Any ideas?

Thanks
Jame

 

[Dave Peterson]

Put this in the top cell:

="www.address.com/ab." & text(row(a1),"000") & ".htm"

Drag down (and convert to values--so that when you insert/delete rows, your
addresses don't change.

 

[JamesChamp]

Thanks Dave!! It worked great.

Jame