Excel 2016 Tip: Delete cell contents except formulas

Updated 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


Your Comment

Email (We dont publish it)


Nothing yet..be the first to share wisdom.