Absolute / Relative

Modified on Fri, 22 Jul 2022 at 08:13 PM

Sometimes, existing formulas need to be updated to transform absolute references like $A$1 in relative references like A1.

In such cases, this feature can come in handy by allowing you to add or remove the dollar signs on an existing range.


To use this:

  • Select the range for which the formulas need to be fixed.
  • Click Absolute / Relative from the Excel ribbon of Power-user.
  • The below window will open:Power-user l Absolute / Relative
  • Select the option that works best for you. You can apply absolute or relative reference to the row or column reference.
  • Click OK to validate. The changes will affect all cell references in the formulas from your selected range.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us how can we improve this article!

Select atleast one of the reasons

Feedback sent

We apprciate your effort and will try to fix the article