Question

How to clear contents in excel without deleting formulas

Answer 1

To clear contents without deleting formulas in Excel, use the Go To Special feature by selecting the range, choosing 'Find & Select', clicking on 'Go To Special', selecting 'Constants' whilst unchecking all but 'Formulas', and hitting 'OK' before pressing 'Delete'. Alternatively, manually select cells and choose 'Clear Contents' from the right-click menu.

Step-by-step explanation:

To clear contents in Excel without deleting formulas, you can use the Go To Special feature. This allows you to select all cells that are not formulas and clear their contents. Here's how you can do it:

1. Select the range where you want to clear the contents.
2. Click on the 'Find & Select' button in the 'Home' tab.
3. Choose 'Go To Special' from the drop-down menu.
4. Select 'Constants' and uncheck all the checkboxes except for 'Formulas'.
5. Press 'OK', and Excel will select all non-formula cells.
6. Hit the 'Delete' key on your keyboard to clear the contents of these cells.

Alternatively, you can manually select the cells you wish to clear while avoiding cells with formulas. Select the desired cell or range, right-click, and choose 'Clear Contents' from the context menu.