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.


On Fri, 18 Feb 2005 12:23:06 -0800, Rozeta
wrote:

what is keyboard shortcut to auto fill option