ABSOLUTE and RELATIVE CELL REFERENCE in GOOGLE SHEETS @brianturgeon
ABSOLUTE and RELATIVE CELL REFERENCE in GOOGLE SHEETS  @brianturgeon
Uploaded March 2022 | Updated September 2026, 4 minutes ago
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.
ABSOLUTE and RELATIVE CELL REFERENCE in GOOGLE SHEETSCreate a Sidebar With Links In ExcelBaseball Stats And Scorekeeping In Google SheetsHow To Track High Yield Dividend Stocks in Google SheetsHow To RANK DATA in Excel | One FormulaAge Calculator Tutorial In Microsoft ExcelREFERENCE CELLS With The Dollar Sign In GOOGLE SHEETSGoal Seek In Excel | With ExamplesBuild a Custom Budget Tracker (No Coding Required)Easy TIME ENTRY Tracker in GOOGLE SHEETSExcel Pivot Tables | Easy 6 Minute TutorialPie Charts In Excel Step By Step
Brian Turgeon (bmturgeon) |

ABSOLUTE and RELATIVE CELL REFERENCE in GOOGLE SHEETS

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER