An ABSOLUTE REFERENCE in Excel is a cell reference that is "locked" by adding a dollar sign ($) before the cell and column references. This maintains the original cell reference when it is copied. We will get into all that in addition to some examples, tips, and tricks in this video.

My name is Tony and I have a degree in architecture and business administration. Excel is a powerful tool so don’t get discouraged. I’ve spent numerous hours, days, weeks working on my spreadsheets and years learning what I know. My hope is that my tutorials will be a quick way for you to learn what I know in a more condensed timeline.

The ABSOLUTE REFERENCE is a must know essential tool that can be used in numerous applications and workflows. See my courses page for advanced uses of this function in combination with other functions or the related videos section for similar functions.