200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

Select all visible cells – Microsoft Excel shortcut

When working with a range of cells that includes hidden rows or columns, this shortcut is great for copy/paste or chart-making situations. Only the visible cells will be selected and those that are hidden/unwanted fort this action will remain untouched.

Alt ;

 Shift Z

Get more Reference tips and tricks

Subscribe to our email updates and get Reference tips direct to your inbox.