Document Editing Problems

Clear Excel Input Data Without Deleting Formulas or Formatting

Adam DavisAdam Davis Nov 20, 2026 870 views

Question details

Clear old input data from an Excel worksheet while retaining formulas and cell formatting for reuse.

Clear Excel Input Data Without Deleting Formulas or Formatting
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the input cells

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.

2
Clear the contents

On the Home tab, choose Clear > Clear Contents. This removes the selected values without removing their cell formatting.

3
Check the formulas

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.

Clear the worksheet's input cells
Formula results may still appear: A formula result cannot be cleared independently of its formula. After inputs are cleared, formulas may display zero, an error, or another result depending on how they are written.
Reuse your worksheet in WPS

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. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Select input cells: Select the cells containing old input values, excluding formulas and labels you want to keep.
  3. 3. Clear the contents: Use Home > Clear > Clear Contents to remove the selected data without clearing the cell formatting.
  4. 4. Check and save: Click a formula cell to check its formula, then use File > Save As to save the reusable workbook.
Clear old inputs without rebuilding worksheet formulasPreserve formatting in cleared cellsOpen and save Microsoft Excel XLSX filesUse a familiar spreadsheet interface
microsoft office alternative - wps office

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.