This question already has an answer here:

If I press CRTL+Down I move to the cell before the empty cell.

If I press CTRL+SHIFT+End I end up selecting everything between the active cell and the next empty cell.

Now if I want to auto fill the same range of cells, what is the keyboard shortcut for that? (Autofill; also known as clicking the handle in the lower right hand corner of the cell and dragging)

marked as duplicate by Tog, mpy, Shekhar, nc4pk, Excellll Oct 16 '13 at 22:18

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • Because it's to short to be an answer ctrl+d Note: you will have to highlight the cells first – 50-3 Oct 7 '13 at 19:56
  • 1
    Note: The answer is already posted here – 50-3 Oct 7 '13 at 19:59
  • @50-3 No that isn't it. I just tired it, and when you select and press CTRL+D, it fills in the value of the top cell. That's not what I'm referring to. I'm referring to when you have a sequence for instance ... user01, user02, user03 etc...and you select those cells and then drag to the bottom of the sheet, and each cell increments. I'm looking for a keyboard shortcut for that. – leeand00 Oct 7 '13 at 20:18
  • Oh you double click it and that fills the rest in. :-p Still not a keyboard shortcut though. – leeand00 Oct 7 '13 at 20:20
  • Alt>H>F>I>S and then shift+tab>down>down>down and then enter – 50-3 Oct 7 '13 at 22:43

There a two different function that can be performed using this part of the GUI


Fill using formula

Starting point:


ctrl + D

enter image description here


Fill sequence:

Starting point:

enter image description here

Alt>H>F>I>S Then shift+tab>down>down>down>Enter

enter image description here

Personally I see the sequence fill as to cumbersome so below is a quick macro to do the same

Sub dragSeries()
    Selection.DataSeries Rowcol:=xlColumns, Type:=xlAutoFill, Date:=xlDay, _
End Sub

Just assign it to say ctrl+shift+D and enjoy

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