Excel 2016 Tip: Delete cell contents except formulas

Posted on 09th December 2016

If you have an Excel worksheet that contains formulas in some cells and you want to clear all he cell contents without deleting the formulas, this is how you do it.

  • On the Home tab, in the Editing group, click Find & Select, and then click Go To Special. Alternatively press CTRL+G or F5 to open the Go To dialog box and click on Special.
    excel 2016 find and select
    excel 2016 goto special
  • On the Go To Special Dialog box select Constants.
  • Click OK.
  • This will select only the cells that contains numbers or text. Cells that contain formulas are not selected.
  • Now you can press the delete key to delete the contents of the selected cells.

Post a comment


Nothing yet..be the first to share wisdom.