Select Visible Cells Only

Select only the visible cells in a range ignoring any hidden rows or columns.


Keyboard shortcut by app

App Windows Mac
Microsoft 365
Excel
Alt+;
Cmd+Shift+Z
Word Not available Not available
PowerPoint Not available Not available
Outlook Not available Not available
Teams Not available Not available
Google Workspace
Google Sheets Not available Not available
Google Docs Not available Not available
Google Slides Not available Not available

More in Smart Selection
Select All Dependent Cells Select All Precedent Cells Select Blank Cells in Range Select Cells with Conditional Formatting Select Cells with Constants Select Cells with Data Validation Select Cells with Formulas Select Current Region Select Direct Dependent Cells Select Direct Precedent Cells Select Last Cell Used in Sheet