Is there a keyboard shortcut to fill handle a large # of cells?
I know if you click on a cell and wait for the black cross you can fill
handle cells by clicking and dragging, but that takes a while when we need to fill thousands of cells. Is there a keyboard shortcut that can drag and fill the cells faster? |
Is there a keyboard shortcut to fill handle a large # of cells?
Double click on the fill handle, & it will fill down as far as there is data
in the adjacent column. Otherwise copy, then select the relevant range and paste. -- David Biddulph "Erin" wrote in message ... I know if you click on a cell and wait for the black cross you can fill handle cells by clicking and dragging, but that takes a while when we need to fill thousands of cells. Is there a keyboard shortcut that can drag and fill the cells faster? |
Is there a keyboard shortcut to fill handle a large # of cells?
What content is in the cells?
Enter =B1 in A1 In namebox type A1:A12000 and ENTER Ctrl + d to fill down. Gord Dibben MS Excel MVP On Mon, 21 Dec 2009 13:49:01 -0800, Erin wrote: I know if you click on a cell and wait for the black cross you can fill handle cells by clicking and dragging, but that takes a while when we need to fill thousands of cells. Is there a keyboard shortcut that can drag and fill the cells faster? |
All times are GMT +1. The time now is 05:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com