ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Keyboard command to replace double clicking the fill handle (https://www.excelbanter.com/excel-discussion-misc-queries/26651-keyboard-command-replace-double-clicking-fill-handle.html)

Pat

Keyboard command to replace double clicking the fill handle
 
When double clicking the fill handle, Excel will automatically copy or fill
the data into all blank cells down to the next cell with data in it.

Is there a keyboard command that can replace the double clicking?


Peo Sjoblom

No, you need to select the range by for instance using shift + down arrow and
thenctrl + D, otherwise you need to use VBA


Regards,

Peo Sjoblom

"Pat" wrote:

When double clicking the fill handle, Excel will automatically copy or fill
the data into all blank cells down to the next cell with data in it.

Is there a keyboard command that can replace the double clicking?



All times are GMT +1. The time now is 03:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com