what is keyboard shortcut to auto fill option

what is keyboard shortcut to auto fill option

Rozeta,

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

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Rozeta" <Rozeta@discussions.microsoft.com> wrote in message
news:FA64E288-A05A-450E-BF9F-EBA7B61B4476@microsoft.com...
> what is keyboard shortcut to auto fill option

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 <Rozeta@discussions.microsoft.com>
wrote:

>what is keyboard shortcut to auto fill option

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.


On Fri, 18 Feb 2005 16:23:56 -0500, "Earl Kiosterud" <nothanks@nospam.com>
wrote:

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