Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is keyboard shortcut equivalent to drag the fill handle
Let's say, if two fields in one column has been filled with numerical
increament, i.e. A1 is 2 and A2 is 4. Now I want to fill the whole column with this increament pattern till row A20. One thing we will all do is to left click on the fill handle and drag it down to row A20. But if the task is to fill to row 500, the mouse draging sometime won't be easy to locate the row. I am wondering anyone can help me to find the keyboard shortcut equivalent to that drag fill handle action. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is keyboard shortcut equivalent to drag the fill handle
Put a formula in cell A2. =A1+2. Selecting A2, press shift and right arrow
until the final column you require. Then press Ctrl + R "JZ" wrote: Let's say, if two fields in one column has been filled with numerical increament, i.e. A1 is 2 and A2 is 4. Now I want to fill the whole column with this increament pattern till row A20. One thing we will all do is to left click on the fill handle and drag it down to row A20. But if the task is to fill to row 500, the mouse draging sometime won't be easy to locate the row. I am wondering anyone can help me to find the keyboard shortcut equivalent to that drag fill handle action. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is keyboard shortcut equivalent to drag the fill handle
Doesn't really sound like you must use the keyboard only instead of
the mouse, so here is something you can do to speed up the process. If you have something in each cell of the column to the left, or in the case of Column A you have something to the right in each cell. You can select A1:A2 and double-click on the fill handle. You could use a formula in A1: =2*ROW() and then type into the namebox A1:A500 then use Ctrl+D (fill down) The namebox is to the left of the formula bar. Also see http://www.mvps.org/dmcritchie/excel/fillhand.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Jaleel" wrote in message ... Put a formula in cell A2. =A1+2. Selecting A2, press shift and right arrow until the final column you require. Then press Ctrl + R "JZ" wrote: Let's say, if two fields in one column has been filled with numerical increament, i.e. A1 is 2 and A2 is 4. Now I want to fill the whole column with this increament pattern till row A20. One thing we will all do is to left click on the fill handle and drag it down to row A20. But if the task is to fill to row 500, the mouse draging sometime won't be easy to locate the row. I am wondering anyone can help me to find the keyboard shortcut equivalent to that drag fill handle action. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keyboard shortcut for sum | Excel Discussion (Misc queries) | |||
fill handle | Excel Discussion (Misc queries) | |||
fill handle | Excel Discussion (Misc queries) | |||
Keyboard command to replace double clicking the fill handle | Excel Discussion (Misc queries) | |||
3-d reference not adjusting when using Fill Handle to copy down | Excel Worksheet Functions |