Data Import & Export

Fix Excel Copy and Paste Missing Values from Filtered Data

Emma Brown Oct 19, 2026 870 views

Question details

The user needs to successfully copy and paste all data from a filtered Excel table without values disappearing due to hidden rows.

How to Fix Missing Values When Copying and Pasting Filtered Data in Excel

Product: Excel
Device & OS: not provided
Scenario: Attempting to duplicate or extract data from a table that currently has a filter applied.
Observed behavior: Only visible cells are copied during the process, leaving behind values in hidden rows and making the pasted data appear incomplete.

Before you start

Check your table headers for small funnel icons, which indicate that a filter is currently active and hiding certain rows in your dataset.

Solution 1Recommended

Clear the Table Filter Before Copying

Removing the active filter ensures that all rows, including previously hidden ones, are fully visible and included in your copy-paste action.

When a filter is applied in Excel, rows that do not meet the criteria are temporarily hidden. Standard copying often ignores these hidden rows. By clearing the filter first, you restore the table to its complete state.

Go to the Data tab

Navigate to the **Data** tab located on the main Excel ribbon at the top of the window.

Clear the filter

Locate the **Sort & Filter** group and click the **Clear** button. This will remove the active filter and instantly display all hidden rows.

Copy and paste the data

Highlight the newly revealed complete data range, press **Ctrl + C** to copy, and paste it to your desired destination using **Ctrl + V**.

Data Intact: Clearing a filter does not delete any rules or data; it simply makes all rows visible again.

Solution 2

Paste the Data into a New Unfiltered Worksheet

If you only want the filtered values but are experiencing formatting conflicts, pasting into a brand new sheet can resolve the issue.

Solution 3

Select Visible Cells Only Before Copying

Use Excel's specific selection tool to ensure you strictly grab the visible data and ignore any hidden rows explicitly.

Easily Manage Filtered Data with WPS Spreadsheet

WPS Office Spreadsheet provides an intuitive AutoFilter feature that handles data identically to Microsoft Excel. You can quickly clear filters, manage hidden rows, and copy large datasets without losing valuable information.

1. Open your document: Open your spreadsheet in WPS Office and navigate to the **Data** tab on the top ribbon.
2. Clear or toggle filters: Click the **AutoFilter** button to quickly clear active filters and reveal all hidden rows in your table.
3. Copy the complete dataset: Select the entire data range, press **Ctrl + C** to copy all rows seamlessly, and press **Ctrl + V** to paste the complete dataset into your desired worksheet.

Fully compatible with Microsoft Excel (.xlsx) formatsOne-click filter clearing to prevent missing data during copy-pasteFree, lightweight, and user-friendly interface

Frequently Asked Questions

Why are my copied cells pasting into hidden rows?

When you paste data into a range that still has a filter applied, Excel may paste the values into the hidden rows sequentially, skipping visible rows. To avoid this, clear the filter in the destination area before pasting.

How do I copy only the visible rows in an Excel filter?

Select the filtered data range, press the keyboard shortcut **Alt + ;** to select visible cells only, then press **Ctrl + C** to copy. You can then paste it into your destination using **Ctrl + V**.

Is there a shortcut to clear filters in Excel?

Yes, you can use the keyboard shortcut sequence **Alt + A + C** in Windows to quickly clear active filters in your current worksheet.

Does clearing a filter delete my data?

No, clearing a filter simply removes the hiding rules applied to the rows, making all your original data visible again. It does not delete any values or alter your actual dataset.

Excel & Data Problems