ABSOLUTE and RELATIVE CELL REFERENCE in GOOGLE SHEETS
Brian Turgeon Brian Turgeon
19.5K subscribers
4,506 views
0

 Published On Mar 16, 2022

RELATIVE - When dragging functions, the location of the input cells change relative to the location of the function.

ABSOLUTE - When dragging functions, the reference cell does NOT move as follows...

$A$1: Column and Row do NOT change when copied.
A$1: Row does NOT change when copied.
$A1: Column does NOT change when copied.

*** The $ placed before the letter or number of the cell creates an absolute reference.

show more

Share/Embed