Select Visible Cells Only

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.
Other useful Select Special keyboard shortcuts