How to Replace Formulas with Calculated Values/Results in Excel 365?
Tags: kutoolsexceltutorial, stepstoreplaceformul, kutools
Published: 2020-10-22 12:15:44

---
title: How to Replace Formulas with Calculated Values/Results in Excel 365?
published: true
date: 2020-10-22 07:22:57 UTC
tags: KutoolsExcelTutorial,StepstoReplaceFormul,Kutools
canonical_url: https://geekexcel.com/how-to-replace-formulas-with-calculated-values-results-in-excel-365/
---

In this tutorial, we will guide you to learn the steps to **Replace Formulas with Calculated Values/Results** in **Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Replace Formulas with Calculated Results:

- You need to **select a range** in which you want to replace formulas with their results.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-24.png)<figcaption id="caption-attachment-16135">Example</figcaption>

- Then, go to the **Kutools Tab,** se **l** ect the **To Actual** option.

![Select To Actual option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-To-Actual-option.png)<figcaption id="caption-attachment-16138">Select To Actual option</figcaption>

- In the below screenshot, we have shown that the values in **Column C** have been changed as follows.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-31.png)<figcaption id="caption-attachment-16139">Result</figcaption>

## Steps to Replace Actual Values with Displayed Values:

- Firstly, you need to **select the input range** in which you want to replace actual values with displayed values.
- In this image, you can see that the date entered in **cell B2** has shown the **actual value** in the formula bar.

![Input range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Input-range-2.png)<figcaption id="caption-attachment-16147">Input range</figcaption>

- Then, On the **Kutools Tab, select** the **To Actual** option.

![Select To Actual option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-To-Actual-option.png)<figcaption id="caption-attachment-16138">Select To Actual option</figcaption>

- Now, you will see the change as shown in the below example.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-38.png)<figcaption id="caption-attachment-16142">Output</figcaption>

## Closure:

In this short tutorial, we helped you to learn how to **Replace Formulas with Calculated Values/Results** in **Excel Office 365** using **Kutools. ** Share your **Queries/Suggestions** in the below comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Replace Multiple Accented Characters with Regular Chars in Excel 365!!](https://geekexcel.com/replace-multiple-accented-characters-with-regular-chars-in-excel-365/)
- [Insert Multiple Checkboxes at Once in Excel Office 365!](https://geekexcel.com/insert-multiple-checkboxes-at-once-in-excel-office-365/)