Convert Cell Reference to Relative/Absolute Reference in Excel 365!!
Tags: convertcellreference, kutoolsexceltutorial, kutools
Published: 2020-10-31 12:18:05

---
title: Convert Cell Reference to Relative/Absolute Reference in Excel 365!!
published: true
date: 2020-10-31 12:09:11 UTC
tags: ConvertCellReference,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/convert-cell-reference-to-relative-absolute-reference-in-excel-365/
---

In this article, you will learn the steps to **Convert Cell References to Relative/Absolute Reference in Excel Office 365** using **Kutools. ** Let’s step into this article!! 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.
## Change Cell Reference to Relative/Absolute Reference:

To change cell reference to [relative](https://geekexcel.com/how-to-use-relative-reference-in-excel-office-365-with-examples/)/[absolute reference in Excel](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/) spreadsheet, follow the below steps.

- First, you need to **select a range** that you want to convert the cell references.
- In the below example image, you can see the original cell references in **column c**.

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

- On the **Kutools Tab, select** the **More** option, **choose** the **Convert Refers** option from the menu.

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

- Then, it will open the **Convert Formula References dialog box**.
- **Convert formula references –** In this section, you need to choose any one of the options as you need. Here, we choose **To absolute** option.

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

- Finally, **click** the **OK** button to convert the cell reference and close the dialog box.
- At last, you can see the result as shown in the below image.

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

### Note:

- This feature support **Undo** ( **CTRL** + **Z** )operation. Using undo, you can restore the action instantly.
- The input range can include formula cells or non-formula cells, but the non-formula cells will be automatically ignored while converting the cell references.

## Summary:

In the above article, you can easily understand the steps to **Convert Cell References to Relative/Absolute Reference in Excel Office 365** using **Kutools. ** Don’t forget to share your **feedback** in the 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/)