How to Copy and Paste Only Filtered Data in Excel Safely

How-to basics · Updated November 20, 2026

To copy only filtered records in Excel for Microsoft 365 on Windows, select the filtered range, press Alt+; to choose visible cells only, press Ctrl+C, then click the destination’s top-left cell and press Ctrl+V. This transfers the rows currently shown by the filter without intentionally including hidden records. Use a blank, unfiltered destination when you want a clean, continuous copy.

This is useful for extracting a subset of a list, sharing selected records, or preparing a separate report. Before starting, apply your filter and decide whether the copied range should include its column headings. The steps below cover Excel for Windows; Mac and Excel for the web notes are included where the controls differ.

What You’ll Need

  • An Excel workbook with a range or table that has a header row and at least one filter applied.
  • A destination area with enough empty space for the visible records. A new worksheet is a good choice if you want to avoid overwriting anything.
  • For the most explicit Windows method, access to the Alt+; shortcut or the Visible cells only command in Go To Special.

Step-by-Step

  1. Apply the filter you need. Click a cell in your list, then use the filter arrows in the header row to choose the values or conditions to display. If the list is not already filterable, click inside it and choose Data > Filter. For a formatted Excel table, filter arrows usually appear in the headers automatically. Check that the status bar or visible rows indicate the subset you intend to copy.
  2. Choose whether to include the headings. If the destination should be self-explanatory, include the header row in the selection. If you only need the records, begin with the first data row. Do not select the whole worksheet unless that is truly what you need; selecting just the relevant columns and rows makes the result easier to verify and reduces the chance of overwriting unrelated material.
  3. Select the range you want to copy. Drag across the filtered data cells, or click the first cell and extend the selection with Shift-click or the arrow keys. Include all required columns, but avoid unrelated columns. It is fine if the selection includes rows hidden by the filter; the next step tells Excel to narrow the selection to visible cells.
  4. Limit the selection to visible cells. On Windows, press Alt+; (Alt plus the semicolon key). Excel highlights the visible cells within your selected range, skipping rows hidden by the filter. You can also use Home > Find & Select > Go To Special, select Visible cells only, and click OK. This explicit step is especially useful when you want to make sure hidden rows are excluded.
  5. Copy the visible cells. Press Ctrl+C. A moving border should appear around the copied selection. Keep the filter in place until the paste is complete; changing or clearing it can make it harder to confirm which records you copied.
  6. Choose a safe destination. Click the top-left cell of an empty, unfiltered area, or add a new worksheet with the plus button beside the sheet tabs. Make sure there is room for all the visible rows and columns. If the destination contains data, stop and choose another location or make a backup before replacing anything.
  7. Paste the selection. Press Ctrl+V. The copied visible records should appear at the destination. If you included the headings, they will be pasted too. For a copy that should contain only the displayed results, paste into a normal blank area rather than another filtered list; filtered destinations can make row alignment confusing.
  8. Check the result before using it. Compare the copied rows with the source filter, confirm that the expected columns and headers are present, and look for records that should not have been included. If you need static values rather than copied formulas, use Home > Paste > Values after copying, then verify that the values are correct. Save the workbook when the result is ready.

Mac and web: In Excel for Mac, use Command+C and Command+V for copying and pasting. To explicitly select visible cells, open Home > Find & Select > Go To Special, then choose Visible cells only if that command is available in your version. The Windows Alt+; shortcut is not the Mac shortcut. Excel for the web has fewer Go To Special options; copy the filtered range and paste it into a blank area, then check the result carefully. If you need precise control over a complex or multi-area selection, use the desktop app.

Common Mistakes

  • Skipping the visible-cells step. A filtered list hides rows, but selecting a range can be confusing, particularly if some rows were hidden manually or the selection includes cells outside the filtered list. Use Alt+; on Windows or Visible cells only in Go To Special before copying, then check the pasted records.
  • Selecting too much. Clicking a column letter or row number can select far more cells than the records you intend to move. This can create a very large copied range or include unrelated information. Select the actual data block and only the columns you need.
  • Pasting over existing information. Ctrl+V replaces cells at the destination. Pasting into a filtered or partly filled list may also make it difficult to tell which destination rows were affected. Paste into a clearly empty range or a new sheet, especially when preserving the original data matters.
  • Assuming a copied formula is a fixed result. A normal paste can bring formulas and formatting along with the displayed values. If you need a standalone extract, choose Paste Values and check key figures afterward. A formula may refer to cells in the original sheet, so the pasted number might change if the source changes.
  • Changing the filter before copying is finished. If you change the criteria after selecting the range, the visible records may no longer match what you meant to extract. Finish copying and verify the paste before adjusting or clearing the filter.

