Select All Visible Cells

November 23, 2013

0 comments

active cell   Excel on Mac   Excel Resources   Excel Shortcuts for Mac   Excel Skin   Select all   Select All Shortcut   Select All Shortcut on Mac   select only visible cells   selecting   selecting cells   Selecting entire column   Selecting entire row   Selecting Everything   selecting rows and columns  



We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience.

That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The Excel Skin will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the Excel Skin just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC. And with the Excel Skin, you’ll relearn your old shortcuts in no time.

The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability.

The Excel Skin a small product that will make a big difference in your life.

 

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:

⇧⌘Z

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!  



Leave a comment

Comments will be approved before showing up.