How to clear contents of a row while retaining formulas in certain cells used for the columns.

[rockhound_65]

Having difficulty removing the contents(numbers) in a row but I want to retain the formulas used (established) for certain columns made on the spreadsheet to be used later for a new entry to replace the old numbers. Not all of the columns on my spreadsheet have formulas being used. When I clear contents of a the row it clears the formulas also. Want to retain formulas used.

[#2]

@rockhound_65 

Select the range from which you want to clear the constant values but keep the formulas.

Press F5 or Ctrl+G to activate the Go To dialog.

Click Special...

In the Go To Special dialog, select Constants, then click OK.

As a result, only cells containing constant values will be selected.

Press Delete to clear the selected cells.