Absolute / Relative

Modified on Thu, 22 Sep, 2022 at 5:11 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 know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article