Alternatively use the keyboard and press Delete. Hit the Enter key. Delete table data and keep table formulas ----- Sub deleteKeepFormulas Dim tbl As ListObject Assign table to a variable Set tbl ThisWorkbookSheetsExampleListObjectstblExample Delete table data and keep formulas If Not tblDataBodyRange Is Nothing Then tblDataBodyRangeDelete End If End Sub.
Choose Go To Special.
Clear contents in Microsoft Excel The spreadsheet is now cleaned of all input numbers while all the formulas are preserved and ready to be used for your next spreadsheet. Remove the formulas within a sheet but leave the data highlight the area or the whole sheet Copy it CTRL C or whatever way you use to Copy cells Click on Paste Special you dont have to choose where it will go- it will overwrite what it copied Choose the paste as Values icon. On the Home tab in the Editing group click Find Select and then click Go To. Select the range you want to delete all data but formulas press Ctrl G keys simultaneusly to open the Go To.