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" wrote in message ... 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 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" wrote: Rozeta, Try selecting your range to be filled (Shift-Down, or Shift-Right, etc.), then Alt-e, i, d. |
All times are GMT +1. The time now is 10:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com