how to enumerate?
 

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

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

Example:

In cell A1 enter 1
In cell A2 enter 2

Select these two cells (using mouse or key board) and now take ur mouse
cursor over to the bottom right end of cell A2. You will see ur cursor
change to a black plus sign. Click and drag this till cell A999 and you
will have the numbers from 1 to 999.

Take care ;)
Karthik Bhat
Bangalore

Type 1 at the top of the column.
Click on that cell.
Move the cursor to the lower right -hand corner of the cell (it will change
shape)
Hold down the right-click button and drag the cursor down a ways
Release the button and select Fill Series from the options.
--
Gary's Student


"tendercare" wrote:


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