Excel Shortcut to Select Visible Cells in a Filtered Range

In Excel for Microsoft 365 on Windows, select the range you want and press Alt+; (Alt plus semicolon) to select only its visible cells. You can also choose Home > Find & Select > Go To Special > Visible cells only, then select OK.

What the visible-cells shortcut does

The shortcut narrows the current selection to cells that are visible. It is especially useful after filtering a list, because filtered-out rows are hidden from view but remain in the worksheet. Without a visible-cells-only selection, an action such as copying a selected block can include cells in those hidden rows as well as the records you can see.

It also applies when rows or columns have been hidden manually, or hidden by outlining and grouping. The command does not remove, reveal, or change hidden data; it changes which cells in the current selection are selected. That distinction matters: the hidden rows remain in the workbook, and clearing a filter later can make them visible again.

Think of the shortcut as a selection tool, not a filter or a privacy feature. It does not protect hidden information, and it does not make a workbook safe to share. If data should not be available to another person, hiding rows is not a substitute for removing or appropriately protecting that data.

How to use Alt+; step by step

Select the cells you want to work with. For example, drag across the visible portion of a filtered table column, or select the whole data block you intend to copy.
Press Alt+;. Excel changes the selection so that hidden cells within the selected area are excluded.
Check the selection if the operation is important. You can then copy with Ctrl+C, apply formatting, or perform another action on the selected cells.

For a menu-based method, select the range, open Home > Find & Select > Go To Special, choose Visible cells only, and select OK. The Go To Special dialog includes other selection options too, so make sure Visible cells only is the option chosen before confirming.

If you prefer the keyboard route through that dialog, press Ctrl+G or F5 to open Go To, choose Special, select Visible cells only, and confirm. The Alt+; shortcut is usually quicker once you know it; the dialog is easier to remember and makes the selection choice explicit.

A filtered-list example

Imagine a sales list with a header row and records for several regions. You filter the Region column to show only West, then select the visible cells in the Amount column. The worksheet still contains East and Central records, but their rows are hidden by the filter. Pressing Alt+; limits the selection to the visible cells within the range you selected.

If you copy that selection and paste it elsewhere, the copied cells represent the visible records rather than every cell in the original rectangular range. This is helpful when preparing a small report from a larger table, or when copying filtered results to a separate worksheet for review.

There is one important boundary: Excel works from the selection you give it. If you select only part of the data, the shortcut does not automatically expand that selection to every related column or every record in the table. Select the full area you actually intend to act on first, then use the shortcut.

Why selecting visible cells matters when copying

A filtered range can look like a continuous list even though some of its rows are hidden between the visible ones. Selecting a block and copying it without first limiting the selection to visible cells can include hidden cells in the copied area. That may bring along records you did not mean to include, especially when the destination is a new sheet or an email attachment.

Using Alt+; before copying is a practical way to avoid that mismatch. After you copy, the moving border shows the copied area; paste the result into a suitable destination and review the output before sharing or using it. The visible-cells command itself does not change the source data, so you can clear the filter later without losing records.

Be cautious when pasting into a filtered destination. A paste operation does not always behave like a deliberate one-cell-at-a-time entry into visible rows, and hidden destination rows can be affected depending on the selected destination and operation. If it is essential that only displayed records change, test on a copy of the workbook or use a workflow that explicitly targets those visible cells, then verify the hidden records afterward.

Common problems and how to fix them

The shortcut seems to do nothing: Confirm that you selected a range containing hidden rows or columns. If every cell in the selection is visible, the resulting selection may look unchanged.
The wrong cells are selected: Excel only limits the selection you already made. Reselect the intended range, then press Alt+; again.
The semicolon key is awkward on your keyboard: Keyboard layouts differ. Use the Go To Special menu path instead of assuming the key combination will be identical on every layout.
You can still see hidden data elsewhere: Visible cells only changes the selection, not the worksheet’s visibility settings. Clear the filter or unhide rows and columns to see those cells again.
A paste gives an unexpected result: Check whether the copied selection consists of separate visible areas and whether the destination is also filtered. Try the operation on a workbook copy and inspect both visible and hidden records.

Also distinguish filtered-out rows from deleted rows. A filter hides records temporarily; it does not delete them. The visible-cells shortcut selects around those hidden records for the current operation, but it does not alter the filter criteria or the underlying table.

Shortcut, Go To Special, and other options

Alt+; is the fastest direct method on Windows. Go To Special is a useful alternative if you forget the shortcut, have trouble entering it, or want to see the selection option in a dialog. Both methods perform the same kind of visible-cells-only selection on the selected range.

For repeatable work, a filtered Excel Table can make it easier to manage records: use the filter arrows in the header row to show the records you need, select the intended cells, and then use Alt+;. You can also copy the filtered results to another location and review them there. These options do not replace the shortcut; they help make the range and the intended records clearer before you use it.

There is no need to select visible cells only just to apply a filter. Filtering controls which records are displayed. The shortcut becomes relevant when you need to take an action on a selection and want hidden cells within that selection excluded, particularly when copying.

Excel for Mac and Excel for the web

The Windows shortcut Alt+; should not be assumed to work the same way on a Mac. In Excel for Microsoft 365 for Mac, the visible-cells-only shortcut is commonly Command+Shift+Z, but keyboard mappings can vary with the Excel release and keyboard configuration. If it does not work, use the ribbon route: select the range, then choose Home > Find & Select > Go To Special > Visible cells only, if that command is available in your version.

Excel for the web can differ from the desktop application in keyboard shortcuts and available selection commands. If the desktop shortcut or Go To Special option is unavailable in your browser session, use Excel for Windows or Mac for this specific selection workflow rather than relying on an unverified browser shortcut. The workbook’s filters and hidden rows can still affect what is displayed, but the desktop steps described above are for Microsoft 365 on Windows.

Frequently Asked Questions

What is the Excel shortcut to select visible cells only?
In Excel for Microsoft 365 on Windows, select the range and press Alt+;. The shortcut selects visible cells within that selection.

Does Alt+; work on filtered rows?
Yes. If you select a range that includes rows hidden by a filter, the shortcut excludes those hidden cells from the selection. It does not change the filter or delete the hidden records.

How do I select visible cells without a shortcut?
Select the range, then choose Home > Find & Select > Go To Special > Visible cells only and confirm. You can also open Go To with Ctrl+G or F5, choose Special, and select the same option.

Does the shortcut unhide rows?
No. It only changes the selection. To display filtered-out rows, clear or change the filter; to display manually hidden rows, unhide them separately.

Can I use the same shortcut in Excel for Mac?
Windows Alt+; is not the Mac equivalent. Command+Shift+Z is commonly used in Excel for Mac, but if it is unavailable in your setup, use Go To Special where offered or check the current shortcut listing for your Excel version.

Why should I use visible cells only before copying?
A filtered selection can include hidden rows unless you restrict it to visible cells. Using the command helps copy the displayed records rather than unintended hidden records; review the pasted result, particularly when the destination is filtered too.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.