| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is keyboard shortcut equivalent to drag the fill handle | Excel Discussion (Misc queries) | |||
| using the fill handle All the cells return the value of the first | Excel Worksheet Functions | |||
| There should be a keyboard shortcut for fill color in excel | Excel Worksheet Functions | |||
| Keyboard command to replace double clicking the fill handle | Excel Discussion (Misc queries) | |||
| what is keyboard shortcut to auto fill option | Excel Discussion (Misc queries) | |||
Linear Mode
