i dont want to enter every number from 3000 to 3299, how do i auto fill?

Type 3000 in the first cell, and 3001 in the second. Select the two cells,
grab the fill handle (bottom right hand corner) and fill down.
--
David Biddulph

"bh" wrote in message
...
i dont want to enter every number from 3000 to 3299, how do i auto fill?

BH,

You can enter the first couple of numbers (i.e. 3000 & 3001) then grab the
"handle" (little square in the lower right hand corner of the cell) and drag
down how ever many numbers you need.

Max

"bh" wrote:

i dont want to enter every number from 3000 to 3299, how do i auto fill?

Hi,

1. Select the 3000 cell, hold down the Ctrl key and drag the fill handle down


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"bh" wrote:

i dont want to enter every number from 3000 to 3299, how do i auto fill?

bh wrote:
i dont want to enter every number from 3000 to 3299, how do i auto fill?


For a large number, I would enter 3000 in your first cell, make sure
this cell is selected, and then (depending on version) Do Edit - Fill -
Series
and type in your last value. Make sure "Column" is selected.
This way, you don't have to guess when to stop dragging down.
Look around this tab for other neat options.
= = =
HTH
Dana DeLouis

One more.

Select the 300 cells you want.
Edit|goto
type the address (like A2:A301)
and hit enter.

Then use a formula like:
=row()+2998
and hit ctrl-enter to fill the entire range.

If you want to, you can convert to values.
Edit|copy
Edit|paste special|values

=row()
returns the row number for the cell that contains the formula. So you may have
to adjust that 2998 to add to 3000.


bh wrote:

i dont want to enter every number from 3000 to 3299, how do i auto fill?

--

Dave Peterson

Type in the first two consecutive numbers then highlight them. Click on the
lower righthand corner of the highlighted group and drag down the column
until you reach 3299.

"bh" wrote:

i dont want to enter every number from 3000 to 3299, how do i auto fill?

Hi,

Try to keep threads together.

An alternate way is to enter 3000 and then ctrl+drag the fill handle down as
far as necessary.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"KarinT" wrote in message
...
Type in the first two consecutive numbers then highlight them. Click on
the
lower righthand corner of the highlighted group and drag down the column
until you reach 3299.

"bh" wrote:

i dont want to enter every number from 3000 to 3299, how do i auto fill?