How to Add a Dollar Sign in Google Sheets

Walter Jul 15, 2026

Ever needed to add a dollar sign in Google Sheets but found yourself stumped? You're not alone. Google Sheets provides a variety of functions to help you achieve complex calculations and formatting tasks. Today, we'll guide you through a straightforward process on how to add a dollar sign in Google Sheets. Let's dive in!

How to Write a Check
How to Write a Check

Before we start, understanding the purpose of a dollar sign in Sheets is crucial. The dollar sign, or dollar notation, is used to create absolute references in formulas. This means that the cell reference won't change when copied, making your formulas more consistent and efficient. Now, let's explore how to use it.

Simple Dollar Bill Template - Print and Go
Simple Dollar Bill Template - Print and Go

Using the Dollar Sign in Google Sheets

Adding a dollar sign in Google Sheets is a simple process. It's essentially a way of making your cell addresses absolute, which can be especially helpful when you're applying formulas to multiple cells.

dollar bills cut out to look like they are on the same page as each other
dollar bills cut out to look like they are on the same page as each other

The key to using the dollar sign is understanding where to place it. You place it before the column letter or the row number, or both, depending on whether you want to lock the column, the row, or both. Let's explore this in more detail.

Locking the Column

Printable Sign-up Sheet Templates
Printable Sign-up Sheet Templates

To lock the column, place the dollar sign before the column letter. This way, whenever you copy the formula, the column reference will remain constant. For instance, if you want to lock the 'A' column in cell A1, you would type $A.

Let's say you want to apply a formula to cells B1, C1, and D1. If your formula involves references to column A, using $A will ensure that the formula in those cells only looks at column A, no matter where you copy it. For example, the formula =$A1*2 would always multiply the value in column A by 2.

Locking the Row

a dollar sign is shown in black and white
a dollar sign is shown in black and white

Similarly, to lock the row, place the dollar sign before the row number. For example, if you want to lock row 1 in cell A1, you would type A$1. This way, whenever you copy the formula, the row reference will remain constant.

For instance, if you want to apply a formula to cells A2, A3, and A4, using A$1 would ensure that the formula in those cells only looks at row 1, no matter where you copy it. For example, the formula =A$1*2 would always double the value in row 1.

Using the Dollar Sign in Formulas

How to Nest Multiple IF Statements in Google Sheets
How to Nest Multiple IF Statements in Google Sheets

Now that we've discussed how to lock columns and rows, let's discuss how to use this in formulas. Sometimes, you'll want to lock both the column and the row. This can be achieved by placing the dollar sign before both the column letter and the row number. For instance, $A$1 would lock both the column and the row.

Here's an example. Suppose you have a list of numbers in column A, starting from A1, and you want to double each number. You could use the formula =$A1*2. When you copy this formula down, it will always take the value from the first row and multiply it by 2, no matter where you place it.

Money Tally Sheet | Templates at allbusinesstemplates.com
Money Tally Sheet | Templates at allbusinesstemplates.com
White Minimalist Sign Up Sheet Document
White Minimalist Sign Up Sheet Document
how to draw Dollar Sign in 3D💲$ Symbol Step By Bill Easy Cash Make Money Finance Revenue
how to draw Dollar Sign in 3D💲$ Symbol Step By Bill Easy Cash Make Money Finance Revenue
three bills with dollar signs on them, one in the middle and one in the bottom
three bills with dollar signs on them, one in the middle and one in the bottom
Free Printable Simple Table Style Sign In Sheet
Free Printable Simple Table Style Sign In Sheet
Sign In Sheet Template #1 - Tim's Printables
Sign In Sheet Template #1 - Tim's Printables
printable worksheet for kids to practice counting money
printable worksheet for kids to practice counting money
iuran kas bulanan kls 3a
iuran kas bulanan kls 3a
the instructions for how to make an origami bird
the instructions for how to make an origami bird

Using the Dollar Sign in SUMIFS

The SUMIFS function is another place where the dollar sign can be particularly useful. It allows you to add up cells that meet multiple criteria. You can lock the column or row you're summing by adding a dollar sign before the range.

For instance, the formula =SUMIFS($A$1:$A$10, A$1:A$10, ">&5") would sum up all the values in the range $A$1:$A$10 that are greater than 5 in A1:A10. This means no matter where you put this formula, it will always sum up the correct cells.

And there you have it! You now know how to use the dollar sign in Google Sheets. Whether you're locking columns, rows, or using it in formulas, the dollar sign is a powerful tool that can simplify your Sheets experience. Happy sheeting!