+ Reply to Thread
Results 1 to 10 of 10

Is it possible to do a multiple cells selections using keyboard shortcuts instead of mouse

Hybrid View

  1. #1
    Forum Contributor daliye's Avatar
    Join Date
    05-28-2023
    Location
    North Africa
    MS-Off Ver
    microsoft excel, latest 365, 64-bit!
    Posts
    310

    Is it possible to do a multiple cells selections using keyboard shortcuts instead of mouse

    Hi,
    I used to use a left mouse click and hold down the ctrl button to select multiple cell ranges.
    Is there any way or a technique to do these different cell range selections using keyboard shortcuts instead?
    Last edited by daliye; 06-04-2024 at 05:28 PM. Reason: [SOLVED]
    thnx!
    d!
    microsoft 365 apps for enterprise

  2. #2
    Forum Contributor
    Join Date
    02-12-2024
    Location
    Australia
    MS-Off Ver
    365
    Posts
    152

    Re: Is it possible to do a multiple cells selections using keyboard shortcuts instead of m

    1. Get to your first cell in the (next) range using the arrow keys
    2. Press Shift+f8
    3. Holding down the shift key, use the arrow keys to select your range
    4. Press the f8 key, still holding down the shift

    Repeat steps 1 through 4 as many times as you like

  3. #3
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2019
    Posts
    4,542

    Re: Is it possible to do a multiple cells selections using keyboard shortcuts instead of m

    If you know the cell addresses, type directly in the Name Box, separating each cell by a comma, then hit the Enter key.

  4. #4
    Forum Contributor daliye's Avatar
    Join Date
    05-28-2023
    Location
    North Africa
    MS-Off Ver
    microsoft excel, latest 365, 64-bit!
    Posts
    310

    Re: Is it possible to do a multiple cells selections using keyboard shortcuts instead of m

    @Eeza Goodun
    Please, may you give more details, I've followed your steps to the letter but always when I finish selecting the current section that I want to choose when I want to move to the new range (while holding down the shift key), I found the empty range also being selected.
    I've attached a sample file.
    Reputation added.
    Thanks

    An example of what I want to achieve is to select these ranges in yellow using the keyboard instead of the mouse:
    Excel 2016 (Windows) 64 bit
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    1
    2
    66
    3
    15
    50
    93
    17
    51
    100
    102
    4
    90
    40
    89
    64
    96
    26
    72
    5
    16
    63
    23
    41
    36
    21
    30
    6
    43
    7
    44
    8
    105
    49
    78
    73
    9
    3
    1
    2
    10
    27
    79
    55
    11
    18
    61
    104
    65
    95
    13
    12
    88
    19
    47
    20
    42
    69
    13
    7
    87
    85
    75
    58
    56
    14
    67
    80
    28
    32
    12
    39
    15
    53
    82
    31
    16
    57
    10
    70
    17
    18
    19
    24
    76
    74
    45
    33
    25
    60
    20
    94
    97
    34
    29
    46
    71
    35
    21
    92
    5
    11
    84
    6
    101
    38
    22
    37
    91
    48
    14
    86
    77
    62
    23
    98
    99
    54
    83
    9
    59
    4
    24
    68
    103
    52
    8
    25
    22
    26
    81
    27
    Sheet: Example
    @josephteh
    I am afraid that I do not know the range exactly as I keep scrolling to find the cells.
    Reputation added.
    Thanks
    Last edited by daliye; 06-04-2024 at 03:15 AM. Reason: add an example file

  5. #5
    Forum Contributor
    Join Date
    02-12-2024
    Location
    Australia
    MS-Off Ver
    365
    Posts
    152

    Re: Is it possible to do a multiple cells selections using keyboard shortcuts instead of m

    "I've followed your steps to the letter but always when I finish selecting the current section that I want to choose when I want to move to the new range (while holding down the shift key), I found the empty range also being selected."
    Read step 4 again. I don't think you are pressing the f8 key in this step.
    Note also that step 1 says nothing about holding the shift key down.

    So;
    1 Use arrows
    2. Shift+f8
    3. Shift + Arrows
    4. Shift + f8
    5. let go of the shift key and go to step 1
    Last edited by Eeza Goodun; 06-04-2024 at 03:57 AM.

  6. #6
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2019
    Posts
    4,542

    Re: Is it possible to do a multiple cells selections using keyboard shortcuts instead of m

    Eeza's steps do work. You may have to hold Fn key with F8.

  7. #7
    Forum Contributor daliye's Avatar
    Join Date
    05-28-2023
    Location
    North Africa
    MS-Off Ver
    microsoft excel, latest 365, 64-bit!
    Posts
    310

    Re: Is it possible to do a multiple cells selections using keyboard shortcuts instead of m

    @Eeza Goodun
    You are the man, this will save me a lot of time indeed.
    I've added the Ctrl to the steps to select more easily and it worked as well.
    Thanks a lot.
    Reputation added.

    @josephteh
    Yes, it is my friend.
    Reputation added.
    Last edited by daliye; 06-04-2024 at 05:27 PM.

  8. #8
    Forum Contributor
    Join Date
    02-12-2024
    Location
    Australia
    MS-Off Ver
    365
    Posts
    152

    Re: Is it possible to do a multiple cells selections using keyboard shortcuts instead of m

    Glad it worked for you. Thanks for the rep.!

  9. #9
    Forum Contributor daliye's Avatar
    Join Date
    05-28-2023
    Location
    North Africa
    MS-Off Ver
    microsoft excel, latest 365, 64-bit!
    Posts
    310

    Re: Is it possible to do a multiple cells selections using keyboard shortcuts instead of m

    Thanks
    I do like this place!

  10. #10
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2019
    Posts
    4,542

    Re: Is it possible to do a multiple cells selections using keyboard shortcuts instead of m

    Thanks for your feedback and Rep, and for marking the thread "Solved"!

+ 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. Replies: 1
    Last Post: 07-22-2022, 04:04 AM
  2. Replies: 1
    Last Post: 02-27-2016, 06:28 PM
  3. [SOLVED] Excel Mouse Tricks (or Mouse Shortcuts)
    By icestationzbra in forum Tips and Tutorials
    Replies: 5
    Last Post: 04-25-2014, 03:20 PM
  4. Replies: 1
    Last Post: 02-08-2007, 10:57 AM
  5. [SOLVED] How do I get Excel 2004 Mac to insert cells vis keyboard shortcuts
    By ernie_cool in forum Excel General
    Replies: 1
    Last Post: 08-04-2006, 08:00 PM
  6. Keyboard shortcuts
    By Greka in forum Excel General
    Replies: 5
    Last Post: 07-18-2006, 11:45 AM
  7. Replies: 2
    Last Post: 03-27-2006, 02:55 AM

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