How to Clear an Excel Sheet and Keep All Formulas

Yes. In Excel for Microsoft 365 on Windows, select the cells, then choose Home > Find & Select > Go To Special > Constants, click OK, and press Delete; this clears entered values and text while leaving formula cells intact. If you only want to clear a particular input range, select that range first so you do not remove labels or fixed values elsewhere.

The safest way to clear values but keep formulas

Excel distinguishes between a constant, which is typed directly into a cell, and a formula, which begins with an equals sign and calculates a result. The Go To Special command can select constants without selecting formulas. Deleting the selected constants therefore removes data entered by a person but preserves formulas in the selected area.

Select the range you want to clean. To work across the worksheet, use the Select All button at the upper-left corner of the grid, where the row and column headings meet.
On the Home tab, choose Find & Select, then Go To Special.
In the dialog box, choose Constants. Leave the Number, Text, Logicals, and Errors options checked to select all types of typed-in constants, or clear a category if you want to preserve it.
Click OK. Excel highlights the matching cells within the selected area.
Press the Delete key. The constants are cleared, and formulas are left in place.

Before deleting, look over the selection if the sheet contains important text or fixed numbers. Constants include much more than temporary entries: headings, notes, dates, manually entered totals, and error values typed into cells can all be selected. If those should remain, use a narrower range or adjust the categories in Go To Special.

Why pressing Delete normally removes formulas

The Delete key is not a formula-preserving command by itself. It clears the contents of every selected cell, whether that content is a typed value or a formula. For example, selecting cells A1:A10 and pressing Delete clears a formula in A10 just as readily as a typed number in A2. The reliable distinction comes from selecting constants first, rather than deleting an ordinary range directly.

For a small sheet, you can inspect cells and select only the entries to remove. For a large worksheet, that approach is slow and easy to get wrong. Go To Special is useful because it makes a selection based on the type of cell content. A formula that currently displays 250 is still a formula and is not selected as a constant. Similarly, a formula returning text remains a formula; the displayed result does not change its underlying type.

What the Excel Clear commands remove

The Home tab includes a Clear menu, but its commands do different jobs. Knowing the difference helps prevent accidental loss of formulas or formatting:

Clear Contents: Removes formulas and typed values from the selected cells, but generally leaves their formatting in place. It does not preserve formulas.
Clear Formats: Removes cell formatting, such as number formats, fill colors, borders, and font styling, while leaving cell contents and formulas.
Clear All: Removes contents and formatting and can also remove other cell-level items. It is not appropriate when formulas must remain.
Clear Hyperlinks: Removes hyperlinks from selected cells; check the resulting formatting if the appearance matters.

To use the ordinary content-clearing command, select cells and choose Home > Clear > Clear Contents. That command is useful when you intend to remove everything in the selected cells, formulas included. It is not the same as Go To Special > Constants followed by Delete. The latter first filters the selection so formula cells are not targeted.

Choose the right range before clearing

The scope of the selection is just as important as the command. Selecting a specific input block is usually safer than selecting an entire worksheet. Suppose a monthly report has typed sales figures in B4:B15 and formulas in C4:C15. If you select only B4:B15 and clear contents, the formulas in column C are not selected and remain untouched. If there are formulas mixed into B4:B15, use Go To Special > Constants within that range instead of clearing the whole range.

When clearing an entire sheet, Excel may select headings, instructions, data-validation messages entered as cell text, and static reference values along with the temporary inputs. Go To Special does not know which constants are disposable; it only identifies constants. Review what is highlighted, and consider preserving a clean template copy before removing a sheet’s contents.

On Windows, the Select All button is the small triangle above row 1 and to the left of column A. Ctrl+A can also select cells, but its behavior depends on where the active cell is: it can first select a current data region, and another press may be needed to expand the selection. The button is often clearer when the goal is the whole worksheet. The same Select All control is available in Excel for Mac.

Formulas, tables, and spilled results