Tips

  • Use a new sheet for a one-off extract. Click the plus button next to the sheet tabs, give the new sheet a clear name, and paste into A1. Keeping the extract separate makes it easier to review and reduces the chance of replacing existing data.
  • Keep headings with the records when sharing. Including a single header row helps another person understand what each column means. Avoid including a second copy of the headings if your selected range starts inside a table that already has them.
  • Use Paste Values for a snapshot. If you are sending a static extract, use Home > Paste > Values to avoid carrying formulas that link back to the source. This does not automatically remove all formatting; use the paste options that fit your needs and inspect the result.
  • Check the record count. Before copying, note how many data rows are visible, excluding the header. After pasting, count the destination records or compare the first and last entries. This simple check can reveal missing or extra rows before the extract is shared.
  • Keep the source intact. Copy rather than cut when extracting filtered data. Cutting can be confusing with non-adjacent visible rows and risks changing the original list. If you need to move records, make a verified copy first, then remove the originals using a deliberate, separate step.

Troubleshooting

  • Hidden rows appear in the pasted result: Return to the source, select the range again, press Alt+; on Windows, and copy once more. Make sure the selection starts and ends within the intended columns and rows. If rows were hidden manually as well as filtered, the visible-cells selection is particularly important.
  • Excel says the command cannot be used on multiple selections: Filtered visible cells can form separate areas rather than one continuous block. Try selecting a simpler rectangular range limited to the filtered list, then use Visible cells only. If the selection remains complicated, copy one column or section at a time, or use a new sheet and verify each paste.
  • Some records are missing: Check the filter criteria and confirm that the range selection reaches the final visible row. Look for blank rows or cells that break the source list into separate regions. Clear and reapply the filter if necessary, then repeat the copy and compare the visible source rows with the destination.
  • The paste lands in the wrong place or overwrites data: Press Esc to cancel the moving copy border, undo immediately with Ctrl+Z if the paste changed the wrong cells, and inspect the workbook before continuing. Select a blank destination cell deliberately, then paste again. On Mac, use Command+Z to undo.
  • The pasted results change unexpectedly: The destination may contain formulas rather than fixed values. Undo if needed, copy the source again, and select Home > Paste > Values at the destination. Review any totals or calculations before relying on them, especially if formulas refer to cells outside the copied range.

Frequently Asked Questions

Does Excel copy only visible rows when I copy a filtered list?

Excel generally excludes rows hidden by a filter when copying a filtered range, but explicitly choosing Visible cells only makes your intent clear and helps avoid selection surprises. On Windows, Alt+; applies that choice to the current selection. Always check the pasted result when the extract is important.

What does Alt+; do in Excel?

In Excel for Windows, Alt+; selects visible cells only within the current selection. It is useful for filtered ranges and ranges with hidden rows. Select the range first, use the shortcut, and then copy. On Mac, use Go To Special if available rather than assuming the Windows shortcut works.

Can I copy filtered data to another filtered list?

You can try, but it is easy to misread how the source and destination rows line up. Hidden destination rows may affect where pasted cells appear. For a straightforward extract, paste into a blank unfiltered area first. If you must paste into another filtered list, test on a copy of the workbook and verify every destination row.

How do I paste the filtered data without formulas?

Copy the visible cells as usual, click the destination, and choose Home > Paste > Values. This pastes the calculated results instead of the source formulas. Check the pasted numbers and text; values will no longer update when the original cells change.

Can I do this in Excel for the web?

You can filter, copy, and paste data in Excel for the web, but its selection tools do not match the full desktop Go To Special controls in every version. Paste into a blank area and compare the result with the visible source rows. For a complex selection or a workflow that depends on explicitly selecting visible cells, open the workbook in desktop Excel.

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.