I want to make a dvd list through excel and number each of them, bu
instead of typing 1 through 200 for example, I would like a formula t
do it for me. So typing 1 in the first cell and dragging it down, s
that it says 1,2,3,4instead of writing it manually.Can someone hel
me?

Thanks,
Alienyd

--
alienyd
-----------------------------------------------------------------------
alienyde's Profile: http://www.excelforum.com/member.php...fo&userid=2711
View this thread: http://www.excelforum.com/showthread.php?threadid=54399

Put 1 in the first cell, right click the lower corner of the first cell,
copy down by holding the right button and dragging down, release and select
fill series when prompted or put 1 in the first and 2 in the second cell,
select both cells and copy drag down with the left hand mouse button

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"alienyde" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> I want to make a dvd list through excel and number each of them, but
> instead of typing 1 through 200 for example, I would like a formula to
> do it for me. So typing 1 in the first cell and dragging it down, so
> that it says 1,2,3,4instead of writing it manually.Can someone help
> me?
>
> Thanks,
> Alienyde
>
>
> --
> alienyde
> ------------------------------------------------------------------------
> alienyde's Profile:
> http://www.excelforum.com/member.php...o&userid=27118
> View this thread: http://www.excelforum.com/showthread...hreadid=543993
>

Here's something to try:

Select the first cell to be numbered
Put a number 1 in that cell
<edit><fill><series>
Check: Columns
Stop Value: 200
Click the [OK] button....Done

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=543993

thanks alot guys, it worked..

Alienyde


--
alienyde
------------------------------------------------------------------------
alienyde's Profile: http://www.excelforum.com/member.php...o&userid=27118
View this thread: http://www.excelforum.com/showthread...hreadid=543993