How to Copy Exact Formulas without Changing Cell References in Excel?
Tags: copyexactformulasine, kutoolsexceltutorial, kutools
Published: 2020-10-30 11:56:53

---
title: How to Copy Exact Formulas without Changing Cell References in Excel?
published: true
date: 2020-10-30 09:24:20 UTC
tags: CopyExactFormulasinE,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-copy-exact-formulas-without-changing-cell-references-in-excel/
---

This article describes the steps to **Copy Exact Formulas without Changing Cell References 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.
## Copy Exact Formulas:

If you copy and paste the range of cells that contains the formula, Excel will adjust the relative cell references automatically. But, you can Copy and paste the exact formula cells without changing the [relative reference](https://geekexcel.com/how-to-use-relative-reference-in-excel-office-365-with-examples/) with the help of Kutools.

- Go to the **Kutools Tab, select** the **Exact Copy** option.

![Select the Exact Copy option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-39.png)<figcaption id="caption-attachment-16565">Select the Exact Copy option</figcaption>

- It will open the **Exact Formula Copy Dialog box** , you need to **select a range** that you want to copy without changing the cell reference in **A**.
- Then, **click** the **OK** button.

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

- Now, another dialog box will pop out to ask you the range to display the result. You need to select any single cell to paste the result and **hit** the **OK** button.

![Select a single cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-a-single-cell.png)<figcaption id="caption-attachment-16567">Select a single cell</figcaption>

- At last, it will paste the formulas cells without changing the cell ([Absolute](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/)/[Relative](https://geekexcel.com/how-to-use-relative-reference-in-excel-office-365-with-examples/)) References.
- Refer to the below screenshot.

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

### Note:

- If you **check** the **Copy formatting** option, it will keep all cell formatting after pasting the range.

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

- This utility supports Undo **(CTRL** + **Z** ) action.

## Verdict:

In this article, you can clearly understand the steps to **Copy Exact Formulas without Changing Cell References in Excel Office 365** using **Kutools. ** Leave your **queries/suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Filter Cells by Background Color in Excel 365?](https://geekexcel.com/how-to-filter-cells-by-background-color-in-excel-365/)
- [How to Find and Select Merged Cells in Excel Office 365?](https://geekexcel.com/how-to-find-and-select-merged-cells-in-excel-office-365/)
- [Remove All Macros within Worksheet or Workbook in Excel Office 365](https://geekexcel.com/how-to-remove-all-macros-within-worksheet-or-workbook-in-excel/)