EXCEL HELP!!

  • Thread starter Thread starter jenniferwillis
  • Start date Start date
J

jenniferwillis

I want to number a column 4000-5000, I don't want to sit
and type all those numbers out by hand. Is there a way to
number consecutively?? Please help??
 
Hi
in A1 enter the following formula
=ROW()+3999
copy this formula down for 1000 rows
 
Jennifer

Frank's method will do what you want, but it will leave formulas in the
cells, which you may not want. To fix these values in place, select the
cells, then Edit/Copy then Edit/Paste Special .. Values.
An alternative way is to put 4000 into the first cell. If you then reselect
the cell, you can drag down the column with the little cross in the bottom
right hand corner, using your right mouse button. When you get to the end,
select Fill Series from the menu.

Andy.
 
Or : Type the first 2 numbers ( 4000 and 4001) and then select both cell and
click and "drag" the fill box ( the small square at bottom right of the two
selected cells).
You can drag down al long as your range needs to be.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
put 4000 in 1st cell, put 4001 in 2nd cell, select both cells, move cursor to
bottom right corner of cell so it turns into a +, click and then drag down -- as
you drag you should notice the counter increasing up from 4000 (if you dont,
press the CTRL key)


: I want to number a column 4000-5000, I don't want to sit
: and type all those numbers out by hand. Is there a way to
: number consecutively?? Please help??
 
Enter 4000 in the top cell. Highligt the column and click Edit/Fill,
Series/Linear, Step value 1/ Stop Value 5000.
You can also fill rows the same way.
Ed Leavitt
 
Back
Top