Auto-incremented copy down

Is there a keyboard shortcut that would duplicate the "drag the little black cross in the lower right corner of the range" behavior? Something like an auto-incremented edit-fill?

Thanks,

Thomas
LVL 39
nutschAsked:
Who is Participating?
 
rspahitzConnect With a Mentor Commented:
You can try the Fill Series wizard...it won't copy formulas but it will fill in a large range of cells very quickly.

to access it in Excel07/10 with the keyboard, use Alt+HFIS
You should also pre-fill the starting cell with a value so it works.

for example, if you want to fill the numbers 5 to 1000 (multiples of 5) down column A, put 5 in cell A1 then go to the fill series wizard to pop up a dialog window.
It will contain several sections.
The first section lets you define whether the series goes in Rows of Columns; select Columns
Next if the type of growth, which will be Linear if you want to increase arithmetically (add the same number each time, versus Growth/Geometric to multiply the same number each time, or Date for adding dates)
Next is only used if you picked date for the type
At the bottom the step value should be changed from 1 to 5 since we're adding 5 each time; this could also be a decimal or negative value if desired.
Finally, fill in the stop value of 1000.
Press enter (or click the OK button) and almost instantly, the cells are filled in :)
0
 
zorvek (Kevin Jones)ConsultantCommented:
No, because when dragging you are doing two things at once: you are defining the source AND the target with a single mouse motion. You can't do that with a single keystroke.

What you have to do is use multiple shortcuts to copy the source, select the target, and then paste.

Below is a list of the more useful keyboard shortcuts for selecting worksheet cells.

Select the current region around the active cell (the current region is a data area enclosed by blank rows and blank columns):

   CTRL+SHIFT+* (asterisk)

Select the entire column:

   CTRL+SPACEBAR

Select the entire row:

   SHIFT+SPACEBAR

Extend the current selection one cell/row/column:

   SHIFT+arrow key

Move the selection to the last nonblank cell in the same column or row as the active cell:

   CTRL+arrow key

Extend the selection to the last nonblank cell in the same column or row as the active cell:

   CTRL+SHIFT+arrow key

Extend the selection to the last used cell on the worksheet (lower-right corner):

   CTRL+SHIFT+END

Extend the selection to the beginning of the worksheet :

   CTRL+SHIFT+HOME

Kevin
0
 
jppintoCommented:
I don't know any keyboard shortcut to "fill series"
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
zorvek (Kevin Jones)ConsultantCommented:
CTRL+D does do a fill down but you have to have both the source and target cells selected.

Kevin
0
 
rspahitzConnect With a Mentor Commented:
Here's an image
 rspahitz-441745.flv
0
 
nutschAuthor Commented:
Thanks to all.

Thomas
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.