Data Import & Export

Copy Filtered Excel Data to a Summary Workbook Without Formulas

Muhammad TalhaMuhammad Talha Nov 18, 2026 868 views

Question details

Copy filtered source data into a summary workbook without transferring formulas.

Copy Filtered Excel Data to a Summary Workbook Without 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.
Before you start

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.

Solution 1Recommended

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.

1
Filter the source data

Open the source workbook, select the data range, and choose Data > Filter. Use the column filter arrows to display the records you need.

2
Select visible cells

Select the filtered range, including headers if needed. Choose Home > Find & Select > Go To Special, select Visible cells only, and click OK.

3
Copy and paste values

Copy the selection, open the summary workbook, and select the destination cell. Choose Home > Paste > Paste Special > Values.

4
Check the summary

Compare the pasted rows and columns with the filtered source. Check missing and duplicate records against the rules you defined.

Copy visible Excel rows and paste them as values
Values are a snapshot: The pasted results do not update automatically when the source data changes. Repeat the copy and paste process to update the summary.
Work with filtered data in WPS

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. 1. Open the workbooks: Open the source workbook and the summary workbook in WPS Spreadsheets.
  2. 2. Apply the filter: Select the source data and choose Data > Filter. Use the filter arrows to show the required records.
  3. 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. 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.
Create a summary without copying source formulasOpen and save Microsoft Excel XLSX and XLS filesFilter and review records in a familiar spreadsheet interfaceUse a free, lightweight Office suite
microsoft office alternative - wps office

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.