Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm looking for a keyboard shortcut that will duplicate the functionality available by double-clicking the "handle" in the bottom-right corner of a cell. Is there something that can do this, without third-party software or creating custom macros?

share|improve this question

2 Answers 2

I provide you with two methods to accomplish what you want. Unfortunately, both methods do have their own caveats, since Excel does not provide an all-in-one keyboard shortcut for auto-fill. I highly suggest you try both methods and then determine which works best for you. Outside of these two methods, I do not believe you can accomplish what you seek without the use of macros or add-in modules. Should you go the macro route, the AutoFill method on any Range object should be all that you need.


Method 1 (my preferred way, one-time mouse interaction)

Once you fill in the cell you want to auto-fill downwards, double-click the bottom right corner as usual. To repeat the "auto-fill down" step, so long as you only enter data and press enter, you can repeat it by pressing Ctrl+Y.

This means that you do need to use the mouse, but only the first time. All subsequent work can be done purely with the keyboard, so long as you only use it to enter data (i.e. you don't use the context menu button to modify anything).


Method 2 (alternate, but it works with no mouse interaction)

Another way to accomplish this is to use a combination of the fill-down shortcut and the select all in range. After you enter the data in the cell, press Ctrl+Shift+End to select from the current cell to the end of the range that would be auto-filled. Then, press Ctrl+D to "fill down" into the entire range from the top cell.


Note that the second method does come with a bigger caveat in my opinion, as your view will move to the bottom of the spreadsheet (which does not happen with the first Ctrl+Y method). I know you can just hit the Home key to move back up, but (in my opinion) it's much more of a P.I.T.A. then the first method.

Which method you choose depends on your purposes, but I hope they do solve your problem.

share|improve this answer

I'm also curious about a shorter keybind for the Autofill Handle. But this also works:

Key Sequence for Fill Series

Select the entire range you wish to extend the series, including the blank cells and the "seed" (the cell that contains the initial value on which the autofill series will be based).

Press ALT >> H >> F >> I >> S >> Alt + F >> Enter.

enter image description here

To create/edit your custom lists, press Alt + F, go to Popular then click on Edit custom lists. The custom lists serve as bases for how the Autofill Handle populates cells.

Fill Down

Ctrl+ D

share|improve this answer
4  
Why does this look like a Mortal Kombat finishing move or something? –  Iszi Nov 21 '11 at 19:57
    
^_^ If you add up-up-down-down-a-b-a-b chuck norris appears. Personally, I almost always don't use the fill handle much, and I rely on the rest of the data table to get around, or the Name box. For example, if i want to copy a formula from A1, to 200 cells below it, I'd type "A200" into the name box, press Enter, then Ctrl+Shift+Up, then Ctrl+D. –  Ellesa Nov 23 '11 at 3:05

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.