+ Reply to Thread
Results 1 to 3 of 3

What is keyboard shortcut equivalent to drag the fill handle

  1. #1
    JZ
    Guest

    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. #2
    Jaleel
    Guest

    RE: 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. #3
    David McRitchie
    Guest

    Re: 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" <[email protected]> wrote in message news:[email protected]...
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1