Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 17th 06, 05:41 PM posted to microsoft.public.excel.misc
JZ JZ is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 7
Default 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   Report Post  
Old July 19th 06, 02:11 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 187
Default 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   Report Post  
Old July 31st 06, 06:25 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 903
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
keyboard shortcut for sum Sarah Excel Discussion (Misc queries) 10 August 31st 06 11:20 PM
fill handle rexmann Excel Discussion (Misc queries) 2 June 9th 05 03:02 PM
fill handle Brenda Excel Discussion (Misc queries) 4 May 19th 05 04:10 PM
Keyboard command to replace double clicking the fill handle Pat Excel Discussion (Misc queries) 1 May 18th 05 05:50 PM
3-d reference not adjusting when using Fill Handle to copy down gall Excel Worksheet Functions 3 November 24th 04 07:42 PM


All times are GMT +1. The time now is 03:56 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017