Forum Discussion
How to clear contents of a row while retaining formulas in certain cells used for the columns.
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 ...
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.