How to Copy Only Visible Cells in Excel

A filter in Excel hides rows. It does not remove them from a normal copy. Select a filtered block, press Ctrl+C, paste into a new sheet or an email, and the hidden rows come back. That is the designed behavior, and it is the source of a long trail of “why did my paste include last quarter?” tickets.

Microsoft documents a separate selection mode for this: Go To Special > Visible cells only. After that selection, Ctrl+C puts only the visible cells on the clipboard. This guide is that path, plus the cases where it still surprises people, and what Windows clipboard history does with an Excel copy.

Why a normal copy includes hidden cells

Excel stores a contiguous range. A filter or a manually hidden row changes what you see, not what the range *is*. Ctrl+C on A1:D200 copies A1:D200. Hidden rows in the middle are still in that rectangle.

That is useful when the intent is “duplicate this block, filters and all.” It is harmful when the intent is “send only the rows I can see.”

Two different hide mechanisms exist:

If the paste must stay a table you can sort, prefer values on a new sheet rather than a picture of the sheet. A screenshot is a last resort; see How to Put a Screenshot on the Clipboard.

Official steps: Go To Special

Microsoft Support’s “Copy visible cells only” article is the source of this sequence.

1. Select the cells to copy. Include headers if the paste should keep them. Click any single cell afterward only if you need to cancel a bad selection; a new click replaces the range.
2. On the Home tab, open Find & Select, then Go To Special.
3. Select Visible cells only, then OK.
4. Press Ctrl+C, or Home > Copy.
5. Click the upper-left cell of the paste area (same sheet, another sheet, or another workbook).
6. Press Ctrl+V.

Keyboard-only version of steps 2–3:

1. With the range selected, press Ctrl+G (Go To).
2. Select Special.
3. Select Visible cells only, then OK.
4. Press Ctrl+C.

After Visible cells only, Excel draws a thin outline around each visible block. That broken outline is the confirmation. If the selection still looks like one solid rectangle through hidden rows, the command did not apply — run Go To Special again before copying.

What lands on the Windows clipboard

Excel publishes several formats at once: its own BIFF/XML spreadsheet formats, HTML, and plain text. The destination picks one.

• Paste back into Excel: you usually get cells, formulas or values depending on Paste options.
• Paste into Word or Outlook: you often get an HTML table.
• Paste into Notepad: tab-separated text of the visible cells.

Windows clipboard history is not Excel’s Office Clipboard. They are different lists:

A large visible-cell copy can exceed 4 MB of HTML. Microsoft Support states items over that size do not join Windows history. Ctrl+V can still paste the last copy. Win+V will not show a card for it. That is the same cap discussed in Windows Clipboard 4 MB Cap: What Gets Dropped.

History must be enabled or Win+V only prompts to turn it on: How to Enable Clipboard History in Windows 11.

Filtered tables versus hidden rows

AutoFilter on a range or a Table. Apply the filter, select from the header through the last visible row, then Visible cells only, then copy. If you skip Visible cells only, paste includes the filtered-out rows.

Table objects. Clicking the table and pressing Ctrl+A once selects the data; twice may include headers. Still run Visible cells only after a filter. Excel Tables do not change the copy-hidden-rows rule.

Manually hidden columns. A report that hides column C still copies column C unless you select visible cells. After Visible cells only, paste into a new sheet will skip C and shift the remaining columns left. Formulas that pointed at C will not retarget themselves. Paste Values if the paste is a hand-off, not a living model.

Grouped outlines. Collapse to the summary level, select the summary block, Visible cells only, copy. The detail rows stay behind.

Paste options that matter after a visible-only copy

The copy is only half the job.

1. Paste (Ctrl+V) — closest to the source, including formulas. Hidden-row formulas that referenced skipped rows can return unexpected results. Prefer this only when pasting inside the same workbook and you understand the references.
2. Paste Values — static numbers and text. Safest for email, a CSV-bound sheet, or another team.
3. Paste Formulas — rarely what a filtered extract needs.
4. Paste Formatting — does not include values.
5. Keep Source Column Widths — use after values if the extract must stay readable.

If the paste must go to another app as a picture (a slide, a ticket), copy the visible cells, then in Excel use Copy as Picture (Home > Copy arrow, on builds that still expose it) or snip the sheet. A picture will not appear as a reusable file in Win+V; history stores bitmaps only when the payload is a bitmap under 4 MB.

Common failures

“I used a filter and still pasted everything.” The extra Go To Special step was skipped. Filtering changes the view. It does not change the copy range by itself.

“Visible cells only is greyed out.” The sheet may be protected, or the selection is a single cell with nothing hidden. Unprotect, or select the full filtered block first.

“I selected the whole sheet and Excel copied a million empty rows.” Select the used range (Ctrl+End to find it, or click the first header and Ctrl+Shift+End) before Go To Special. Used-range bloat is a separate Excel problem.

“Paste into Outlook added the hidden rows again.” Outlook is pasting what was on the clipboard. If the copy happened before Visible cells only, the hidden rows are already in the payload. Copy again.

“Win+V is empty.” History is off, the item was larger than 4 MB, or the PC restarted and the item was unpinned. See What Win+V Actually Opens on Windows 11.

“I needed a webpage table, not an Excel filter.” That is a different copy: How to Copy a Table From a Webpage Intact.

A repeatable extract checklist

Use this when sending a filtered cut every week:

1. Confirm the filter (or hidden rows) shows only the intended records.
2. Select the header and the visible data. Do not select entire worksheet columns unless that is deliberate.
3. Home > Find & Select > Go To Special > Visible cells only > OK.
4. Confirm the broken selection outline.
5. Ctrl+C.
6. Open a new workbook or a dedicated “Extract” sheet. Paste Values.
7. Scan row counts: visible rows on the source should match pasted rows.
8. Save the extract. Do not rely on Win+V after a reboot.

What this will never do

Windows clipboard history will not remember fifty weekly extracts. It keeps 25 items, drops older unpinned ones, and forgets unpinned history at restart. It does not store the .xlsx file you copied in File Explorer as a history card. Excel’s own Office Clipboard is also not a document library.

If the workflow is “keep this extract, last week’s extract, and a CSV export on a shelf I can drag into mail,” that is beyond built-in history. A local shelf such as Edge Drop is optional for that staging job. It is not a substitute for Go To Special, and it is not required to copy visible cells once.

Related reading

• How to Put a Screenshot on the Clipboard
• Print Screen vs Win+Shift+S vs Snipping Tool
• How to Enable Clipboard History in Windows 11
• Windows Clipboard History Limit: Why Only 25 Items

Sources

• Copy visible cells only (Microsoft Support) — official Home > Find & Select > Go To Special > Visible cells only sequence.
• Move or copy cells, rows, and columns (Microsoft Support) — same Visible cells only path in the move/copy article.
• Find and select cells that meet specific conditions (Microsoft Support) — documents Visible cells only as cells visible across hidden rows or columns.
• Using the clipboard (Microsoft Support) — Windows history limits (25 items, 4 MB, text/HTML/bitmap) that apply after an Excel copy.
• Copy and paste using the Office Clipboard (Microsoft Support) — the separate 24-item Office Clipboard, not Win+V.

Copy. Stack. Drop.

Transform your clipboard into an interactive edge shelf. Stack, pin, and drag assets into any app with zero friction.

Download for Windows Get from Microsoft Store

How to Install Guide · First 10 Minutes Guide · Drag & Drop Guide · Edge-Drop vs Win+V · Support