Results 1 to 2 of 2
  1. #1
    How to select non-adjacent rows in Excel 2011?
    krs's Avatar
    Member Since
    Sep 16, 2008
    Posts
    1,576
    Rep Power
    12
    How to select non-adjacent rows in Excel 2011?
    Hi,

    I'm trying to select non-adjacent rows in an Excel 2011 spreadsheetso that I can delete the selected rows in one operation rather than row by row.

    Everything I see on the net says to hold down the command key and select the rows, but that does not work.
    When I do that, all that gets selected is the first cell, ie the cell in the "A" column of that row, not the complete row.

    Tried holding down the option key and also the control key, but none will select non-contiguous rows.

    Any idea how to do his?

    I'm on El Capitan, but I don't think that matters

  2. #2
    How to select non-adjacent rows in Excel 2011?
    krs's Avatar
    Member Since
    Sep 16, 2008
    Posts
    1,576
    Rep Power
    12
    Just looked at this again....

    It actually does work using the command key.

    The problem was that I expected the same visual feedback than when I select a row manually, ie the complete row gets an outline.

    Using the 'command" key for multiple rows, the first cell in the row gets an outline, but inside that cell and then the whole row gets a very light shading (which I initially ignored)

    I assume there is a good reason why Microsoft didn't highlight the rows in the same way as for a single row.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2011 for Mac help
    By kthorogood in forum macOS - Apps and Games
    Replies: 2
    Last Post: 10-24-2016, 11:20 AM
  2. Replies: 2
    Last Post: 03-24-2016, 12:51 PM
  3. Excel for Mac 2011
    By cocaccro in forum macOS - Apps and Games
    Replies: 1
    Last Post: 05-04-2013, 10:15 AM
  4. Replies: 6
    Last Post: 11-14-2011, 09:02 PM
  5. Excel 2011 (Mac)
    By Mark McLean in forum macOS - Apps and Games
    Replies: 0
    Last Post: 03-04-2011, 07:45 PM

Tags for this Thread

Posting Permissions

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