How to Not Copy Hidden Cells in Excel When Pasting

To copy only the cells you can see in Excel, select the range, choose Home > Find & Select > Go To Special > Visible cells only, then copy and paste. In Excel for Microsoft 365 on Windows, you can use Alt+; after selecting the range instead. This keeps values in hidden rows or columns out of the copied selection, including rows hidden by a filter.

Use this when you want to copy a filtered list, a worksheet with manually hidden rows, or a range where some columns are hidden. The setting applies to the selection you make; it does not change or unhide the source data.

What You’ll Need

An Excel workbook containing hidden rows or columns, or a filtered range.
A destination area for the copied cells. For the most predictable result, choose a blank, unfiltered area with enough room.
Excel for Microsoft 365 on Windows for the keyboard shortcut in this guide. In Excel for Mac, use the Go To Special command if it is available in your version; Excel for the web may not offer the same visible-cells-only workflow, so open the workbook in desktop Excel if needed.

Step-by-Step

Identify the source range. Decide which cells you want to copy, including the rows or columns that are currently hidden. For example, to copy a filtered list with headings, select the heading and the full data range, not just the first visible few rows. If you select only visible cells before choosing the command, Excel has no hidden cells in that selection to exclude, though the result will still be the selected cells.
Select the full range to copy. Drag across the cells or click the first cell, then use Shift-click on the last cell. You can also click the Name Box to the left of the formula bar, type a range such as A1:D40, and press Enter. Use the actual range from your sheet. Avoid selecting entire worksheet columns or rows unless that is genuinely what you need; a compact range is easier to verify and paste.
Choose Visible cells only. On Windows, press Alt+; (Alt plus the semicolon key). Or use Home > Find & Select > Go To Special, select Visible cells only, and click OK. The selection may look like separate blocks because Excel has skipped hidden rows or columns. That is expected; the blocks are still part of the visible-only selection.
Copy the selection. Press Ctrl+C, or choose Home > Copy. A moving dashed outline usually appears around the copied cells. Do not click elsewhere and make a new selection before copying; doing so replaces the visible-only selection you just made.
Choose a suitable destination. Click a blank starting cell outside the source range, preferably in an unfiltered area with no hidden rows or columns. Leave enough open cells for the visible content. If you paste into a filtered or partly hidden destination, the destination’s visibility can affect where data goes, so it is safer to paste into a clean area first and review the result.
Paste and check the result. Press Ctrl+V. The copied content should contain the visible source cells and omit the hidden ones. For example, if source rows 2, 3, 6, and 7 are visible while rows 4 and 5 are hidden, the pasted list should contain the values from rows 2, 3, 6, and 7 in sequence, without the values from rows 4 and 5. Check the first and last pasted records and compare the number of pasted rows with the number of visible source rows.
Finish with the right paste option, if needed. A normal paste can bring across cell formatting as well as values. If you only need the data, use Home > Paste > Values after copying, or use the paste options button that appears near the pasted range and choose Values. If you need formulas or formatting, keep the normal paste and inspect those separately.
Clear the copy outline when you are done. Press Esc to stop the moving dashed border. This does not undo the paste; it simply ends copy mode. Save the workbook after confirming the destination contains the intended rows and columns.

Mac and web notes: Keyboard shortcuts can differ between Windows and Mac, and the Windows Alt+; shortcut should not be assumed to work on a Mac keyboard. In desktop Excel for Mac, look for Go To Special from the Home tab’s Find & Select controls, or use the Go To dialog and its Special option if shown in your version. In Excel for the web, if you cannot find a Visible cells only option, open the file in the desktop app and follow the steps there. Menu labels and available commands can vary by release.

Common Mistakes

Copying before selecting visible cells only. Hiding a row does not automatically remove its cells from a normal copy. If you select a range and press Ctrl+C without using Visible cells only, hidden cells may be included. Re-select the source range, apply the command, and copy again.
Confusing filtering with deletion. A filter hides records from view; it does not remove them from the worksheet. Select the full filtered range and explicitly choose Visible cells only before copying. Do not assume that the filtered appearance alone guarantees a visible-only copy.
Selecting an incomplete source range. If the selection misses a column, heading, or visible row, the paste cannot include it. Check the selection border before applying the command. When copying a table, include the columns you want and the relevant heading row intentionally.
Applying the command to the wrong selection. Go To Special works on the current selection. If you selected a different range or clicked another cell in between, Excel may copy the wrong cells. Cancel the copy, select the intended source range again, and repeat the visible-cells step.
Pasting into a destination with its own hidden cells. Visible-only selection controls which source cells are copied; it does not automatically make a filtered destination safe. For a clear result, paste into a blank unfiltered range, then move or use the result as required.
Expecting formulas or formatting to become values. Visible cells only controls which cells are included, not what is pasted from each cell. Use the Values paste option if you want displayed results rather than formulas, and check formatting if it matters.

