How to Paste Filtered Data in Excel Without Errors

How-to basics · Updated November 21, 2026

To paste only the rows currently shown by a filter, select the filtered data without its header, choose Home > Find & Select > Go To Special > Visible cells only, copy, then paste into an unfiltered destination range. This copies the visible records together and helps prevent hidden rows from being included. Before starting, check that the destination has enough empty rows and matching columns.

What You’ll Need

  • A workbook open in Microsoft Excel for Microsoft 365 on Windows.
  • A filtered source list with a header row, and a destination range where the copied records can be pasted.
  • For a clean result, a destination area outside the filtered list or on a separate worksheet. Avoid pasting a block directly into another filtered range unless you have confirmed how its rows will be affected.

The steps below apply to a standard Excel AutoFilter or a table filter. If you use Excel for Mac, the ribbon commands are similar, but the Windows Alt+; shortcut may differ; use the Visible cells only command in Go To Special instead. Excel for the web has a more limited interface, so use desktop Excel if you cannot find that command.

Step-by-Step

  1. Apply the filter and check the visible records. Click a cell in your list, then use Data > Filter if the filter arrows are not already showing. Filter the relevant column using its dropdown. Scroll through the results and confirm that the visible rows are the ones you intend to copy. A filter hides nonmatching rows; it does not delete them.
  2. Select the data, not the header. Drag across the visible data columns and rows, or click the first data cell and extend the selection to the final row and column you need. Do not include the header if you want to paste records only. If the list is an Excel table, include only the table columns you need. Be careful not to select unrelated cells beside the list.
  3. Limit the selection to visible cells. On Windows, press Alt+; (Alt and semicolon). Alternatively, use Home > Find & Select > Go To Special, select Visible cells only, and click OK. This is an important safeguard: it tells Excel to exclude rows hidden by the filter, including any other hidden rows in the selected area. Look for the separate outlines around the selected visible cells as a visual check.
  4. Copy the selection. Press Ctrl+C, or choose Home > Copy. A moving dashed border should appear around the copied selection. If you selected several columns, Excel copies those columns for each visible record. The filtered-out records are not part of the visible-cells selection.
  5. Choose a suitable destination. Click the top-left cell of a blank, unfiltered area. It can be on another worksheet or below the existing data, as long as there is enough room and no important content will be overwritten. For example, if the filter shows 12 records and you copied four columns, leave space for 12 rows by four columns, plus a header row if you intend to paste one.
  6. Paste the copied records. Press Ctrl+V or choose Home > Paste. In an ordinary unfiltered range, the visible records are placed consecutively, with no blank rows for records hidden by the filter. Check the first and last pasted records and compare the pasted row count with the number of visible records before using the result elsewhere.
  7. Choose whether to keep formulas or just their results. A normal paste brings formulas, formatting, and other copied cell properties along where applicable. If you want fixed values instead, copy the source as usual, click the destination, and choose Home > Paste > Values (the Values option is often shown with a 123 icon). Check a few cells afterward: a value-only paste will not carry the source formatting or formulas.
  8. Check the destination before removing the filter. Confirm that columns are in the expected order, dates and numbers look right, and no existing data was overwritten. If the results are correct, you can clear or change the source filter. Clearing a filter changes which original rows are displayed; it does not change the pasted copy.

Example: Suppose a sales table has 200 records, but filtering the Region column for West leaves 18 visible records. Select the data columns for those records, use Visible cells only, and copy. Paste into an empty, unfiltered area. The destination should contain 18 consecutive records, not 200 rows with gaps. If you also need the column names, copy and paste the header separately so it appears just once above the records.

Important difference: pasting into a filtered destination. The steps above are safest when the destination is unfiltered. Excel does not reliably treat a block paste into a filtered destination as an instruction to update only its visible rows. Hidden destination rows can be affected, or Excel may reject a paste into a multiple-area selection. If your goal is to replace only the records currently visible in a filtered destination, do not assume that selecting Visible cells only makes a block paste safe. First identify the exact destination records, for example by a unique ID, then update those records using a method that matches the IDs, or remove the filter and carefully paste into the verified row locations. Keep a backup if the data matters.

