Clear Excel Input Data Without Deleting Formulas or Formatting
Question details
Clear old input data from an Excel worksheet while retaining formulas and cell formatting for reuse.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Reuse an existing worksheet for a new job without rebuilding its formulas or formatting.
- Observed behavior
- Input cells should be empty while formula cells and formatting remain intact. Formula results will recalculate based on the cleared inputs.
Identify the cells used for input and distinguish them from formula cells and labels you want to keep. Click a cell and check the formula bar to see whether it contains a formula beginning with an equals sign.
Clear the worksheet's input cells
Use this method when you can identify the cells containing old data and want to preserve formulas and formatting.
In the worksheet, select the cells containing old input data. Select only cells you want to empty; leave formula cells and labels out of the selection.
On the Home tab, choose Clear > Clear Contents. This removes the selected values without removing their cell formatting.
Click a formula cell and check the formula bar to confirm the formula remains. Enter new data in an input cell to verify that the worksheet recalculates.

Select constants in a known input range
Use Go To Special to select non-formula values when an input range contains both values and formulas.
Clear Input Data While Keeping Formulas in WPS Spreadsheets
Open your worksheet in WPS Spreadsheets, select the old input cells, and clear their contents while leaving formulas and formatting in place.
- 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Select input cells: Select the cells containing old input values, excluding formulas and labels you want to keep.
- 3. Clear the contents: Use Home > Clear > Clear Contents to remove the selected data without clearing the cell formatting.
- 4. Check and save: Click a formula cell to check its formula, then use File > Save As to save the reusable workbook.

Frequently Asked Questions
How do I clear values without removing cell formatting?
Select the input cells and choose Home > Clear > Clear Contents. Do not use Clear All, which also removes formatting.
Can I remove a formula's result but keep the formula?
No. The displayed result is calculated by the formula. You can clear its input cells, but the formula will still display a result based on those inputs.
Why does a formula show zero or an error after I clear the inputs?
The formula recalculates using the empty input cells. Depending on the formula, that may produce zero, an error, or another result.
Can Excel select values without selecting formulas?
Select a range, then choose Home > Find & Select > Go To Special > Constants. Constants can include labels and fixed values, so make sure everything selected can be removed before clearing.




