Copy Only Filtered Data in Excel: Step-by-Step

How-to basics · Updated November 20, 2026

To copy only the rows showing after you filter a list in Excel, select the range, choose Home > Find & Select > Go To Special > Visible cells only, then copy and paste. This makes the selection explicit, so filtered-out rows are not included in the copied data. You can paste the visible records into another area, worksheet, or workbook.

Before you start, apply the filter and decide whether you want to copy the column headings as well as the visible records. Excel often excludes filtered-out rows when copying a filtered list, but explicitly selecting visible cells is the safer approach, especially when the range also contains manually hidden rows or columns.

What You’ll Need

  • An Excel workbook with a list or table that has a header row.
  • A filter already applied, or permission to filter the list.
  • A destination area with enough room for the copied records. A blank worksheet is useful if you want to keep the result separate from the original.
  • Microsoft Excel for Microsoft 365 on Windows for the ribbon paths below. Mac and Excel for the web differences are noted where they matter.

Step-by-Step

  1. Apply the filter you need. Click a cell in the list. On Windows, choose Data > Filter to turn on filter arrows if they are not already visible. Open the arrow in the column you want to filter, select or clear the relevant values, and choose OK. For example, choose “West” in a Region column to show only records for the West region. If the list is an Excel table, its header row normally has filter arrows already.
  2. Select the range you intend to copy. Include the header row if the pasted result should have headings; otherwise, select only the data rows and columns you need. You can drag across the range or click its first cell and Shift-click its last cell. Avoid selecting entire worksheet rows or columns unless that is genuinely what you want: selecting just the relevant list range makes the pasted result easier to manage. If you want all columns in a table, include each of those columns in your selection.
  3. Restrict the selection to visible cells. On Windows, go to Home > Find & Select > Go To Special, choose Visible cells only, and select OK. The filtered rows remain visible in the sheet, but the selection now excludes rows hidden by the filter. You can also use the Windows shortcut Alt+; after selecting the range. On Mac, use the Go To Special dialog if the shortcut is unavailable: look under Home > Find & Select, or use Edit > Find > Go To > Special in versions that provide that menu path. Excel for the web may not offer the same Go To Special workflow; see the note below.
  4. Copy the visible selection. Press Ctrl+C on Windows or Command+C on Mac. A moving dashed outline usually appears around the copied cells. Do not change the filter or edit the source while preparing the paste; keeping the selection unchanged makes it easier to confirm you copied the intended records.
  5. Choose one destination cell. Click the top-left cell of an empty destination area. You generally do not need to preselect an area the same size as the source. To put the results on a new worksheet, use the plus button beside the sheet tabs to add a sheet, then click cell A1 or another starting cell. To paste into another workbook, make sure it is open and select the destination cell there.
  6. Paste and check the result. Press Ctrl+V on Windows or Command+V on Mac. Check that the first and last records match the filtered list and that no filtered-out records appear. If you included the header, confirm it appears once at the top. Save the workbook after verifying the pasted data.
  7. Choose how much of the original cells to bring over, if needed. A regular paste can bring formulas, formatting, and other cell properties along with the displayed values. If you need fixed values only, copy the selection, then use Home > Paste > Paste Values at the destination. The Paste Values icon or wording can vary slightly by Excel version. If formulas are useful in the new location, use a regular paste and verify that their references still make sense there.

Excel for the web: Filtered rows are generally excluded when you copy visible results, but the desktop Go To Special command may not be available in the same way. Apply the filter, select the displayed range, copy, and paste into a blank area, then inspect the result carefully. If you need to guarantee a visible-cells-only selection or the web copy behaves unexpectedly, open the workbook in the desktop Excel app and use the Go To Special steps above.

Common Mistakes

  • Copying before selecting visible cells only. Excel often copies visible cells in a filtered list automatically, but relying on that behavior can be confusing when the range contains other hidden rows or columns. Use Go To Special when you need an explicit visible-only selection.
  • Leaving out the headings unintentionally. If you select only the data rows, the destination will not have column names. Include the header row when the copied data will be used independently, but do not include a title or blank rows above the actual list unless you want them copied too.
  • Selecting an incomplete range. If you select only a few columns, the pasted records will be incomplete. Check the first and last columns before copying, particularly if the table is wider than the visible window.
  • Pasting over existing records. Clicking a destination cell inside populated data can replace cells there. Use a blank area or new worksheet, and confirm there is enough space for all visible rows and columns.
  • Assuming copied formulas become fixed values. A normal paste can preserve formulas, and their references may change when pasted elsewhere. Use Paste Values when the goal is a static snapshot of the displayed results.
  • Confusing filtering with sorting or deleting. A filter hides records from view; it does not remove them from the source. Copying a filtered result should leave the original list intact. Do not delete rows as a substitute for copying visible data.

