Using the $ Symbol in Google Sheets Formulas: A Beginner's Guide

23 Jan, 2023
Paresh @Boloforms
1 min read
Use AI to answer all your Excel & Google Sheets related queries. Try SheetGod for free now.
Try now!

Google Sheets formulas are a powerful tool for performing calculations and analyzing data. One of the many features that can be used in formulas is the $ symbol, which is used to make a cell reference absolute.

When you're creating a formula in Google Sheets, the cell references are typically relative by default. This means that when you copy or move the formula, the cell references will change based on the new location of the formula. However, if you want a cell reference to stay the same regardless of where the formula is located, you can make it absolute by adding a $ symbol before the letter and number that identify the cell.

For example, if you want to reference cell A1 in a formula, you would normally use the formula =A1. However, if you want to make the reference to cell A1 absolute, you would use the formula =$A$1. This means that even if you copy the formula to another cell, it will still reference cell A1.

You can also make only the row or column absolute by adding the $ symbol before the letter or number. For example, =A$1 will reference the cell on column A and the row will change but =$A1 will reference the cell on row 1 and the column will change.

It's important to note that when you use an absolute cell reference in a formula, it will always reference the same cell, regardless of where the formula is located. This can be useful in situations where you want to reference a specific cell or range of cells, even if the formula is copied or moved to a different location.

In conclusion, the $ symbol is a useful tool in Google Sheets formulas that can be used to make cell references absolute. By understanding how to use this feature, you'll be able to create more robust and flexible formulas that can be easily reused and modified.