Copy Filtered Excel Data to a Summary Workbook Without Formulas
Question details
Copy filtered source data into a summary workbook without transferring formulas.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user needs to filter raw data and place selected columns and records in a separate workbook for review.
- Observed behavior
- The desired summary contains the filtered results as values rather than worksheet formulas.
Identify the source columns, filter criteria, destination sheet and starting cell. Decide how to handle missing or duplicate records and whether the summary needs to be refreshed.
Copy visible Excel rows and paste them as values
Use this method for a one-time summary or when you prefer to update it manually.
Open the source workbook, select the data range, and choose Data > Filter. Use the column filter arrows to display the records you need.
Select the filtered range, including headers if needed. Choose Home > Find & Select > Go To Special, select Visible cells only, and click OK.
Copy the selection, open the summary workbook, and select the destination cell. Choose Home > Paste > Paste Special > Values.
Compare the pasted rows and columns with the filtered source. Check missing and duplicate records against the rules you defined.

Load a filtered summary with Excel Power Query
Use Power Query when the summary should be refreshed from the source workbook.
Create a values-only summary in WPS Spreadsheets
Use WPS Spreadsheets to filter an Excel-compatible workbook, copy the displayed results, and paste them as values into a separate summary workbook.
- 1. Open the workbooks: Open the source workbook and the summary workbook in WPS Spreadsheets.
- 2. Apply the filter: Select the source data and choose Data > Filter. Use the filter arrows to show the required records.
- 3. Copy the results: Select the filtered range and choose Copy. Check that the copied range contains the columns and visible records you need.
- 4. Paste values into the summary: Select the destination cell in the summary workbook and choose Paste Special > Values. Check the pasted rows against the filtered source, then save the workbook.

Frequently Asked Questions
How do I avoid copying hidden rows in Excel?
After filtering and selecting the source range, choose Home > Find & Select > Go To Special > Visible cells only before copying.
Will Paste Values keep the original formulas?
No. Choose Home > Paste > Paste Special > Values to paste the displayed results rather than the source formulas.
Can the summary update when the source data changes?
A manually pasted summary is a snapshot. For a refreshable summary, connect to the source through Data > Get Data, load the filtered Power Query results, and use Data > Refresh All.
Does filtering automatically remove duplicate records?
No. Filtering selects records based on your criteria; it does not necessarily remove duplicates. Decide which duplicates to keep or remove and review the results before sharing the summary.




