Consecutive numbers

[JamesChamp]

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

Thanks
James

[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]HIS


"JamesChamp" <[email protected]> wrote
in message news:[email protected]...
>
> Can someone tell me, is there an easy way to fill down the first column
> with consecutive numbers?
>
> Thanks
> James
>
>
> --
> JamesChamp
> ------------------------------------------------------------------------
> JamesChamp's Profile:
> http://www.excelforum.com/member.php...o&userid=32552
> View this thread: http://www.excelforum.com/showthread...hreadid=523453
>

[JamesChamp]

Thanks a ton Nick!!

James

[JamesChamp]

One more question... I tried usuing that trick with web addresses like 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 and over.
Any ideas?

Thanks
James

[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 wrote:
>
> One more question... I tried usuing that trick with web addresses like
> 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 and
> over.
> Any ideas?
>
> Thanks
> James
>
> --
> JamesChamp
> ------------------------------------------------------------------------
> JamesChamp's Profile: http://www.excelforum.com/member.php...o&userid=32552
> View this thread: http://www.excelforum.com/showthread...hreadid=523453

--

Dave Peterson

[JamesChamp]

Thanks Dave!! It worked great.

James