What does $ do in Google Sheets
$ do in Google Sheets is a feature, function, or behavior you can use inside a spreadsheet. The short version: learn the definition, try it on a small range, then wire it into your real sheet. Use the glossary and formula links on this page when you want the deeper reference.
Steps
-
1
Read the plain-language idea above.
-
2
Try it on two or three sample cells.
-
3
Check related glossary/formula guides linked here.
-
4
Apply it to your real range once the result looks right.
Related tutorials
These videos might help you go deeper on this topic.
Google Sheet Basics - The Absolute Basics
Ultimate Checklist in Google Sheets
The First Thing I Do When Starting a Google Sheet
Embed a Number in a Website from a Google Sheet
Calculate ROAS in Google Sheets
Related blog posts
Written guides that go deeper on this question.
Breaking Down a Billion Dollar Google Sheet
Did you know there are 1.5 billion Google Sheets users and that billionaires also use Google Sheets? There's a bunch of billionaires in this sheet. Jeff Bezos, Elon Musk, and Yuri Milner.
Read post →Absolute Basics of Google Sheets
Learn from scratch: What are rows, columns, and cells in Google Sheets? Master basics, tips & tricks in 3 videos. Get started now!"
Read post →Learn to Code in Google Sheets, For Programmers | For Advanced Google Sheet Users
If you know how to code, you'll learn in this step-by-step tutorial how to code in Google Sheets.
Read post →Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
Google Sheets formulas
A formula is an instruction in a cell that calculates a result from other cells, ranges, or built-in functions. Every...
Open →Google Sheets formula syntax
Every formula starts with = followed by a function name and arguments in parentheses. Ranges use A1 notation, text si...
Open →Absolute reference ($)
Absolute references lock row, column, or both with dollar signs so a formula keeps pointing at the same cell when you...
Open →Related questions
What is a function in a spreadsheet
A function in a spreadsheet in Google Sheets is a feature, function, or behavior you can use inside a spreadsheet. The short version: learn the definition, try it on a small range, then wire it into your real sheet. Use the glossary and formula links on this page when you want the deeper reference.
Get the answer →What is a function in spreadsheet
A function in spreadsheet in Google Sheets is a feature, function, or behavior you can use inside a spreadsheet. The short version: learn the definition, try it on a small range, then wire it into your real sheet. Use the glossary and formula links on this page when you want the deeper reference.
Get the answer →What is a function on a spreadsheet
A function on a spreadsheet in Google Sheets is a feature, function, or behavior you can use inside a spreadsheet. The short version: learn the definition, try it on a small range, then wire it into your real sheet. Use the glossary and formula links on this page when you want the deeper reference.
Get the answer →What is a spreadsheet function
A spreadsheet function in Google Sheets is a feature, function, or behavior you can use inside a spreadsheet. The short version: learn the definition, try it on a small range, then wire it into your real sheet. Use the glossary and formula links on this page when you want the deeper reference.
Get the answer →What is function in spreadsheet
Function in spreadsheet in Google Sheets is a feature, function, or behavior you can use inside a spreadsheet. The short version: learn the definition, try it on a small range, then wire it into your real sheet. Use the glossary and formula links on this page when you want the deeper reference.
Get the answer →Need more than a quick answer?
600+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.
Need one fix
Watch a free tutorial for the step-by-step version of any answer.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.