In an Excel table, a calculated column may contain a formula in each row, while adjacent columns contain manually entered records. Selecting constants in the appropriate table columns can clear entered records without selecting formula cells. Be careful with column headers and any fixed lookup values in the table: they are constants too. Excel may also automatically extend a calculated-column formula when new rows are added, so clearing input cells is different from deleting the table or its columns.

Dynamic array formulas need a little extra care. A spilled result is produced by one formula in an anchor cell; the displayed results in the spill area are not separately entered formulas. Usually, Go To Special identifies the anchor formula rather than treating each displayed result as a constant. Do not try to delete only part of a spill range: Excel can block edits to part of the range because the anchor formula controls it. To preserve the result-generating formula, leave the anchor cell alone and clear only the actual input cells that feed it.

Similarly, legacy array formulas can restrict editing of only part of an array. If Excel reports that part of an array cannot be changed, do not force a partial deletion. Identify the array’s full range and determine whether it is safe to modify; preserving an array formula may require leaving its entire formula range intact.

Ways to make a reusable sheet safer

If people regularly clear input data from a template, mark input cells clearly and separate them from calculation cells. Different fill colors, instructions, and consistent columns can make the intended selection obvious. These visual cues do not prevent deletion, but they reduce the chance of selecting the wrong cells.

You can also protect formula cells. On the Review tab, choose Protect Sheet and set the permissions appropriate for the worksheet. By default, cells are marked as locked, but that setting only takes effect after sheet protection is enabled. To let users edit inputs while protecting formulas, first select the input cells, open Format Cells, go to the Protection tab, and clear Locked; then protect the sheet. Keep the password somewhere safe if one is used, and test the workflow on a copy. Worksheet protection helps prevent routine edits, but it is not a substitute for a backup or a security system.

For a recurring cleanup, consider saving a separate untouched template or duplicating the sheet before clearing it. Undo may reverse a recent deletion, but it is not a dependable recovery plan after many later actions, closing the workbook, or running other operations. Save a copy before a large cleanup, especially when the workbook contains linked reports or important calculations.

Common problems and how to avoid them

Formulas disappeared: The range was probably cleared directly, or Clear Contents or Clear All was used. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then use Go To Special > Constants.
Headings vanished too: Headings are constants, just like typed data. Select only the input range, or preserve headings outside the selected range.
Some cells were not selected: Check whether the cells are formulas, merged cells, or outside the range you selected. Go To Special only acts within the current selection.
Excel will not clear a cell: The cell may belong to a spilled or legacy array formula, or the sheet may be protected. Check the formula range or review the protection settings instead of deleting surrounding cells at random.
Formatting remains after clearing: That is expected when contents are deleted. Use Clear Formats only if formatting also needs to go, and remember that it does not remove formulas.

On Mac, the Go To Special option is available through Excel’s Home tab and Find & Select in current Microsoft 365 versions; labels or ribbon arrangement can vary slightly by release. The Delete key clears selected contents, while the Undo shortcut is Command+Z rather than Windows Ctrl+Z. When a shortcut or key label differs across keyboards, using the ribbon command is the clearest route.

Frequently Asked Questions

How do I delete data in Excel without deleting formulas?
Select the range, choose Home > Find & Select > Go To Special > Constants, and click OK. Press Delete to clear the selected constants while leaving formulas untouched.

Does Clear Contents keep formulas in Excel?
No. Clear Contents removes both typed values and formulas from selected cells. To keep formulas, select constants with Go To Special first, then delete that selection.

Will Go To Special select a formula that displays a number?
No. A cell containing a formula is still a formula even when its result looks like a number, date, or text. Go To Special > Constants selects directly entered content, not formula results.

Can I clear an entire worksheet and keep its formulas?
Yes, but select the whole sheet and use Go To Special > Constants rather than Clear All. This also selects fixed text and numbers, including headings, so inspect the selection or restrict the operation to the input areas.

Can I undo a formula deletion?
Usually, press Ctrl+Z on Windows or Command+Z on Mac immediately after the mistake. If you have continued working, closed the workbook, or cannot undo the action, restore a saved copy or use the workbook’s available version history.

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.