what is keyboard shortcut to auto fill option

E

Earl Kiosterud

Rozeta,

Try selecting your range to be filled (Shift-Down, or Shift-Right, etc.),
then Alt-e, i, d.
 
M

Myrna Larson

Do you mean a key that corresponds to double-clicking on the fill handle? I'm
not sure there is one. If you go to Help and type

keyboard shortcut

in the box you can see all that are assigned.

If there is no shortcut, you would have to create a macro that does the
AutoFill and assign a shortcut key of your choice to that macro.

I managed to get this one line of code to work as long as the entire range to
be filled was selected.

Selection.Cells(1).AutoFill Destination:=Selection

But if you have to select the whole range, you might as well just press CTRL+D
to fill down rather than running a macro.
 
M

Myrna Larson

That's the sequence for Down, which you can get to quicker with CTRL+D.

If you want to fill to the right, it's Alt-e, i, r, which you can get to
quicker with CTRL+R.
 
Top