Command, Shift, Arrow Keys to Select Any Cells
I am having issues selecting and highlighting blank cells in a workbook. There is a new feature I believe where if I start to select the data the Cmd + Shift + Arrows works properly and has a bit of an auto stop, so it recognizes where the data ends, however, if I want to select any blank cells beyond that data, it will not move. I have to hand select these cells and use the scroll. There are times where I want to remove formatting in the blank area that has been applied to the blank cells until the end of the workbook, however, I can't auto select all of the cells because it's not a part of data.
(Edited by Dan [MS] on June 16, 2016 - moved from Windows Desktop to Mac area of UserVoice)
To select empty cells, you just want to hold down the shift key as you press arrows. The ctrl key will jump to the next cell with data (or the end of the row/column if there’s no more data there)
Hope that helps. If you’ve got more questions in this space, head on over to the Excel forum at http://answers.microsoft.com where there are experts to help.
4 commentsComments are closed
Thanks Dan! I meant to include it under the Mac section - my apologies. I found the thread and upvoted it on the Mac side. Thanks again!
Ahh, I was wondering if you were on a Mac, or were at least a Mac user due to the "Cmd" reference (the idea you opened is in our Windows Excel area, just fyi).
On a Mac, you're right - cmd+arrow doesn't take you beyond the data. I'll move this idea over to the Mac area, so we can look at it from that POV.
Dan, it is not supported. I should be able to jump highlight using the Cmd + Shift just like I would on a PC with Ctrl + Shift, however, on the Mac, it does not work.
Holding down shift while pressing the arrow keys only highlights a single row at a time.
Edit: This is for the Excel desktop application, not online.