How to Create a Values-Only Sheet from Formula Results in WPS Office Spreadsheets
Question details
The user wants to turn formula results from a template sheet into a separate sheet that contains editable values instead of formulas.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Using a formula-driven template and needing a separate editable output sheet.
- Observed behavior
- Direct cell references such as =Sheet2!A1 keep the results as formulas, so the output sheet is not an editable values-only copy.
Open the workbook in WPS Office Spreadsheets and identify the formula sheet that contains your results and the destination sheet where the editable values should go. If you want a static copy, select the exact range whose formula results you need to convert before copying.
Create a Linked Sheet with Formula References
Use this method when Sheet3 must update automatically whenever the formula sheet changes, even though the cells still contain formulas.
Click the Sheet3 tab in WPS Office Spreadsheets, or create a new sheet by clicking the plus (+) icon next to the existing sheet tabs.
In cell A1, type =Sheet2!A1 and press Enter. WPS Spreadsheets will display the current value from Sheet2.
Select cell A1 and drag the fill handle across and down to cover the same range as your formula results on Sheet2.
Copy Formula Results and Paste as Values
Use this method when you need a separate sheet with editable static values that will not change when the formula sheet changes.
Create a Values-Only Sheet in WPS Office Spreadsheets
WPS Office Spreadsheets can directly create a separate values-only sheet by copying the formula results and using Paste Special > Values. This produces an editable static output while preserving your original formula template.
- 1. Open the workbook in WPS Office Spreadsheets: Launch WPS Office, open your Excel-compatible workbook, and locate the sheet with the formula results.
- 2. Select the formula results: Click the formula sheet tab, then select the range whose calculated results you want to copy as values.
- 3. Copy the range: Press Ctrl+C, or click Home > Copy in the WPS Spreadsheets ribbon.
- 4. Create or open the values sheet: Click the plus (+) icon next to sheet tabs to add a new sheet, or click the target Sheet3 tab.
- 5. Paste values and edit: Right-click cell A1 on the target sheet, choose Paste Special > Values, and then edit the pasted values as needed.
Frequently Asked Questions
What is the difference between a linked result sheet and a values-only sheet?
A linked sheet uses formulas like =Sheet2!A1, so it updates automatically but still contains formulas. A values-only sheet contains the static results and can be edited independently.
How do I paste values without pasting formatting in WPS Office Spreadsheets?
After copying the formula cells, go to the destination cell, right-click, and choose Paste Special > Values, or use Home > Paste > Values. This pastes the current values without carrying over the original formulas.
Will Paste Special > Values break the connection to the original formula sheet?
Yes. Once you paste as values, the destination cells show editable numbers or text and will no longer update when the original sheet changes.
Can I convert a whole worksheet with formulas to values at once?
Yes. Click the triangle at the intersection of the row and column headers to select the entire sheet, copy it, and then use Paste Special > Values in the destination sheet.
