Excel Hack

Select visible cells in Excel shortcut

Learn how to select only visible cells in Excel. If there are hidden rows or columns in a table and you want to select only the visible cells, the normal range selection will select the hidden cells as well. Here are some shortcut keys to smoothly select only the visible cells, so please try them.

Select only visible cells

Select only visible cells using shortcut keys

Windows
Alt + ; (semicolon)

Mac
None

Select a visible cell in the dialog box

Windows
Alt + H + F + D + S

Mac
None

Select visible cells using shortcut keys

Learn how to use shortcut keys to select only visible cells. In this case, we will use a list with rows 2 through 5 hidden.

Total Time: 1 minute

Select cells

Select cells

Use Shift + Arrow key to select the cells you wish to select. To select a list, you can also use Ctrl + A. In this state, hidden cells are also selected.

Only visible cells are selected

Press Alt +;

Press Alt + ; to select only visible cells.

Selecting visible cells using a dialog box

Select cells

Use Shift + Arrow key to select the cells you wish to select.

To select a list, you can also use Ctrl + A.

In this state, hidden cells are also selected.

Select Visible cells only

Alt + H + F + D + S to display the Go To Special dialog box.

Press Y to select Visible cells only.

Press Alt +;

Press Enter selects only visible cells.