Common Mistakes

  • Copying the full selection without choosing Visible cells only. Filtering hides rows on screen, but it is easy to select a range that includes hidden rows. Explicitly choosing Visible cells only makes your intention clear and avoids accidental inclusion of hidden records.
  • Pasting over an existing list without checking its size. A paste replaces cells in the destination footprint. If the visible source has more rows or columns than expected, it can overwrite content. Use an empty area and check its dimensions first.
  • Including the header in some copies but not others. This can put a heading in the middle of the pasted records or create duplicate headers. Decide whether the destination needs a header, and copy it separately when necessary.
  • Assuming filtered rows have been deleted. They remain in the source data and may reappear when the filter is cleared. Copying into a new area is different from deleting or editing records in the original list.
  • Pasting a multi-cell block into a filtered destination. The visible rows in a filtered list are not necessarily one continuous range. A standard paste may not map source records to visible destination records as you expect.
  • Using ordinary Paste when only values are wanted. Formulas may refer to different cells after being pasted, and formatting may change the appearance of the destination. Use Paste > Values when the destination should contain only the displayed results.

Tips

  • Use a staging area. Pasting filtered results into a new worksheet or clearly labeled blank section keeps the source intact and makes it easier to check the copied records.
  • Count before and after. Note how many rows the filter displays, then count the pasted records. A table’s status bar may show a count when you select cells, but verify the actual rows if the selection includes several columns or blank cells.
  • Keep related columns together. When copying records, include the identifying field, such as an order number or customer ID, along with the data you need. It helps you confirm that columns have stayed aligned.
  • Use the keyboard shortcut only after selecting the range. On Windows, Alt+; selects visible cells only. If your keyboard layout makes that difficult, use Home > Find & Select > Go To Special > Visible cells only instead. On Mac, use the ribbon or Go To Special if the Windows shortcut does not work.
  • Undo promptly if the paste is wrong. Ctrl+Z on Windows undoes the last paste, provided you have not performed another action that changes the undo history. On Mac, use Command+Z. If you are unsure what was overwritten, undo first, then inspect the destination and repeat the copy carefully.
  • For repeated work, consider a separate output sheet. A fresh sheet helps prevent accidental edits to the original table and makes it clear that the pasted data is a snapshot of the filter results at that time. Changing the source filter later will not automatically update that pasted copy.

Troubleshooting

Hidden rows appear in the pasted results. Undo the paste, reselect the source range, and explicitly choose Home > Find & Select > Go To Special > Visible cells only before copying. Check that the selection outline breaks around hidden rows. If you used a table filter, confirm that you selected only the table’s data columns and not a larger range that includes unrelated cells.

Excel says the command cannot be used on multiple selections. Visible cells in a filtered range can form several separate areas. Some operations do not work on that kind of selection, especially when the destination is also filtered. Paste into a normal blank range or a new worksheet instead. If the task is to update specific visible destination records, match them by a unique identifier rather than trying to paste a block into the filtered range.

The pasted data has blank rows or the wrong row count. Check whether the destination itself has a filter or hidden rows. Try an empty unfiltered location, and compare the number of pasted records with the number shown by the source filter. Also make sure the copied range did not include blank rows that were part of the original list.

Values or formatting changed unexpectedly. If formulas appeared where fixed numbers were expected, undo and use Home > Paste > Values. If dates or numbers display differently, the destination’s number format may differ from the source; apply the desired format after pasting or use a normal paste when you need the original formatting.

The Visible cells only option is unavailable or hard to find. Click inside the worksheet selection and open Home > Find & Select > Go To Special. In the dialog, choose Visible cells only and click OK. If you are using Excel for the web and the command is missing from your interface, open the workbook in the Windows or Mac desktop app and use Go To Special there.

The source filter changes after copying. A copied range is a snapshot, not a live link to the filtered list. If you change the criteria before copying, reselect and copy the results again. If you need a destination that updates automatically, a static copy-and-paste workflow is not the right tool; use a linked formula or a refreshable data process suited to your workbook.

Frequently Asked Questions

Does Ctrl+C copy only visible rows in a filtered list?
Excel generally copies the visible cells from a filtered range, but selecting Visible cells only explicitly is the safer approach, particularly when the selection also contains manually hidden rows or a complicated range.

Can I paste filtered data into another filtered list?
You can try, but a regular block paste is not a dependable way to target only visible destination rows. Paste into an unfiltered staging area, or identify the destination records by a unique key and update those records deliberately.

Will the copied rows stay connected to the original data?
No. A regular paste creates a separate copy. Later edits to the source do not flow into the pasted range, and changing the filter does not refresh it.

Can I paste only the results and not the formulas?
Yes. Copy the visible cells, then choose Home > Paste > Values at the destination. This pastes the current results rather than the source formulas.

How do I include the column headings?
Copy the header row separately and paste it above the copied records, or include it in a separate selection if the layout allows. Check that you do not paste the heading twice.

Does this work in Excel for Mac?
The Go To Special method is the same general approach, though the ribbon layout and keyboard shortcuts can differ. Use Home > Find & Select > Go To Special > Visible cells only if the Windows Alt+; shortcut is not available on your Mac.

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.