Indeed, you can reference one and the same cell in four different ways, for example A1, $A$1, $A1, and A$1. Get the insight into the difference between absolute, relative and mixed references, and you are halfway to mastering the power and versatility of Excel formulas and functions.Īll of you have probably seen the dollar sign ($) in Excel formulas and wondered what's that all about. The importance of Excel cell reference can hardly be overstated. And this short tutorial provides full details about this great feature. The dollar sign in an Excel cell reference serves just one purpose - it tells Excel whether to change or not to change the reference when the formula is copied to other cells.
When writing an Excel formula, $ in cell references confuses many users.
