How To Clear Data But Not Formulas In Excel

Excel Tips
Excel Functions
Excel Formulas
Excel Charts
Word Tips
Outlook Tips

How to delete all data merely keep formulas in Excel?

If yous accept a worksheet with multiple data including numbers, texts and formulas, and you simply want to delete all data but go on the formulas in this worksheet, how can you do?

Delete all information only proceed formulas with Go To Special part in Excel
Delete all formulas only keep data in cells with Kutools for Excel

Delete all data but go on formulas with Go To Special part in Excel

There is no direct or one-click function to delete all information but formulas in Excel, but you tin use Become To Special function to select all information but formulas first and and so delete them.

one. Select the range you want to delete all data but formulas, press Ctrl + K keys simultaneusly to open the Become To dialog, then click Special button in the dialog to open up the Go To Special dialog. Meet screenshots:

2. So in the Go To Special dialog, check Constants and click OK to close the dialog. See screenshot:

iii. Now all the data but formulas are selected, and press Delete button on the keyboard or correct click to select Delete to remove all data except forluma cells.

Delete all formulas but go on data with Kutools for Excel

On the contrary, in this department, nosotros volition bear witness you how to delete all formulas from selected range but keep information in Excel.

Earlier applying Kutools for Excel, please download and install it firstly.

i. Select the range with formulas yous desire to remove but go on the data, so click Kutools > To Actual. See screenshot:

You can see all formulas in selected range are removed immediately, but the calculated results are kept in cells. See screenshot:

If you want to accept a costless trial ( 30-day) of this utility, please click to download it, and and then get to apply the operation co-ordinate higher up steps.

Relative Articles:

Delete all comments in Excel

The Best Part Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity past 80%

Reuse: Rapidly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
Super Formula Bar (hands edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
Select Indistinguishable or Unique Rows; Select Bare Rows (all cells are empty); Super Observe and Fuzzy Discover in Many Workbooks; Random Select...
Exact Re-create Multiple Cells without irresolute formula reference; Motorcar Create References to Multiple Sheets; Insert Bullets, Bank check Boxes and more...
Extract Text, Add Text, Remove past Position, Remove Infinite; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/mean solar day, frequency and more than; Special Filter by bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on cardinal columns; Split Information into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organisation. Full features 30-mean solar day free trial. 60-twenty-four hour period money dorsum guarantee.

kte tab 201905

Role Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

Enable tabbed editing and reading in Give-and-take, Excel, PowerPoint , Publisher, Access, Visio and Project.
Open and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity past 50%, and reduces hundreds of mouse clicks for you every day!

officetab bottom