Clear Excel Spreadsheet but Keep Formulas in Place

To clear entered values in Excel while keeping formulas, select the cells to clean, choose Home > Find & Select > Go To Special > Constants, then press Delete. Excel selects constant values rather than formula cells, so the formulas remain; first limit the selection to the input area if you also need to keep headings and labels.

What “clear but keep formulas” means

An Excel cell can contain a value entered directly, a formula, or formatting and other settings. A typed number, date, or label is a constant. A formula is an instruction Excel calculates, such as a total that refers to other cells. Clearing constants removes the direct entries but leaves formula instructions in place.

This is useful when a workbook is a reusable template: you might want to remove last month’s sales entries while retaining the calculated totals, or clear a questionnaire’s responses without rebuilding its scoring cells. It is not the same as deleting an entire row or column, which can shift other cells and change formula references.

One important consequence is that a preserved formula may display a different result after its inputs are cleared. It could show zero, a blank, or an error, depending on how it was written and what other cells it uses. The formula is still present even if its displayed result changes.

The safest method for a selected input range

If you know where people enter information, select just those cells first. This is usually safer than selecting the whole worksheet, because a broad cleanup can also erase static headings, instructions, or lookup values that are not formulas.

Select the input range, such as the cells where users type weekly quantities. You can select multiple separate ranges by holding Ctrl while selecting each range on Windows.
On the Home tab, choose Find & Select > Go To Special. You can also open Go To with Ctrl+G or F5, then choose Special.
In the Go To Special dialog, choose Constants. Leave Formulas unselected. The checkboxes for Numbers, Text, Logicals, and Errors control which kinds of constants are included; keep the relevant types checked for the entries you intend to remove.
Choose OK, then press the Delete key. Alternatively, choose Home > Clear > Clear Contents.

Excel selects the matching cells inside the selected area, and the clear command removes their contents. Formula cells in that area are not selected as constants, so they are left alone. For example, if a form has typed responses in B2:B20 and formulas in C2:C20, selecting B2:C20 and choosing Constants clears the entered responses while leaving the calculations in column C.

Clearing constants across a worksheet

If the goal is to remove every directly entered value from a sheet while preserving its formulas, select the entire worksheet before using Go To Special. Click the Select All button at the intersection of the row numbers and column letters, then use Home > Find & Select > Go To Special > Constants. Review the selected cells before pressing Delete.

This approach also selects constant text, so it can remove titles, explanatory notes, fixed category names, and labels along with data-entry values. Formula cells are spared, but the sheet may still become difficult to understand if its labels disappear. For most reusable workbooks, it is better to identify the actual input cells and target only those ranges.

If constants include some things you want to keep, use the Go To Special checkboxes thoughtfully. For example, choosing only Numbers will leave text labels and dates stored as text untouched, but dates in Excel are stored as numbers and may therefore be selected. The selection is based on cell contents and types, not on whether a value seems important to the workbook.

What gets preserved—and what does not

Pressing Delete or using Clear Contents removes cell contents; it does not normally remove cell formatting. Number formats, fill colors, borders, font styles, data validation rules, and conditional formatting are separate from the contents. A blank cell can therefore keep its colored fill or dropdown list after its typed entry is removed.

That can be desirable in a template: users see the same layout and entry prompts next time. If you want to remove formatting as well, Excel has separate commands under Home > Clear, including Clear Formats and Clear All. Do not choose Clear All when preserving formulas is the goal, because it removes formulas along with other cell contents.

Clearing constants does not delete worksheet names, charts, shapes, or comments and notes. Nor does it remove formulas embedded in cells that were selected as formulas rather than constants. If a workbook contains other kinds of material to reset, inspect those separately instead of assuming a contents-clearing command resets the whole sheet.

How Excel tables and templates affect the result

In an Excel table, a column may contain manually entered values while another column contains a calculated-column formula. Selecting the input cells and clearing their constants preserves the table structure and its formula cells. Table headers are also direct text entries, however, so selecting the whole sheet and clearing all constants can erase them. Keep the selection to the table’s input rows and columns when headers should remain.