Tips

Use the keyboard shortcut only after selecting the range. In Windows desktop Excel, Alt+; is a quick way to select visible cells only. If it does not appear to do anything, use the Go To Special dialog instead so you can see the option selected.
Keep the source and destination distinct. Pasting over the source can replace data you meant to keep, especially when filters or hidden rows make the layout hard to read. Paste to a new sheet or a blank part of the workbook first if the original data is important.
Check row counts before relying on the copy. Count the visible records, excluding a heading if appropriate, and compare them with the pasted result. This quick check can reveal an accidentally omitted row or a hidden record that slipped through.
Be deliberate with headings and totals. If you want headings in the copied result, include them in the selected range. If a subtotal or grand-total row is visible, it will be copied too. Remove it from the source selection if you only want detail records.
Choose paste type to suit the job. A normal paste preserves more of the original cells, while Values is useful for a static list or when you do not want formulas linked to the source. The visible-only selection and the paste type are separate choices.
Remember that hidden columns count too. The same command excludes hidden columns as well as hidden rows. If you need a subset of visible columns but want all rows, select the full intended range and use Visible cells only; then inspect the pasted column order.

Troubleshooting

The pasted result includes hidden records. The most likely cause is that the source was copied normally. Select the original range again, use Home > Find & Select > Go To Special > Visible cells only, and only then copy. If the rows are filtered, make sure the selection includes the filtered data range rather than a separate, incomplete set of cells.

The Visible cells only option is unavailable or the shortcut does nothing. Confirm that you are using desktop Excel and that a cell range is selected. Open the Go To Special dialog from the Home tab rather than relying on a keyboard shortcut. In Excel for the web, switch to the desktop app if the command is not offered. On Mac, use the available Go To Special dialog rather than assuming the Windows shortcut applies.

Excel displays an error when you paste. Try pasting into an empty, unmerged, unfiltered range on a worksheet. Merged cells or an incompatible destination layout can prevent a copied selection from fitting. If the source selection contains separate visible blocks, avoid selecting a destination that is itself a scattered set of cells; paste into a simple blank area first, then arrange the result.

The result has the wrong number of columns or rows. Undo the paste with Ctrl+Z on Windows (or Command+Z on Mac), then check the source range and the hidden row or column boundaries. Reapply Visible cells only to the corrected selection, copy, and paste again. If you have already made other changes, check before undoing so you do not remove unrelated work.

Values appear, but formulas or formatting are not what you expected. Decide whether you need formulas, displayed values, or formatting. Visible cells only does not change cell contents or paste behavior. Repeat the copy and select the appropriate option under Home > Paste. If formulas refer to other cells, inspect a pasted formula before filling or distributing it further.

Frequently Asked Questions

Does Excel copy hidden rows by default?

Yes. A regular copy of a range can include cells in hidden rows or columns. Use Visible cells only before copying when you want to leave those cells out.

Does this work with filtered rows?

Yes. Select the range that contains the filtered list, choose Visible cells only, and then copy. The hidden-by-filter records are excluded from the copied selection.

Will it work for rows I hid manually?

Yes. The command excludes cells in rows or columns hidden manually as well as cells hidden by a filter. It does not matter why those cells are hidden.

Can I copy only visible cells without using the mouse?

In Excel for Microsoft 365 on Windows, select the range and press Alt+;, then press Ctrl+C. On Mac, use the Go To Special route available in your desktop version rather than relying on the Windows shortcut.

Does Visible cells only change the source worksheet?

No. It changes which cells are selected for the copy. It does not unhide rows or columns, delete records, or change the source values.

Can I paste the visible cells into a filtered destination?

You can encounter confusing results when the destination also has hidden rows or columns. For a reliable outcome, paste into a blank, unfiltered range first, verify the result, and then place it where it is needed.

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.