Tips

  • Make a clean extract on a separate sheet. Pasting onto a new worksheet reduces the risk of overwriting the original list and gives you a clear place to review the extract. Give the new sheet a descriptive name, such as “West records.”
  • Include the header for a reusable result. Headings help identify each column after the copied records are separated from their source. If the header itself is not part of the filtered data you want, select it deliberately rather than relying on a broad range selection.
  • Use Paste Values for a snapshot. This is especially useful when you want to email or share a fixed extract without carrying formulas that depend on the original workbook. If you need the original appearance, consider applying formatting separately after pasting values.
  • Check for other hidden content. Visible cells only excludes cells hidden by filters and can also exclude manually hidden rows or columns in the selected range. That is helpful when you want only what is currently visible, but it matters if manually hidden information should be part of the copy.
  • Keep the filter criteria understandable. Before copying, look at the filter arrows and confirm the intended values are selected. A filtered list can still show a subset you did not mean to use if another column also has an active filter.
  • Use the desktop app for a controlled extract. Excel for the web can handle ordinary filtering and copying, but its available selection commands can differ. For complex selections, open the file in Microsoft 365 desktop Excel and use Visible cells only.

Troubleshooting

  • Filtered-out records appear after pasting: Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, if you have not made other changes. Reselect the source range, use Go To Special > Visible cells only, copy again, and paste into a blank destination. Verify the result before continuing.
  • The pasted area has missing columns or headings: Return to the source and confirm the selection includes the full set of desired columns and, if needed, the header row. Repeat the visible-cells-only selection for that complete range.
  • Excel displays an error or will not paste: Click just one destination cell rather than selecting a large destination range, and make sure the destination is not a protected or merged-cell area. Try pasting into a blank worksheet. Copying a noncontiguous visible selection can behave differently from copying a solid block, so a clean destination helps identify the issue.
  • The result contains old values after you change the filter: A pasted extract is a separate copy; it does not update automatically when the source filter changes. Clear the old extract and repeat the copy after applying the new filter, or use a separate worksheet for each extract.
  • You cannot find Go To Special: On Windows, check the Home > Find & Select menu. On Mac, look for Go To Special through the Home ribbon or the Edit/Find menus, depending on the Excel version. If using Excel for the web, open the workbook in the desktop app for the most consistent visible-cells-only controls.
  • The pasted formulas show different results: A normal paste may adjust relative cell references to suit the destination. Undo, repeat the copy, and choose Paste Values if you need the source results frozen as values.

Frequently Asked Questions

Does Excel automatically copy only filtered rows?
In many desktop Excel situations, copying a filtered list copies only the visible rows. Selecting Visible cells only explicitly is a dependable extra check, particularly if the selection also contains manually hidden rows or columns.

Will copying filtered data remove anything from the original list?
No. Copying creates a separate set of cells at the destination. The filter hides records from view; it does not delete them. The original rows remain in the source list unless you separately edit or delete them.

Can I copy the filtered results to a different worksheet?
Yes. Select visible cells, copy them, add or open the destination worksheet, click one empty starting cell, and paste. Include the header row in the source selection if you want the headings on the new sheet.

Can I copy only the displayed values, not formulas?
Yes. After copying, use Home > Paste > Paste Values at the destination. This pastes the formula results as values instead of carrying the source formulas into the extract.

Does Visible cells only include manually hidden rows?
No. It selects cells that are visible and excludes hidden cells in the selected range, whether rows are hidden by a filter or hidden manually. If you want manually hidden records included, unhide them before making the selection.

Why does my pasted extract not change when I adjust the source filter?
The pasted result is a snapshot, not a live link to the filter. To create a different extract, apply the new filter and copy the visible cells again. A normal paste does not keep itself synchronized with later changes to the source.

Related

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.