Some tables automatically fill a formula down a calculated column when a new row is added. Clearing the formula cells themselves is different from clearing their inputs: the former removes calculations, while the latter leaves existing formulas available to recalculate. If Excel later creates or copies formulas as you add table rows, that is table behavior, not evidence that the original formulas were deleted by clearing constants.

For shared templates, it helps to mark input cells with a consistent fill color or use data validation, then document which ranges are safe to reset. A simple instruction such as “clear entries in the white cells only” reduces the chance that someone will erase a fixed label or a formula by selecting too much.

Common mistakes and how to avoid them

Using Clear All: This removes formulas as well as constants and formatting. Use Go To Special > Constants followed by Delete, or use Clear Contents on a range that contains only the intended inputs.
Selecting the whole sheet without checking: Static text is a constant too. Target input ranges, or inspect the highlighted cells before clearing a worksheet-wide selection.
Confusing a displayed result with a formula: A cell showing 125 may contain a formula or a typed value. Select the cell and check the formula bar; a formula begins with an equals sign. Go To Special is useful because it distinguishes formulas from constants for you.
Expecting formulas to keep the old answer: A formula recalculates from the remaining inputs. Clearing the inputs does not freeze its previous result. If you need to retain historical results, save a separate copy or convert the relevant results to values in a separate archive, taking care not to overwrite the live formulas.
Forgetting that Undo is temporary protection: Ctrl+Z may undo a recent clear operation, but it is not a substitute for a backup, especially in a complex workbook or after more actions have been taken. Save a copy before a large reset.

Excel for Mac and Excel for the web

The steps above use Excel for Microsoft 365 on Windows. In Excel for Mac, the Go To Special feature is also available, though the ribbon layout and shortcut conventions can vary by release. Use the Home tab’s Find & Select command if it is shown, or open Go To with Control+G and look for Special. Mac keyboards and settings differ, so use the menu command if the shortcut does not behave as expected.

Excel for the web has a more limited set of desktop selection tools, and Go To Special may not be available in the same way. For a large cleanup that must distinguish constants from formulas across a sheet, open the workbook in the desktop app. In the web version, the safer practical option is to select known input cells manually and press Delete, avoiding formula cells. Check the selected range carefully before clearing.

When another approach makes more sense

If you regularly need to reset the same workbook, define the intended input ranges and use them consistently rather than repeatedly clearing the whole sheet. You can also protect formula cells through Review > Protect Sheet so ordinary editing is limited to the cells meant for entry. Protection is a guard against accidental changes, not a replacement for a backup or a security boundary for sensitive information.

For one-off cleanup, selecting the input cells and using Clear Contents is often simplest when the range contains no formulas. Use Go To Special > Constants when the selected region mixes entered values and formulas. For a workbook used as a repeatable form, saving a clean master copy and making a working copy each time is often easier to audit than trying to restore a complicated sheet after a reset.

Frequently Asked Questions

Does pressing Delete in Excel remove formulas?
Yes, if the selected cells contain formulas, pressing Delete clears those formulas too. First use Go To Special > Constants to select only directly entered values, or select only the input cells you intend to empty.

Can I clear values in the whole sheet without deleting formulas?
Yes. Select the worksheet, use Home > Find & Select > Go To Special > Constants, and press Delete. This also removes constant labels and notes, so inspect the selection and consider targeting only the relevant input areas.

Will Clear Contents remove formatting?
No. Clear Contents removes the contents of the selected cells but normally leaves their formatting and other cell settings. Use Clear Formats only when you also intend to remove formatting; do not use Clear All if formulas must remain.

Why does a formula show zero or an error after I clear cells?
The formula remains, but its result depends on the values it references and on its own logic. Removing an input can change the calculation or leave it without a usable value. Check the formula bar to confirm the formula is still present, then decide whether the result is expected.

Can I clear only numbers and leave text?
Yes. In Go To Special, choose Constants and leave Numbers selected while deselecting the other types. Dates are commonly stored as numbers in Excel, so they may be selected too. Test the selection on a small range if dates or other special values must be preserved.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.