How to Remove Formulas from an Excel Worksheet and Keep Results in WPS Office
Question details
User needs to replace formulas in an Excel worksheet with their calculated values before cleaning or rebuilding a workbook.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is cleaning or rebuilding a workbook and wants to keep only the calculated results, not the underlying formulas.
- Observed behavior
- The goal is to have static values that show the current formula results while removing the formula references.
Save a backup copy of the original workbook and confirm that the selected range contains only the formula cells you want to replace with their calculated results.
Use Paste Special > Values to Replace Formulas with Current Results
Best for keeping the displayed values exactly and removing all formulas from the selected range.
This method copies the calculated values and pastes them over the formulas, leaving static data in place. Avoid using Find and Replace to remove equals signs because it can damage formulas and other workbook content.
Open the workbook in WPS Office Spreadsheets and select the cells that contain the formulas you want to remove.
Right-click the selection and choose Copy, or press Ctrl + C.
Right-click the same selected range and choose Paste Special > Values, or go to Home > Paste > Values.
Click the paste option to replace the formulas with their calculated values, then click outside the range and check a cell to confirm it shows a value instead of a formula.
Use the Home Tab Paste Values Shortcut
A quick alternative when you prefer using the ribbon instead of the right-click menu.
Remove Formulas and Keep Values with WPS Office Spreadsheets
WPS Office Spreadsheets lets you convert formulas to their calculated values with a simple copy and paste values workflow, so you can clean or rebuild workbooks without losing current results.
- 1. Open the workbook: Launch WPS Office Spreadsheets and open the Excel workbook that contains the formulas.
- 2. Select the formula range: Highlight the cells or entire worksheet area where you want formulas replaced by values.
- 3. Copy and paste values: Copy the selection, then right-click and choose Paste Special > Values, or use Home > Paste > Values.
- 4. Check the results: Select a converted cell and confirm the formula bar displays a static value instead of a formula.
Frequently Asked Questions
Will Paste Special > Values keep my cell formatting?
Yes, in most cases it keeps the cell formatting and pastes only the calculated values over the existing selected cells. Check custom formatting after pasting if it is important.
Can I remove formulas from an entire worksheet at once?
Yes, press Ctrl + A to select the whole sheet or click the triangle at the top-left corner, then copy and paste as values. Be careful if the sheet contains array formulas or hidden cells.
What is the difference between Paste Values and Paste Special > Values?
Both replace formulas with their results. Paste Values is a quick ribbon option, while Paste Special > Values gives more control over the paste operation.
How can I restore the formulas after replacing them with values?
Use Undo immediately after the paste, or open the backup copy you saved before making the change.
Does WPS Office support Excel files with formulas?
Yes, WPS Office Spreadsheets opens and edits Excel .xlsx files and can replace formulas with their calculated results.
