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
Note: kutools for Excel 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/absolute reference in Excel 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.
- On the Kutools Tab, select the More option, choose the Convert Refers option from the menu.
- 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.
- 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.
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. Keep Learning!
Top comments (0)