Excel Forum
Similar Content
Change Formulas to Absolute or Relative References
Macro: This macro will change the formulas in cells to absolute or relative. It allows you to cha...
Calculate Percent Change in Excel
Tutorial: How to calculate the percentage amount that a value has changed in Excel. This includes q...
Dynamic Named Range in Excel
Tutorial: How to create a named range that expands automatically when a new value is added to the r...



Excel Name Trick #11: Global Percentage Change Formula


This relative cell reference name formula can work on any and all sheets in a workbook! See how to create a formula as a name in memory that uses relative cell references and can be used on any sheet!

Create a percentage change formula as a name with relative cell references that can be used on any sheet.

Amazing Relative Cell Reference Name Trick!

This is a logical (beginning to end) story about most of the use for Excel Names. In this series you will see 12 amazing uses for Excel Names (14 total Name Tricks).





Got a Question? Ask it Here in the Forum.