how to fill in a column acending 3000 to 3299

[bh]

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

 

[Max]

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

 

[Shane Devenshire]

Hi,

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

 

[Dana DeLouis]

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

 

[Dave Peterson]

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.

 

[KarinT]

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.

 

[Shane Devenshire]

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