Short Answer 
To clear contents in Excel while keeping formulas intact, first highlight the desired cell range. Then, use the ‘Go To Special’ feature under the ‘Find & Select’ menu to select non-formula cells, and finally, press ‘Delete’ or right-click and choose ‘Clear Contents’ to remove the data.
Step 1: Select Your Range
Begin by highlighting the specific range of cells in Excel where you want to clear contents while retaining the existing formulas. You can do this by clicking and dragging your mouse over the desired cells or by clicking the first cell, holding down the ‘Shift’ key, and then clicking the last cell in the range.
Step 2: Use Go To Special Feature
Next, navigate to the ‘Home’ tab on the ribbon, and click on the ‘Find & Select’ button. From the drop-down menu, select ‘Go To Special’. In the dialog that appears, choose ‘Constants’ while ensuring that all boxes except for ‘Formulas’ are unchecked. After setting the options, click ‘OK’ to select all the cells that do not contain formulas.
Step 3: Clear Contents
Finally, with the non-formula cells selected, press the ‘Delete’ key on your keyboard to clear their contents. Alternatively, if you prefer a manual method, after selecting your cells, right-click on the highlighted area and choose ‘Clear Contents’ from the context menu. This will remove data without affecting any formulas present in your selected range.