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

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" wrote in
message ...

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