Forum Discussion

rockhound_65's avatar
rockhound_65
Copper Contributor
Jun 21, 2021

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 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.

1 Reply

  • 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.

Resources