How to Copy a FILTER and LET Excel Table as Values in WPS Spreadsheets
Question details
The user needs to copy a FILTER and LET generated table in WPS Spreadsheets to another worksheet as static values, without retaining the formulas or dependency on the original source table.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user generated a table with FILTER and LET functions linked to Table 1 and wants to move the results to another worksheet without carrying the formulas or dependency.
- Observed behavior
- A normal copy and paste may keep the FILTER and LET formulas, so the copied table still depends on the original Table 1 source.
Open the workbook in WPS Spreadsheets and locate both the formula-generated table and the destination worksheet. Decide the exact upper-left cell where the static values should be pasted.
Copy the FILTER and LET Table and Paste Only Values
Use this method when you want to keep the current table output but remove the FILTER and LET formulas and the link to the source Table 1.
FILTER and LET create dynamic results that depend on the original source table. Pasting as values replaces the formula output with static data, so the destination worksheet no longer updates when the source changes.
Click any cell inside the FILTER and LET output range, then select the full spilled table area that you want to copy.
Press Ctrl+C, or right-click the selected table and choose Copy.
Click the sheet tab of the destination worksheet, then select the upper-left cell where the pasted values should start.
On the Home tab, open the Paste drop-down menu and choose Values or Paste Values.
Check the pasted cells to confirm they now contain static values and no longer show FILTER or LET formulas in the formula bar.
Paste a FILTER and LET Table as Values in WPS Spreadsheets
WPS Spreadsheets lets you copy the formula-generated table and use Paste Values to keep only the displayed results. This removes the FILTER and LET formulas and the link to Table 1 while preserving the current output.
- 1. Open the workbook in WPS Spreadsheets: Launch WPS Spreadsheets, click Menu, and open the workbook that contains the FILTER and LET table.
- 2. Copy the generated table: Select the FILTER and LET output range and press Ctrl+C, or right-click the selection and choose Copy.
- 3. Choose the destination cell: Click the sheet tab of the destination worksheet and select the upper-left cell where the values should start.
- 4. Paste as values: On the Home tab, click Paste and choose Values from the drop-down menu.
- 5. Confirm and save: Check the pasted data to ensure no formulas remain, then press Ctrl+S to save the workbook.
Frequently Asked Questions
Why does my copied table still show formulas instead of static values?
Because a standard Paste command keeps the original FILTER and LET formulas. Use Home > Paste > Values or Paste Values to replace the formulas with their current results.
How do I retain number formats when pasting the FILTER and LET table as values?
Use Paste Values to keep values only, or open Paste Special and choose Values & Number Formats if you also want to keep the formatting from the source table.
Can I paste the FILTER and LET results into another worksheet without linking to Table 1?
Yes. Select and copy the output, click the destination worksheet, select the starting cell, and choose Paste > Values. The pasted range will contain static values only.
Does Paste Values work for spilled array results from FILTER and LET in WPS Spreadsheets?
Yes. Select the full spilled range before copying. Paste Values writes the current spill results into the destination and removes the dynamic array formulas.
Will the pasted values change if I edit Table 1 later?
No. Because Paste Values removes the FILTER and LET formulas, the copied cells are static values and will not update when Table 1 changes.
