Google Sheets Cell References Explained (Relative vs Absolute)

Struggling to understand cell references in Google Sheets? This beginner-friendly tutorial breaks down the difference between relative and absolute references so you can build smarter formulas and avoid common mistakes.📊 💻 You’ll learn how formulas behave when copied, why your calculations sometimes break, and how to “lock” cells using absolute references like $E$2. This is a must-know skill if you’re working with spreadsheets, budgeting, data analysis, or reporting. What you’ll learn: ✅What relative references are and how they work ✅How formulas automatically adjust when copied ✅What absolute references are and when to use them ✅How to fix formula errors using $ signs ✅Real examples using multiplication and tax calculations Perfect for beginners learning Google Sheets, Excel-style formulas, and practical spreadsheet skills.🔍 Timestamp 🕛 0:00 Introduction to cell references 0:03 Why cell references matter 0:06 Types: relative vs absolute 0:12 What are relative references 0:21 Example: multiplying cells (B4 × C4) 0:41 Copying formulas with fill handle 0:46 How references change (B5, B6…) 1:00 How relative positioning works 1:23 Why relative references are useful 1:42 When references shouldn’t change 1:48 Example: adding tax rate 2:16 Error when copying formula 2:30 Need for absolute references 2:38 What is an absolute reference ($) 2:56 Fixing formula with $E$2 3:06 Correct results after fixing 3:21 Final takeaway: choosing the right reference Visit https://www.learnfree.org/ to learn even more. We hope you enjoy!