+ Reply to Thread
Results 1 to 4 of 4

shift+space only working on the last group of adjacent cells

  1. #1
    Registered User
    Join Date
    07-03-2019
    Location
    the cloud
    MS-Off Ver
    Office 365 v1906
    Posts
    3

    shift+space only working on the last group of adjacent cells

    Hey, I'm fairly new to Excel and would appreciate any help. I've been banging my head against the wall on this one.

    Here's the situation:

    • I have selected multiple cells from one particular column.
    • Some of the cells are vertically adjacent. Others are separated by one or more rows.
    • I need to expand the selection to include entire rows from all currently selected cells.
    • When pressing shift+space, shift+left, or shift+right, the selection only expands on the last group of adjacent cells.


    Any hints?

  2. #2
    Registered User
    Join Date
    03-11-2016
    Location
    India
    MS-Off Ver
    2010
    Posts
    7

    Re: shift+space only working on the last group of adjacent cells

    If you select multiple cells with the help of keyboard (Shift + Down or Ctrl + Shift + Down) and then press Shift+Space, all the rows shall be selected. If you are selecting various cells with mouse, then I would suggest selecting row headings (while holding the Ctrl) rather than selecting cells.

  3. #3
    Registered User
    Join Date
    07-03-2019
    Location
    the cloud
    MS-Off Ver
    Office 365 v1906
    Posts
    3

    Re: shift+space only working on the last group of adjacent cells

    Thanks Xiang. In my situation, there are thousands of target cells which are scattered over a large spreadsheet. I am selecting the cells through Find All (via the Ctrl+f pop up). Perhaps there's another way to select all of the rows in which the keyword is present?

  4. #4
    Registered User
    Join Date
    07-03-2019
    Location
    the cloud
    MS-Off Ver
    Office 365 v1906
    Posts
    3

    Re: shift+space only working on the last group of adjacent cells

    Update: So apparently there's this thing called Auto Filter...

    Thanks for getting me to try another selection method!

+ 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] Shift+Space and Ctrl+Space shortcuts intermittently working
    By yumyumdimsum in forum Excel General
    Replies: 8
    Last Post: 10-14-2017, 11:54 AM
  2. Find cells containing text, but group them at top of adjacent column
    By stanbridge in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-03-2016, 08:36 PM
  3. Replies: 0
    Last Post: 10-21-2014, 03:20 PM
  4. [SOLVED] Space and group cells based on criteria from other cells.
    By sabin348 in forum Excel General
    Replies: 3
    Last Post: 02-26-2014, 05:21 AM
  5. Replies: 3
    Last Post: 07-30-2012, 11:20 AM
  6. Replies: 3
    Last Post: 05-21-2012, 03:42 AM
  7. SHIFT + ENTER not working on some cells Excel 2003
    By debnla in forum Excel General
    Replies: 1
    Last Post: 07-17-2007, 09:27 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