Exceljet

Quick, clean, and to the point

Select visible cells only

Windows shortcut 
Alt;
Mac shortcut 
Z

This shortcut will select only visible cells in the current selection. This means that cells in the current selection that are in hidden rows or columns will not be selected. Watch our video tip on this shortcut.

In Mac Excel 2016, you can use the same shortcut as Windows, Alt  ;

Related videos

The videos below show how this shortcut can be used.
In this lesson, we cover shortcuts you can use to select special cells with Go To Special
In this video, we'll show how to select visible cells only.