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?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |