To copy only the rows visible after filtering in Excel, select the cells you need, choose Home > Find & Select > Go To Special > Visible cells only, and select OK. Press Ctrl+C, click the destination, and press Ctrl+V. On Windows, Alt+; is a shortcut for selecting visible cells only; using that step makes it clear that filtered-out rows should not be included.
The quick method for a filtered list
For a typical worksheet with an AutoFilter, follow these steps. Select the data cells you want to copy, rather than the whole worksheet, unless you intentionally need every column and the header.
- Apply your filter using the drop-down arrows in the header row.
- Select the cells to copy. You can select one column, several columns, or the full filtered data range.
- On Windows, press Alt+; to limit the selection to visible cells. Alternatively, open Home > Find & Select > Go To Special, choose Visible cells only, and select OK.
- Press Ctrl+C. The selected cells will have a moving dashed outline.
- Click the top-left cell of an empty destination and press Ctrl+V.
Look at the pasted result before continuing. It should contain the displayed records, with filtered-out records omitted. If you are copying more than one column, check that the columns remain in the expected order and that the header was included or excluded as intended.
Why select visible cells only?
A filter hides rows from view; it does not delete them. A range selected across the filtered list can therefore cover cells in both displayed and hidden rows. Excel distinguishes between the range you selected and the cells that are currently visible, and relying on an implicit selection can make the result confusing, especially when the range contains other hidden rows or you have selected a large block.
Visible cells only narrows the selection to the cells Excel is showing. It is useful when the requirement is specifically to copy the filtered results, not the underlying records that did not match. The same command is helpful when rows or columns were hidden manually, not just hidden by a filter.
For example, imagine a sales list with 200 records and a filter showing 18 orders from the West region. Selecting the list and explicitly choosing visible cells only tells Excel to copy those 18 displayed records, plus any selected header or other visible cells. It does not remove or alter the other 182 records in the original list.
Select the right range before copying
Decide whether the destination needs a header row, totals, or only the filtered records. If you select the entire table including its headings, the heading will be copied too. If you select only the body of the table, the pasted result will contain data rows without headings. Avoid selecting unrelated cells beside the list: Excel may copy them as well.
When you click and drag across a filtered range, take care not to stop at the first visible gap or accidentally leave out a column. You can select a rectangular range that spans the filtered records, then use Visible cells only to exclude hidden rows. If you need several nonadjacent columns, select them deliberately; complex, noncontiguous selections can be harder to paste cleanly than one rectangular block.
For a formatted Excel table, include only the table columns you need. A table may have a header row and, if enabled, a Total Row. Select the Total Row only if its summary value belongs in the copied output. Filtering changes which data rows are displayed, but it does not change the table’s structure.
Where to paste the copied results
The simplest destination is an empty area on an unfiltered worksheet. Click its top-left cell and paste; Excel places the copied rows and columns starting there. Leave enough blank space to the right and below so the pasted range does not overwrite existing information. If the destination has existing data, make a copy of the sheet or choose a clear staging area first.
Copying visible rows from a filtered list and pasting them into a normal, unfiltered area is also a useful way to create a compact extract. The rows that were hidden by the source filter are not meant to appear in that extract. If you paste over cells that already contain information, Excel replaces those cells, so confirm the destination before pressing Ctrl+V.
Be more cautious when the destination itself is filtered. A selection of visible cells is not a promise that Excel will map pasted values only to the visible destination records in the way you expect. The visible source rows and the destination’s visible rows may not line up, and a paste into a filtered range can be difficult to inspect. For dependable results, paste into an unfiltered staging range, then sort, filter, or copy the finished data into its final location after checking the row alignment.
Choose whether to copy values, formulas, or formatting
Ctrl+V performs a regular paste, which may bring across values, formulas, number formats, cell formatting, and other copied cell properties. That is appropriate when you want a close copy of the source. If you only need the displayed results, use Home > Paste > Values after copying, or open the Paste Options menu and choose the values option. The exact icons can vary with the ribbon layout, but the command is labeled Values.
Formulas deserve a check after pasting. A formula copied to a new location may adjust its relative cell references, just as it does in an ordinary Excel copy-and-paste operation. If you want the current calculated answers rather than working formulas, paste values. If you want formulas that continue to update, keep the formulas and inspect a few of the pasted cells in the formula bar.
Formatting can also carry over when you use regular paste. If the destination has its own formatting and you want to preserve it, use Home > Paste > Values or choose a suitable paste option instead of a full paste. For a clean extract, decide in advance whether the destination should inherit the source’s appearance or retain its existing style.
Common problems and how to avoid them
- Hidden records appear in the result: Select Visible cells only before copying. Do not assume that a large selection excludes every hidden cell in every situation.
- The header is missing or repeated: Check whether your selection began at the header row. Include it once if the pasted list needs column names; leave it out if the destination already has headings.
- Excel says the action cannot be performed on multiple selections: Visible cells in a filtered range can form separate areas. Try copying a single rectangular block of columns, paste into an empty unfiltered range, and avoid combining unrelated nonadjacent selections.
- The pasted list has unexpected gaps: Check whether blank cells are part of the visible source data, whether the selection covered extra columns, and whether the destination was filtered. Paste into a blank unfiltered area to make the copied shape easier to review.
- The wrong rows are copied: Confirm the filter criteria and the visible records before selecting. A filter can have multiple criteria, and changing a filter changes which rows are displayed.
- The paste overwrites data: Undo immediately with Ctrl+Z if the paste was unintended and the workbook has not undergone another action that prevents undo. Otherwise, restore from a saved copy or version history if available.
A common misconception is that filtering deletes the rows that disappear from view. It does not: the records remain in the worksheet and can reappear when the filter is cleared. Copying a filtered extract is different from deleting unwanted records, so preserve the original data if you may need it later.
Windows, Mac, and Excel for the web
The steps and shortcuts above are for Excel for Microsoft 365 on Windows. The Windows shortcut Alt+; selects visible cells only, while Ctrl+C and Ctrl+V copy and paste. If you prefer not to use the shortcut, the Go To Special command provides the same explicit selection step.
In Excel for Mac, the Ctrl-based copy and paste shortcuts are generally Command+C and Command+V. The Windows Alt+; shortcut is not the Mac equivalent. Use the Go To Special command from the Excel menus or ribbon to choose Visible cells only; menu placement and labels can vary somewhat by Mac version. If you cannot find the command, consult Excel’s menu search or open the workbook in desktop Excel for Windows to use the documented Alt+; shortcut.
Excel for the web has a different interface and does not provide the same desktop keyboard workflow in every build. If the web version does not show a Visible cells only command, do not assume that a copied selection will handle hidden rows exactly as you intend. Open the workbook in the desktop app for explicit control, or paste a small test into a blank area and verify the result before relying on it.
Frequently Asked Questions
Does Ctrl+C copy only visible rows after a filter?
For a dependable result, explicitly select Visible cells only before pressing Ctrl+C. This avoids relying on how a particular selection handles hidden or filtered cells and makes your intention clear.
What is the shortcut to copy visible cells only in Excel?
In Excel for Microsoft 365 on Windows, select the range and press Alt+;, then press Ctrl+C. On Mac, use the Go To Special menu command rather than assuming the Windows shortcut applies.
Can I paste filtered rows into another filtered list?
You can copy and paste data between filtered areas, but matching visible rows is easy to get wrong. Use an unfiltered staging area, check the row order and count, and then move the verified results to their destination.
Will copying filtered rows delete the hidden rows?
No. Copying creates a separate copy; it does not delete records from the source. Clear the filter to show the other records again.
How do I paste just the results, not the formulas?
Copy the visible cells, then use Home > Paste > Values at the destination. This pastes calculated values rather than carrying the source formulas into the new range.
Related
- Excel Named Range Rules: Names, Scope, and Limits
- Excel Named Range Scope: Workbook vs. Worksheet Names
- Excel Named Range Manager: How to View and Edit Names
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add a Running Header in Word for Every PageTo add a running header in Word, choose Insert > Header, select a layout, and type the text…
- Analysis for Excel: How to Use the Analysis ToolPakIf you mean the analysis app or feature in Excel, it is usually the Analysis ToolPak: a free-included…
- Data Validation Plan in Excel: Build Reliable ChecksA data validation plan is a clear set of rules for what information a worksheet will accept, how…
- Excel Power Query Tutorial: Clean and Combine DataExcel Power Query is a built-in tool for importing, cleaning, reshaping, and combining data, then loading the results…
- Using Solver in Excel to Maximize Profit Step by StepYes. In Excel for Microsoft 365 on Windows, use Solver to maximize a cell containing your profit formula…
- How to Archive Emails in Outlook on Windows 11To archive an email in Outlook on Windows 11, select the message and choose Archive on the toolbar.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.