Select Visible Cells? Excel Shortcut & Guide
This article explains what “Select Visible Cells” does in spreadsheet programs like Microsoft Excel and Google Sheets, how to use it, and why it matters when working with filtered or hidden data. You’ll learn the keyboard shortcuts, the menu commands, and the common pitfalls that cause the feature to behave unexpectedly.
What Does “Select Visible Cells” Mean?
When you filter a column or manually hide rows or columns, the hidden data is still part of the sheet—it just isn’t displayed. Normally, if you select a range and copy it, the hidden rows or columns are included. “Select Visible Cells” changes that: it restricts the selection to only the cells that are currently visible on screen. This is essential for copying, formatting, or deleting only the filtered or unhidden data.
Without this feature, a simple copy-and-paste of a filtered list will also copy the hidden rows, which often leads to pasting unwanted data. The command essentially acts as a boundary, telling the program to ignore anything that is not currently shown.
The Keyboard Shortcut (Windows and Mac)
The most common way to trigger “Select Visible Cells” is with a keyboard shortcut. On Windows, the shortcut is Alt + ; (semicolon). On a Mac, it is Cmd + Shift + Z in Excel, but note that in Google Sheets the shortcut is Alt + ; on both platforms (though on Mac you may need to use the menu).
Here’s the typical workflow:
- Select the range that includes hidden rows or columns.
- Press Alt + ; (Windows) or Cmd + Shift + Z (Mac, Excel).
- Now copy (Ctrl+C / Cmd+C) or delete (Delete key) — only the visible cells are affected.
If you forget the shortcut, you can also use the ribbon: go to the Home tab, click Find & Select (in the Editing group), and choose Go To Special…, then select Visible cells only. In Google Sheets, the equivalent is under Extras (or Data in some versions) → Select visible cells.
Why It’s Needed: The Hidden Data Trap
The main reason this feature exists is to prevent accidental inclusion of hidden data. For example, imagine you have a spreadsheet with 1,000 rows of sales data, and you filter to show only the Eastern region (say 200 rows). If you select those 200 rows and copy them to another sheet, Excel will actually copy all 1,000 rows—including the 800 hidden ones—because the selection includes the entire range. The visible cells command ensures only the 200 filtered rows are copied.
This is especially important when:
- You want to create a new table from a filtered list.
- You need to delete only the visible rows without deleting the hidden ones.
- You want to apply formatting (like bold or color) to only the visible cells.
Without the command, you would have to manually select each row or use a complicated formula, which is error-prone.
How to Use It in Excel (Step-by-Step)
Here’s how to use the feature in Microsoft Excel (2016, 2019, 365, and similar versions):
- Apply a filter to your data (select the header row, go to the Data tab, and click Filter).
- Filter the column to show only the rows you want.
- Select the entire range of filtered data, including the header row if you want it.
- Press Alt + ; on Windows (or Cmd + Shift + Z on Mac). You’ll notice that the selection outline changes—it now only surrounds the visible cells.
- Copy (Ctrl+C / Cmd+C) or delete (Delete key) as needed.
- Paste to a new location. Only the visible cells are pasted.
If you want to select visible cells without filtering (e.g., when you manually hid some rows), the same steps apply—just select the range and use the shortcut.
How to Use It in Google Sheets
Google Sheets has a similar feature, but it’s slightly less prominent. Here’s the method:
- Filter your data (select the data range, go to Data → Create a filter).
- Select the range you want to copy.
- Go to Extras (or Data in some versions) → Select visible cells.
- Copy and paste. Only visible cells are copied.
The keyboard shortcut in Google Sheets is also Alt + ; on Windows and Alt + ; on Mac (though you might need to use the menu if the shortcut doesn’t work). Note that Google Sheets does not have the “Go To Special” dialog; the command is directly under the menu.
Common Mistakes and Misconceptions
One of the most frequent mistakes is forgetting to press the shortcut before copying. If you copy a filtered range without pressing Alt + ;, you will copy hidden rows. Another mistake is applying the command to a range that has no hidden cells—then it does nothing, which is fine.
A common misconception is that “Select Visible Cells” is the same as “Select All” or that it automatically filters data. It does not filter; it only changes the selection to exclude hidden cells. Also, note that the command works with hidden rows and columns, but not with grouped/outlined data that is collapsed. If you have grouped rows and you collapse them, those rows are technically hidden, so the command will exclude them as well.
Another pitfall: if you use the “Go To Special” dialog and choose “Visible cells only,” Excel will select the visible cells, but if you then press Delete, it will delete the visible rows’ contents, not the rows themselves. To delete entire visible rows, you need to delete the rows (right-click → Delete) after selecting visible cells, but be careful—that will shift the hidden rows up, which may not be what you want.
When to Use It vs. When Not To
Use “Select Visible Cells” when you:
- Copy filtered data to another sheet or workbook.
- Delete only visible rows (e.g., after filtering out unwanted items).
- Format only visible cells (like changing font color for filtered results).
Do not use it when you want to include hidden data in your operation. For example, if you need to copy a whole table including hidden rows, you should not use this command. Also, if you are using a formula that references a range, the formula will still reference all cells, including hidden ones—this command only affects manual selection and copy/paste, not formula calculations.
Alternatives to “Select Visible Cells”
If you find yourself using this command often, there are alternatives:
- Copy filtered data to a new sheet: After filtering, select the visible cells, copy, and paste to a new sheet. This is essentially what the command does.
- Use a formula: If you want to extract visible rows dynamically, you can use functions like
FILTER(in Excel 365 and Google Sheets) to create a new array that only includes rows that meet a condition. This avoids the need to manually select visible cells. - Clear filters first: If you want to copy everything, just clear the filter and select the entire range.
For deleting hidden rows, you might also consider using “Go To Special” → “Blanks” if you want to delete rows with blank cells, but that’s a different operation.
Frequently Asked Questions
Why does my copy include hidden rows even after I filter?
Because you didn’t press “Select Visible Cells” before copying. Filtering only hides rows visually; the selection still includes them. You must activate the command (Alt+; on Windows) to restrict the selection to visible cells only.
Does “Select Visible Cells” work in Google Sheets?
Yes, it does. The command is under the Extras menu (or Data in some versions) as “Select visible cells.” The keyboard shortcut is Alt+; on Windows, but on Mac you might need to use the menu because the shortcut may not be assigned.
Can I use “Select Visible Cells” to delete only visible rows?
Yes, but you need to be careful. After selecting visible cells, press Delete to clear their contents. To delete the entire rows, right-click a selected row and choose “Delete,” but note that this will shift the hidden rows up, which may not be what you want. If you want to delete only the visible rows and keep the hidden ones in place, you’ll need to use a different method, like a helper column.
What is the difference between “Select Visible Cells” and “Go To Special” → “Visible cells only”?
They are essentially the same. “Go To Special” is the dialog that contains the “Visible cells only” option. The keyboard shortcut Alt+; directly applies that option without opening the dialog. So they are two ways to do the same thing.
Does the command work with hidden columns?
Yes, it works with both hidden rows and hidden columns. If you hide some columns and then select a range that includes them, pressing Alt+; will exclude the hidden columns from the selection.
Why doesn’t the Alt+; shortcut work in my version of Excel?
It should work in all modern versions of Excel on Windows. If it doesn’t, check if you have a different keyboard layout or if another add-in is interfering. You can always use the menu: Home → Find & Select → Go To Special → Visible cells only.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.