0

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)

leeand00
  • 23,552

1 Answers1

1

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

1st

Fill using formula

Starting point:

pre-cdfill

ctrl + D

enter image description here

2nd

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, _
        Trend:=False
End Sub

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

50-3
  • 3,999