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?


LVL 39
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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:


Select the entire row:


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):


Extend the selection to the beginning of the worksheet :


I don't know any keyboard shortcut to "fill series"
zorvek (Kevin Jones)ConsultantCommented:
CTRL+D does do a fill down but you have to have both the source and target cells selected.

Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

You can try the Fill Series 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 :)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Here's an image
nutschAuthor Commented:
Thanks to all.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.