03-12-2020, 12:48 PM #1How to select non-adjacent rows in Excel 2011?
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
- 03-12-2020, 12:57 PM #2
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By kthorogood in forum macOS - Apps and GamesReplies: 2Last Post: 10-24-2016, 11:20 AM
By stickleyjeff in forum Switcher HangoutReplies: 2Last Post: 03-24-2016, 12:51 PM
By cocaccro in forum macOS - Apps and GamesReplies: 1Last Post: 05-04-2013, 10:15 AM
By jonathanA in forum macOS - Apps and GamesReplies: 6Last Post: 11-14-2011, 09:02 PM
By Mark McLean in forum macOS - Apps and GamesReplies: 0Last Post: 03-04-2011, 07:45 PM
Tags for this Thread