How to Delete a Formula in Excel?

Select the cell or range containing the formula

Press Delete

Or right-click the cell and choose Clear Contents

Or go to the Home tab and select Clear > Clear Contents

To remove formulas but keep results, copy the cells and use Paste Special > Values

To delete formulas in multiple cells, select the range and clear the contents

To remove formulas from an entire sheet, select all cells and clear the contents

Suggested for You

Trending Today