📊Excel Shortcut

Select Visible Cells Only

Detailed guide to use "Select Visible Cells Only" in Excel

Shortcut Keys

The highlighted keys show where to press. Press the required keys together.

Windows

Alt
;

Windows shortcut: Alt+;

Mac

Cmd
⇧
Z

Mac shortcut: Cmd+Shift+Z

Basic Info

Category
Other
Difficulty
★★☆(Intermediate)

How to Use

  1. 1Select the target cell/range if needed
  2. 2Press the highlighted keys shown above together
  3. 3Select Visible Cells Only is executed

Practice

Practice this shortcut and build reliable muscle memory.

Start Shortcut PracticeSee Practice ModesStart Function Practice

Usage Tip

Select only visible cells, excluding rows hidden by filters or grouping.

Related Shortcuts

Insert Cells/Rows/Columns

Same category
Ctrl + Shift + +

Delete Cells/Rows/Columns

Same category
Ctrl + -

Hide Row

Same category
Ctrl + 9

Hide Column

Same category
Ctrl + 0

Unhide Row

Same category
Ctrl + Shift + 9

Unhide Column

Same category
Ctrl + Shift + 0

Toggle AutoFilter

Same category
Ctrl + Shift + L

Create Table

Same category
Ctrl + T

More In This Category

Open Workbook

Ctrl + O

Close Workbook

Ctrl + W

Print

Ctrl + P
View Full Shortcut List

FAQ

What is the shortcut for Select Visible Cells Only?

Windows: Alt+;. Mac: Cmd+Shift+Z.

How do I use Select Visible Cells Only?

Use it on the active workbook or selection to keep routine work keyboard-first.

What shortcuts should I practice after Select Visible Cells Only?

Practice save, copy, and paste next and you can move through common Excel work much faster.

Where can I practice Select Visible Cells Only?

Use the page button to start a focused drill right away. If you switch to full practice, you can review save, copy, and paste in the same flow.

← Back to ListExcelGym Home