Adding numbers to a list

[alienyde]

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

 

[Peo Sjoblom]

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

 

[Ron Coderre]

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

 

[alienyde]

thanks alot guys, it worked..

Alienyde