Skip to main content

Easily replace formulas with calculated values/results in cells in Excel

Author: Kelly Last Modified: 2024-11-18

Kutools for Excel

Boosts Excel With 300+
Powerful Features

Normally you can replace a formula with its calculated result easily in one cell by re-entering the result. And for a big range with many cells, you can select these cells firstly, and then use paste special function to replace formulas with calculated results. However, using Paste Special function will lose all formatting of selected range, such as color, bold, etc.

But Kutools for Excel's To Actual tool will save your time and replace all formulas with their calculated results in selections quickly.

For example, if a cell contains formula =A2*C19/C12, it will convert the formula to its calculated result and use it to fill the cell. If a cell with the value 03/21/2012 formatted as Wednesday, it will fill the cell with value Wednesday.

Replace formulas with calculated results

Replace actual values with displayed values


Click Kutools > To Actual. See screenshot:

shot display actual values 1


Replace formulas with results

1. Please select a range which you want to replace formuals with their results as follows (see screenshot).

shot display actual values 2

2. Then apply the utility (Click Kutools > To Actual). You will see the column N change to as follows. See screenshots:

shot display actual values 2 shot display actual values 5 shot display actual values 3

Replace actual values with displayed values

1. Please select a range which you want to replace actual values with displayed values as follows (see screenshot).

shot display actual values 4

2. Then apply the utility (Click Kutools > To Actual). You will see the change to as follows. See screenshots:

shot display actual values 4 shot display actual values 5 shot display actual values 6

Notes:

1. This tool supports undo (Ctrl + Z).

2. This tool will permanently remove all formulas in selections.

3. If there is numeric data (numbers) in the selection, this tool will convert the numbers to be formatted as text.

Demo: Easily replace formulas with calculated values/results in cells in Excel

 
Kutools for Excel: Over 300 handy tools at your fingertips! Enjoy permanently free AI features! Download Now!

Productivity Tools Recommended

Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...

Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...


Kutools for Excel

Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

šŸŒ Supports 40+ interface languages
āœ… Trusted by 500,000+ users and 80,000+ businesses worldwide
šŸš€ Compatible with all modern Excel versions
šŸŽ 30-day full-featured trial — no registration, no limitations
Kutools for Excel RibbonKutools for Excel Ribbon