B
bh
i dont want to enter every number from 3000 to 3299, how do i auto fill?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
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.
grab the fill handle (bottom right hand corner) and fill down.
M
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
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
S
Shane Devenshire
Hi,
1. Select the 3000 cell, hold down the Ctrl key and drag the fill handle down
1. Select the 3000 cell, hold down the Ctrl key and drag the fill handle down
D
Dana DeLouis
bh said: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
D
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.
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.
K
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.
lower righthand corner of the highlighted group and drag down the column
until you reach 3299.
S
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
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