In Excel for Microsoft 365 on Windows, apply your filter, select the range you want to copy, press Alt+; to select visible cells only, then press Ctrl+C and paste into the destination. This copies the rows currently shown by the filter without bringing along the filtered-out rows. You do not need to delete or rearrange anything in the source data.
The important step is selecting visible cells only before copying. A normal selection can include hidden rows even when they are not displayed, so skipping that step may copy more than you can see. The instructions below cover a clean copy to a new range, plus what to check if the result does not look right.
What You’ll Need
- An Excel workbook with a header row and a data range or Excel table.
- A filter applied to the data. You can add one by selecting a cell in the range and choosing Data > Filter, or use the filter arrows already shown in a table header.
- A destination range with enough room for the visible rows and columns. A blank worksheet is a convenient place to check the result.
Step-by-Step
- Apply the filter you need. Click the filter arrow in the relevant header, choose or clear the values you want, and select OK. Excel hides rows that do not meet the criteria; it does not remove them. Check the visible records before copying so the filter is showing the intended results.
- Decide exactly what to include. Choose whether you need the column headings as well as the filtered records. If you want only certain fields, select only those columns rather than the entire table. Avoid including a total row or notes below the data unless you mean to copy them.
- Select the source range. Drag across the cells you want to copy, including the header row if required. For a large range, you can click the first cell and use the Name Box to enter a precise address, such as A1:D250, then press Enter. A selection can contain hidden rows; that is expected at this stage.
- Restrict the selection to visible cells. On Windows, press Alt+; (Alt and semicolon). Excel changes the selection to visible cells only. You may see separate outlines around visible areas, because the filtered rows between them are excluded. If the shortcut is unavailable, use Home > Find & Select > Go To Special, choose Visible cells only, and select OK.
- Copy the visible cells. Press Ctrl+C. A moving dashed outline should appear around the copied selection. Keep the filter in place while copying; clearing it first would make the formerly hidden records visible and include them in the selection.
- Choose the destination. To make a straightforward copy, switch to a blank area or a new worksheet and click the single top-left cell where the copied data should begin. Do not select a series of separate destination cells. Make sure there is enough empty space to the right and below, so the pasted data does not overwrite information you want to keep.
- Paste and check the result. Press Ctrl+V. The copied visible records should appear as a contiguous block, without blank spaces for the rows hidden by the filter. Compare the first and last records with the filtered source and check that the headers and columns line up.
- Optionally paste values instead of formulas. If the source cells contain formulas and you want a fixed snapshot of their displayed results, copy as above, then use Home > Paste > Values at the destination. This keeps the calculated values rather than carrying over the original formulas. For ordinary copied data, standard paste is usually appropriate.
On Mac: Excel for Mac may not use the Windows Alt+; shortcut. Select the source range, then use Home > Find & Select > Go To Special and choose Visible cells only before copying. Menu labels can vary slightly by Excel release. On Excel for the web, if you cannot find a visible-cells-only command, open the workbook in the desktop app and use the steps above rather than assuming a regular copy will exclude hidden rows.
Common Mistakes
- Copying without selecting visible cells only. Filtering changes what is displayed, but it does not necessarily limit a normal selection to the displayed rows. Use Alt+; on Windows, or Go To Special, before copying.
- Clearing the filter too early. If you clear the filter before making the visible-only selection, all records may be included. Keep the source filtered until the copy is complete.
- Selecting a mismatched range. If you select the data but not its headers, the destination will not have headings. If you include extra columns or rows, unrelated material may be pasted too. Confirm the selection boundaries before copying.
- Pasting into another filtered or hidden area. The destination may also hide rows, making a correct paste appear incomplete or misaligned. Paste to a blank, unfiltered area first, then apply any destination filter afterward.
- Assuming hidden means filtered out. Visible-cells-only selection excludes cells in hidden rows and columns, including rows or columns hidden manually—not just records hidden by the current filter. If you have manually hidden something you intend to copy, unhide it first or adjust your selection.
- Overwriting existing content. A paste can replace cells at the destination. Choose an empty location and confirm there is room for all the selected columns and visible records.
Tips
- Copy the headings when the pasted data needs context. Include the header row in your source selection if you plan to share, sort, or filter the copied block separately. Leave it out if the destination already has the correct headings.
- Use a new worksheet for a one-off extract. Click the plus button beside the sheet tabs to create a sheet, then paste into A1. This reduces the chance of overwriting data and makes it easy to compare the extract with the original.
- Paste values for a portable snapshot. A normal copy can bring formulas and formatting along. Values are useful when recipients need the displayed results but not links back to the source workbook. If you need the original calculations, use a normal paste instead.
- Check which columns you selected. Visible-cells-only selection includes every visible column in the selected range. If you want fewer fields, select those columns first; the command does not decide which fields are relevant.
- Keep the source intact. Filtering and copying do not delete hidden rows. You can clear the filter afterward using its header arrow, or choose Data > Clear to clear filters while retaining the records.
- Expect separate visible areas in the selection. A filtered range may look discontinuous because hidden records are skipped. That is normal. Paste into one top-left destination cell rather than trying to reproduce the gaps manually.
Troubleshooting
Hidden rows appeared in the pasted copy: Return to the source, reapply the filter, select the source range again, and use Alt+; (or Go To Special > Visible cells only) before copying. If you copied first and applied the command afterward, repeat the copy after changing the selection.
Some visible records or columns are missing: Check the filter criteria and the boundaries of your selection. The filter may be excluding records you expected to see, or the selected range may not extend through all the needed columns. Re-select the full intended range and copy again.
The paste has gaps or seems misaligned: First check whether the destination itself has hidden or filtered rows. Try pasting to a new blank worksheet at A1. If the columns still do not line up, verify that the source selection includes the same columns in the intended order.
The shortcut does nothing: Make sure the worksheet, rather than the formula bar or another field, has focus. On Windows, use Alt+; with the semicolon key. If your keyboard layout makes that difficult, use Home > Find & Select > Go To Special > Visible cells only. In Excel for the web, use the desktop app if the visible-cells-only option is not available.
Formulas changed after pasting: Standard paste may copy formulas, and Excel can adjust their references for the new location. Undo immediately with Ctrl+Z if needed, then copy again and choose Home > Paste > Values. On Mac, use the equivalent Paste Values command in the Home tab or Paste Special options.
Excel says the copy area is not the same size: This can happen if you try to paste into a destination made up of multiple selected areas, or into a range that does not match the copied selection. Press Esc, click a single empty top-left destination cell, and paste again.
Frequently Asked Questions
Does Excel automatically copy only the filtered rows?
Do not rely on a normal copy to exclude hidden rows. Select the source range and use Visible cells only before copying to make the intended selection explicit.
Can I copy filtered data to another worksheet?
Yes. Select visible cells only, copy, switch worksheets, click one empty destination cell, and paste. A new sheet is a useful option when you want to keep the extract separate from the original.
Will the pasted rows keep their original row numbers?
Usually the copied records are placed consecutively at the destination; the gaps from filtered-out rows are not recreated. If original row numbers matter, include a column containing those numbers in your selection.
Can I copy only some columns from the filtered results?
Yes. Select the specific columns and rows you need, then choose visible cells only and copy. Check that the selection covers the same set of rows across those columns.
Does this method delete or change the hidden records?
No. It copies selected visible cells to another location. The records hidden by the filter remain in the source; clearing the filter shows them again.
Can I use the same steps in Excel for the web?
The filtering and copying basics are similar, but the visible-cells-only selection command may not be available in every web version. For a dependable copy that excludes hidden rows, open the workbook in Excel for Microsoft 365 on Windows or Mac and use Go To Special.
Related
- Convert an Excel File to a Google Doc: Step by Step
- Convert Excel to Word: A Step-by-Step Guide
- Convert an Excel Cell to Number: Quick Methods
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Online Link to Another Sheet: How to Create OneIn Excel for the web, select a cell, choose Insert > Link, and select the destination sheet or…
- How to Insert a Digital Signature in WordIn Word for Microsoft 365 on Windows, add a visible signing area with Insert > Text > Signature…
- Merge Cells in Excel: How to Add, Use, and Unmerge ThemTo merge cells in Excel, select the adjacent cells, then choose Home > Merge & Center. Use the…
- How to Remove Formatting Marks From a Word DocumentTo hide formatting marks in Word, select Home > Paragraph > Show/Hide ¶, or press Ctrl+Shift+8 on Windows…
- Out of Office in Outlook on the Web: Automatic RepliesTo set an out-of-office message in Outlook on the web, open Settings, find Automatic replies, turn them on,…
- How to Normalize Cell Size in Excel for a Consistent LayoutTo normalize cell size in Excel, select the rows you want to standardize and choose Home > Format…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.