Select Visible Cells Only | ExcelTraining.com

Using the Select Visible Cells Only Shortcut

Windows keyboard shortcut

Mac keyboard shortcut

This Excel shortcut selects only visible cells in the current selection. Rows and columns that are hidden in the current selection will not be selected.

Users of Mac Excel 2016 can use the ALT ; shortcut used on Windows.

Discover 242 Excel Keyboard Shortcuts for Windows and Mac

Other useful Select Special keyboard shortcuts

Select Direct Precedents

Select All Precedents

Select Direct Dependents

Select All Dependents

Select Current Array