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.
Users of Mac Excel 2016 can use the ALT ; shortcut used on Windows.
Other useful Select Special keyboard shortcuts