+ 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
    Microsoft 365
    Posts
    676

    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,872

    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
    Microsoft 365
    Posts
    676

    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,872

    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)

Similar Threads

  1. [SOLVED] Selecting different cells by Keyboard
    By vjharry in forum Excel General
    Replies: 2
    Last Post: 09-25-2014, 03:40 AM
  2. [SOLVED] Selecting all data in specific columns without selecting adjacent column.
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2014, 02:20 AM
  3. Selecting all data in specific columns without selecting adjacent column.
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2014, 03:50 PM
  4. [SOLVED] Selecting Worksheet Using a Keyboard Rather than a Mouse
    By Bigmal70 in forum Excel General
    Replies: 5
    Last Post: 10-02-2012, 05:08 PM
  5. Selecting range based on adjacent column
    By yaju1120 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2007, 10:41 AM
  6. Selecting and moving chart(s) within a worksheet using keyboard ke
    By xppuser in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-28-2006, 07:45 AM
  7. Keyboard Shorcut for selecting
    By Trying2Learn in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-01-2005, 04:09 PM

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