Type in 1 in a cell, 2 in the next. Select both cells, go to the bottom left
corner until the cursor changes to a solid black cross, the click and drag
down.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tendercare" wrote
in message ...

Hi,

how can I enumerate a large amount of numbers in a column without
having to type in every single number? (ex. 1 - 999)

ty :)


--
tendercare
------------------------------------------------------------------------
tendercare's Profile:
http://www.excelforum.com/member.php...o&userid=25780
View this thread: http://www.excelforum.com/showthread...hreadid=391836