A blog about Excel and its users
The Select All shortcut is by far the most commonly used shortcut for selecting all the cells in an Excel spreadsheet, but what happens when you have hidden columns and rows that you don’t want selected? You use the select only visible cells shortcut of course!
The select only visible cells shortcut will perform the same action as Select All, but it will ensure only the cells you can see on the spreadsheet are selected.
This is useful when dealing with hidden rows or columns that don’t necessarily need to be selected. Perhaps you are changing the format of your entire spreadsheet or copying only the visible cells to another spreadsheet that doesn’t need all those hidden columns. The select only visible cells shortcut has a place in your Mac Excel shortcut repertoire!
Step 1: This shortcut can be executed from anywhere on the Microsoft Excel Shortcut:
And boom! All visible cells in your Excel spreadsheet are now selected. From here you can copy the selected cells to paste to another spreadsheet, change the format of all the visible cells, delete everything, or anything else you want to do!