Now all the data but formulas are selected, and press Delete button on the keyboard or right click to select Delete to remove all data except forluma cells.ĭelete all formulas but keep data with Kutools for Excel Then in the Go To Special dialog, check Constants and click OK to close the dialog. Select the range you want to delete all data but formulas, press Ctrl + G keys simultaneusly to open the Go To dialog, then click Special button in the dialog to open the Go To Special dialog. There is no direct or one-click function to delete all data but formulas in Excel, but you can use Go To Special function to select all data but formulas first and then delete them.ġ.
If you have a worksheet with multiple data including numbers, texts and formulas, and you just want to delete all data but keep the formulas in this worksheet, how can you do?ĭelete all data but keep formulas with Go To Special function in Excelĭelete all formulas but keep data in cells with Kutools for Excel How to delete all data but keep formulas in Excel?