making a list of numbers.

T

toddb123

Is there a way to automatically list numbers? For example I want to make a
number list from 1-3000. If I enter 1 can Excel list the rest automatically?
 
B

Bob Phillips

Enter 1 in the first cell, 2 in the second, select both cells, move the
cursor to the bottom right of the cells until it changes to a black cross,
and drag down (Or across) until complete.

--

HTH

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


toddb123 said:
Is there a way to automatically list numbers? For example I want to make a
number list from 1-3000. If I enter 1 can Excel list the rest
Click to expand...
automatically?
 
G

Gord Dibben

One method.....there are many.

Enter 1 in A1.

Go to Name Box left of Formula Bar and type A1:A3000 then hit ENTER key.

Edit>Fill>Series>Linear>OK


Gord Dibben Excel MVP
 
J

Jim May

Also, in cell A6 (for example) enter =ROW()-5 (will produce 1 ) , then
copy down as far as you like This method especially helpful if you later add
or delete rows as auto-renumbering will take place,, may or may not be
something you would want.
HTH
 
Top