Select visible cells only
Master this Excel shortcut with our comprehensive guide
Special Cells Shortcuts
Alt + ;
⌘ + Option + Z
How to Use This Shortcut
Keyboard Shortcut
Alt + ;
Instructions
1. Press Alt + ;
2. Selects only visible cells in a filtered or hidden range
2. Selects only visible cells in a filtered or hidden range
Keyboard Shortcut
⌘ + Option + Z
Instructions
1. Press Command + Option + Z
2. Selects only visible cells in the selection
2. Selects only visible cells in the selection
💡 Pro Tip: Essential when copying filtered data to avoid hidden rows.
Quick Actions
More Special Cells Shortcuts
Ctrl + Shift + 8
Ctrl + Shift + O
Ctrl + `