November 14, 2013

Excel Tricks – Learn How to Utilize Relative & Absolute Values

Written by

When entering formulas, it’s important to realize that Excel uses two different kinds of cell references. The two kinds are “relative” and absolute.” Absolute references are based around exact values, while relative references are movable. If you don’t reference cells properly when making formulas it can become a mess if data is changed or moved.

Check out the video!

Here’s a quick recap:
– For a relative value, simply enter the cell column and row
– For an absolute value, a $ must go before the fixed value.
– For example, $B1 means Column B is fixed, B$1 means Row 1 is fixed and $B$1 means both the column and row are fixed.

Subscribe to our YouTube channel for other great videos!