+ Reply to Thread
Results 1 to 4 of 4

Selecting an Adjacent Range using the Keyboard

  1. #1
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    2010 & 2019
    Posts
    609

    Selecting an Adjacent Range using the Keyboard

    Hi,

    I have data in A2:A1000 and would like to put a formula in cell B2 and then copy it down from B3 to B1000.

    Is there a shortcut key sequence that I can use to select the range in B3:B1000 in one step rather than using things like Shift+PgDn?

    Thanks!

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,568

    Re: Selecting an Adjacent Range using the Keyboard

    Once you put the formula in cell B2, and cell B2 is selected, double click on the little box in the bottom right corner of the cell. This will instantly fill the formula down the column.

  3. #3
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    2010 & 2019
    Posts
    609

    Re: Selecting an Adjacent Range using the Keyboard

    Thank you.

    If I just wanted to select the range B2:B1000 is there a keystroke sequence to achieve this (without using the mouse)? The range selected would be the same length (i.e. number of rows) as the adjacent filled cells, A2:A1000.

    Thanks!

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,568

    Re: Selecting an Adjacent Range using the Keyboard

    Thanks for the rep!

    I'm not sure why you would want to select cells with nothing in them.

    One way, with B2 selected, would be to hit Ctrl + Shift + End.

    This would select A2:B1000. Then Shift + Right Arrow to move the selection to B2:B1000.

+ 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