Excel Guides

Deleting Everything Except Formulas in Excel

Deleting everything except formulas in Excel can be done by using the Go To Special feature. Go To Special allows you to select cells based on specific criteria, such as cells that contain formulas. To use Go To Special, follow these steps:

  1. Select the range of cells that you want to check for formulas.
  2. On the Home tab, in the Editing group, click Find & Select.
  3. Click Go To Special.
  4. In the Go To Special dialog box, click Formulas, and then click OK.
  5. Excel selects all cells that contain formulas. Any cells that dont contain formulas are not selected.
  6. Press DELETE to delete the selected cells.

Note: If you accidentally delete a cell that contains a formula, you can press CTRL+Z to undo the deletion. If you want to check which cells in your worksheet contain formulas, you can use the Formula Auditing feature.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.