To copy filtered rows without bringing hidden records along, select the filtered source cells, choose Home > Find & Select > Go To Special > Visible cells only, copy them, and paste into a blank, unfiltered area. If you need to paste different values into visible rows of an existing filtered list, do not assume a normal paste will skip hidden rows; use a matching key or temporarily unfilter and carefully align the records instead.
What You’ll Need
- Excel for Microsoft 365 on Windows and a workbook containing a filtered list or table.
- The source values you want to copy, plus a clear idea of whether you are copying records to a new place or updating records already in the list.
- For updates to existing records, a unique identifier such as an order number, employee ID, or product code is strongly recommended. It lets you match values to the right records rather than relying on visible row order.
- A backup copy of the workbook if the destination contains important data. Pasting over cells can replace existing contents.
Step-by-Step
- Decide what the paste should do. There are two different jobs people describe as pasting into a filtered list. You may want to copy the visible filtered records to another location, or you may want to put new values into visible rows of the original list. Copying records to a blank area is straightforward. Updating a filtered destination is riskier because a regular paste can write into rows that are hidden by the filter. Choose the method below that matches your goal.
- Apply the filter and check the results. Click a cell inside your list. If it is an Excel table, use the filter arrows in the header row; for a regular range, use Data > Filter and then choose the required criteria. Check that the visible records are exactly the ones you intend to copy or change. A filter hides rows; it does not remove them. The row numbers at the left usually skip numbers where records are hidden.
- Select the cells you want to copy. Select the data cells, not the whole worksheet. Include the header only if you want the header copied too. If the list has several columns, select the same columns you need at the destination. Avoid selecting unrelated notes or adjacent totals, as those can be included in the copied range and pasted over other information.
- Restrict the selection to visible cells. With the source range selected, choose Home > Find & Select > Go To Special, select Visible cells only, and click OK. On Windows, the shortcut Alt+; (Alt plus semicolon) also selects visible cells only within the current selection. This step is a useful safeguard, especially if the range includes manually hidden rows as well as rows hidden by a filter. You should see separate outlines around visible portions of the selection in some Excel layouts.
- Copy the visible cells. Press Ctrl+C on Windows, or choose Home > Copy. A moving dashed border appears around the copied selection. Do not click another cell inside the filtered source and assume the copy is still ready if you have made another selection or copied something else; that can replace the clipboard contents.
- Paste to a blank, unfiltered destination for a clean copy. Click the top-left destination cell in an empty area, a new worksheet, or another range that is not filtered. Press Ctrl+V. Confirm that the pasted rows and columns line up as expected. Copying visible source cells to an ordinary blank range is the safest way to create a compact copy of the filtered results without changing hidden records in the original list.
- Check the pasted result before continuing. Compare the number of visible source records with the number of pasted records, and check a few values from the first, middle, and last rows. If you copied multiple columns, verify that each value stayed with its corresponding record. Keep the filter on the original list until you have confirmed the new copy is complete.
- If you are updating a filtered list with different values, match records by an identifier. Put the incoming values in a staging range with the same unique ID used by the destination list. Then update or merge the data by matching IDs, rather than pasting a vertical block based only on visible row order. If you do not have a unique ID, first make one or otherwise establish a reliable match. This approach avoids putting a value beside the wrong person, order, or item when the filter changes.
- If you must update by row order, make the rows contiguous first. Save a copy of the workbook, note the filter criteria, clear the filter, and identify the exact destination records. Arrange the source values in the same order as those records, then paste into the verified destination range. Reapply the filter afterward and review the changed rows. Do not paste a short list onto a selected filtered column and expect Excel to skip every hidden row automatically.
- For one identical value in all visible destination cells, use a fill instead of a paste. Select the destination range, choose Home > Find & Select > Go To Special > Visible cells only, type the value, and press Ctrl+Enter. This enters the same value into the selected visible cells. Use this only when every selected visible cell should receive exactly the same content; it is not a way to distribute a different copied value to each row.
Common Mistakes
- Pasting a block directly into a filtered destination. A filtered range is not a simple continuous range from Excel’s point of view. A normal paste may fill hidden rows too, or the selection may not accept a multi-cell paste as expected. A screen that still shows the filter is not proof that hidden records were left untouched.
- Skipping Visible cells only. Filtering usually hides rows, but manually hidden rows can also be present. Selecting a range and copying without checking what is selected can include cells you did not mean to copy. Use Go To Special when it matters that only visible cells are included.
- Using different sort orders or filters on source and destination. Two lists can show the same number of visible rows but have different records or ordering. Pasting by position can then assign values to the wrong records. Match by a unique ID instead.
- Including headers or extra columns unintentionally. A header pasted into the first data row, or an extra column pasted over existing information, can corrupt the list. Before copying, confirm the selected edges and whether the header belongs in the result.
- Assuming Undo solves every problem. Ctrl+Z often reverses a recent paste, but later edits, refreshes, or certain workbook actions can complicate recovery. If you spot an unexpected change, stop editing, use Undo immediately if appropriate, and check the data before saving further changes.
Tips
- Work in a staging sheet when copying filtered data. A blank, unfiltered area makes it easier to inspect, sort, compare, and validate the output before replacing or updating anything.
- Use Excel tables for regularly updated lists. Tables make headers and filter controls clearer, and they expand as you add records. They do not, however, make a normal paste safe for hidden destination rows; still verify the target behavior.
- Keep a unique ID column with the records. Names can repeat or change, while an order number or employee ID is more dependable for matching incoming data.
- When copying a filtered result, include only the columns you need. This reduces the chance of overwriting formulas, comments, or other fields when you paste into a destination.
- After updating data, clear the filter and inspect the full list. Hidden rows may reveal an accidental change that was not visible during the paste. You can then reapply the filter criteria and confirm that the intended records still appear.
- On Mac, use the Home ribbon’s Find & Select > Go To Special route if the Windows Alt+; shortcut does not apply to your keyboard layout. Shortcut availability can vary by Excel version and keyboard settings.
- In Excel for the web, some selection commands and shortcuts differ from desktop Excel. If you cannot find Visible cells only, open the workbook in the Microsoft 365 desktop app before making a sensitive multi-row update.
Troubleshooting
- The paste changed hidden records. Stop editing and press Ctrl+Z immediately if the paste is still the most recent action. Check the full, unfiltered list for changes. If Undo is unavailable or the workbook was saved after the paste, restore from version history or a backup if one is available; otherwise compare with the original data before making more edits.
- Excel says the action cannot be performed on multiple selections. Visible cells can form separate, noncontiguous areas. Excel may reject a standard paste into that kind of destination. Do not keep retrying with a larger selection. Paste the copied source into a blank unfiltered staging range, then use a key-based update or another controlled method to populate the destination.
- The pasted output has unexpected blank rows or gaps. Check whether the destination itself was filtered or had manually hidden rows. Try again in a completely blank, unfiltered area and select only the visible source cells before copying. Also check whether the source includes blank cells between its visible records.
- The values landed beside the wrong records. Undo the change if possible. Compare source and destination IDs and sort orders. If the lists do not have an identical order, do not paste by row position; match each value to its unique ID and redo the update.
- The shortcut does nothing. First click within the selected range and try Home > Find & Select > Go To Special > Visible cells only. On Mac or in a browser, the Windows shortcut may not work. If the menu item is unavailable in Excel for the web, use the desktop app for this operation.
Frequently Asked Questions
Does Excel copy only visible rows when I copy a filtered list?
Filtered lists generally copy the visible records, but selecting Visible cells only explicitly makes the intended selection clear and also helps exclude manually hidden cells. For important data, paste to an empty unfiltered range and verify the result.
Can I paste different values into visible filtered rows only?
Do not rely on a normal paste to skip hidden destination rows. Excel may write into hidden rows or reject a noncontiguous selection. Use a unique ID to match the incoming values, or unfilter and carefully align the records before pasting.
Can I paste the same value into every visible row?
Yes. Select the destination range, choose Visible cells only through Go To Special, type the value, and press Ctrl+Enter on Windows. This fills the selected visible cells with one identical value; it does not distribute a different value to each row.
Will this work if my data is an Excel table?
Yes. Filter the table as usual and use the same visible-cell selection and copy process. For a destination table, take extra care: a regular paste into its filtered rows is not guaranteed to leave hidden records unchanged.
How do I copy filtered rows to another worksheet?
Select the source cells, choose Visible cells only, copy them, switch to the other worksheet, and paste into a blank unfiltered area. Check the headers, row count, and column alignment before using the copied data.
Does the Windows Alt+; shortcut work on Mac?
It is a Windows shortcut and may not work on a Mac keyboard. Use Home > Find & Select > Go To Special > Visible cells only where available, or check the shortcuts for your Excel version and keyboard layout.
Related
- How to Insert an Image in Excel Without Moving Cells
- How to Insert an Image in Google Sheets: In a Cell
- How to Insert an Image in an Excel Sheet: Full Guide
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 Delete a Full Page in WordTo delete a full page in Word, place the cursor on that page, press Ctrl+G, type \page in…
- Free Meal Planning Spreadsheet: How to Choose One That FitsYes—free meal planning spreadsheets are available, and you can also make a simple one yourself in Excel for…
- Remove a Hanging Indent in a Word TableTo remove a hanging indent in a Word table, select the affected paragraph or paragraphs, open the Paragraph…
- Excel Flash Fill Shortcut: Ctrl+E and How It WorksIn Excel for Microsoft 365 on Windows, the Flash Fill keyboard shortcut is Ctrl+E. Enter an example of…
- Excel Power Query: How to Change Close & Load SettingsIn Excel for Microsoft 365 on Windows, change a Power Query’s load destination by opening Data > Queries…
- Schedule an Email in Outlook to Send Later: What to KnowYes. In new Outlook or Outlook on the web, compose your message, open the menu beside Send, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.