Excel Visible Cells Only Shortcut: How It Works in Excel

In Excel for Microsoft 365 on Windows, select the range you want and press Alt+; (semicolon) to select visible cells only. To use the ribbon instead, choose Home > Find & Select > Go To Special > Visible cells only; this is useful before copying or changing filtered data.

The shortcut and what it does

The Windows shortcut is Alt+;. It does not turn filtering on or hide anything. It changes the selection so that cells hidden by a filter or by manually hidden rows or columns are left out. Once the selection is limited to visible cells, you can copy, format, clear, or enter data without deliberately including the hidden cells.

The order matters: first select the range, then invoke the shortcut. For example, if a filtered table occupies A1:D100, select the part of the table you want to copy, including its header if needed, and press Alt+;. Then press Ctrl+C and paste where you want the visible records to appear. The shortcut applies to the current selection, not automatically to every cell on the worksheet.

On Excel for Mac, the corresponding shortcut commonly listed is Command+Shift+Z. Shortcuts can vary with Excel version, keyboard layout, or system settings, so use the Go To Special menu command if that key combination does not work. In Excel for the web, use the available selection and copy options in the browser interface; desktop keyboard shortcuts and selection behavior may not all be available there.

How to select visible cells step by step

For a filtered list, select the range you intend to work with rather than the entire worksheet. Then use the shortcut and continue with the task. These steps are a dependable pattern for copying just the displayed records:

Apply a filter, if you have not already, using Data > Filter or the filter controls on the table.
Select the cells to copy. Include the header only if you want it in the copied output.
Press Alt+; on Windows. Excel keeps the visible cells in the selection and excludes hidden ones.
Press Ctrl+C, click the destination cell, and press Ctrl+V.
Check the pasted result, especially if the source selection consisted of separated visible blocks.

For example, suppose a sales table has rows for several regions and a filter displays only North. Selecting the table’s data columns and copying normally can include hidden filtered rows in some Excel operations. Selecting visible cells only first tells Excel to copy the displayed North records, rather than the rows currently removed from view by the filter.

What Excel counts as visible

Visible cells are cells that are not hidden at the time you make the selection. This includes cells in rows or columns still shown after filtering, as well as cells in rows or columns that were hidden manually. When the selected range contains gaps caused by hidden rows, the visible cells form multiple separate areas instead of one uninterrupted rectangle.

That distinction is useful because hiding is not the same as deleting. A filter hides records that do not meet its criteria, but those records remain in the worksheet and can reappear when the filter changes. Manually hidden rows also remain in the workbook. The visible-cells command lets you target what is currently displayed without removing the underlying information.

It also does not decide which records are correct or permanently exclude hidden data from the workbook. A formula, chart, or later operation may still refer to hidden cells, depending on the feature used. The shortcut is a selection tool, not a privacy feature or a replacement for deleting or protecting data.

Copying filtered data without hidden rows

Copying is the most familiar reason to use this shortcut. Excel’s behavior around filtered ranges can surprise people: the screen shows a subset, but the underlying range still includes records that the filter hides. Selecting visible cells only makes the intended copy explicit. This is particularly helpful when preparing a temporary extract for an email, report, or separate worksheet.

If the visible records are separated by hidden rows, the copied selection can contain multiple areas. Pasting those areas into a destination that does not match their shape may produce a warning or an unexpected layout. For a clean extract, paste into a blank area and inspect the result before using it. If you need a simple contiguous list, consider copying the displayed cells and checking that the destination contains the expected number of records and columns.

When copying only one column from a filtered table, select that column’s data cells rather than the whole worksheet column if you do not want a large, mostly empty paste. If the header should travel with the records, include it in the original selection. Selecting visible cells only does not add or remove a header on your behalf.

Editing or formatting visible cells

The command is not limited to copying. After selecting a range and restricting it to visible cells, you can apply formatting, clear contents, or make other changes to the selected cells. For instance, if a filter displays overdue invoices, select the status cells, press Alt+;, and apply a fill color. Hidden records are not included in that selection, so their formatting remains unchanged.

You can also enter the same value into multiple visible cells. Select the relevant range, press Alt+;, type the value, and press Ctrl+Enter on Windows. For example, entering “Checked” this way can mark the currently displayed cells without filling the hidden rows. Be careful with formulas and values that should vary by row: a single entry may not produce the row-specific result you intend. Check a small sample or use a method designed for filling formulas before applying a change broadly.

Before clearing or replacing data, confirm the selection visually and make sure the filter criteria are right. Selecting visible cells only prevents hidden cells from being part of that particular selection, but it cannot protect against choosing the wrong visible records or the wrong columns.

Using Go To Special instead

If the shortcut is unavailable, or you prefer a visible command, use Excel’s Go To Special dialog. Select the range first, then choose Home > Find & Select > Go To Special > Visible cells only, and select OK. Excel narrows the current selection to its visible cells, just as the shortcut does. The dialog is also helpful when you want to confirm the name of the command or are using a keyboard where the shortcut is inconvenient.

Do not confuse this option with Go To or Find. Go To Special offers several ways to select particular kinds of cells, while Visible cells only is specifically for excluding hidden cells from the current selection. It does not change the filter, unhide anything, or create a new copy. You still need to perform the next action, such as copying or applying formatting.

Common problems and misconceptions

The shortcut seems to do nothing. Confirm that a range is selected and that some of it is hidden, or use the menu command to verify the selection. With no hidden cells in the range, the visible selection may look unchanged.
Hidden rows appear in the pasted result. Make sure you used the shortcut after selecting the source and before copying. Selecting only the cells you can see on screen is not always the same as explicitly selecting visible cells only.
The paste is irregular or Excel shows a warning. A filtered selection may consist of several separate areas. Try pasting into a blank worksheet area, and check whether the destination can accommodate the selection’s shape.
The shortcut types a character or triggers another command. Keyboard layouts and platform settings can affect key combinations. On Windows, press the semicolon key while holding Alt; if that fails, use Home > Find & Select > Go To Special.
You expected hidden data to be removed. The command only changes the selection. Filtered or manually hidden records remain in the workbook and can become visible again.

A related misconception is that Excel’s filter automatically makes every operation act on visible records only. Some actions do behave in ways that respect filtering, but you should not assume that for every copy, edit, or formatting task. When the distinction matters, explicitly select visible cells and inspect the result.

Frequently Asked Questions

What is the Excel shortcut for visible cells only?
In Excel for Microsoft 365 on Windows, select a range and press Alt+; (semicolon). On Mac, Command+Shift+Z is commonly used; if it does not work in your setup, use Go To Special from the Home tab.

How do I copy only filtered rows in Excel?
Select the cells you want to copy, press Alt+; on Windows, then press Ctrl+C and paste. Check the destination because visible rows may make the copied selection consist of separate areas.

Does selecting visible cells only delete hidden rows?
No. It excludes hidden cells from the current selection. The hidden rows or columns remain in the worksheet and can be shown again by changing the filter or unhiding them.

Can I use this shortcut on manually hidden rows?
Yes. It selects visible cells within the range whether the excluded rows or columns are hidden by a filter or hidden manually.

What is the menu path for visible cells only?
Select the range, then choose Home > Find & Select > Go To Special > Visible cells only, and click OK. This provides the same selection result as the shortcut.

When to use the shortcut

Use the visible-cells shortcut when your task should affect only what is currently displayed: copying filtered records, formatting a filtered subset, or entering a common value into visible cells. Use the menu if you cannot remember the key combination or if your keyboard behaves differently. In either case, select a deliberate range, verify the filter, and review the result before relying on a copied or edited extract.

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.