The easiest way to understand is to try it. In cell a1 type the number 1. In a2 type 2, in a3 type 3 Then in cell b1 type =A1 And in cell c1 type =
1 Then select both b1 and c1 and copy the cells. Then paste them into b2, c2 and b3, c3. Then click on cell b3 and c3. Do you see what the difference in the formula is? Answer from moldboy on reddit.com
1 Then select both b1 and c1 and copy the cells. Then paste them into b2, c2 and b3, c3. Then click on cell b3 and c3. Do you see what the difference in the formula is? Answer from moldboy on reddit.comReddit
reddit.com › r/excel › what is the difference between "a1" and "$a$1"?
r/excel on Reddit: What is the difference between "A1" and "$A$1"?
April 3, 2025 -
What difference is there when the row or column is surrpunded by dollars and when without? But I would like you to explain it if I were a 9yo(in a simple way)because on internet there are many expl. I don't understand
Top answer 1 of 49
189
The easiest way to understand is to try it. In cell a1 type the number 1. In a2 type 2, in a3 type 3 Then in cell b1 type =A1 And in cell c1 type =$A$1 Then select both b1 and c1 and copy the cells. Then paste them into b2, c2 and b3, c3. Then click on cell b3 and c3. Do you see what the difference in the formula is?
2 of 49
90
The $ will lock in cell A1 as the reference cell for any formula you use that would normally auto reference A2 in the second cell, A3 in the third, and so on. If the data in A1 is the data you want all corresponding output cells to reference in the formula, use that format.
Ablebits
ablebits.com › ablebits blog › excel › excel formulas › why use dollar $ in excel formula: relative & absolute cell reference
Why use dollar $ in Excel formula: relative & absolute cell reference
March 21, 2023 - For example, if you have 10 in cell A1 and you use an absolute cell reference ($A$1), the formula =$A$1+5 will always return 15, no matter what other cells that formula is copied to.
Videos
12:24
Excel - switch between relative, absolute, and mixed references ...
10:29
How to use Excel formula references - A1 vs. $A$1 vs $A1 vs A$1 ...
24:48
EXCEL tutorial 6: Formule e Riferimenti relativi / assoluti / misti ...
09:34
3-12: Understand Excel absolute ($A$1)and relative (A1) cell ...
Academy of Learning
academyoflearning.com › blog › how-to-create-an-absolute-reference-excel
Create an Absolute Reference in Excel - Guide | Academy of Learning Career College
The absolute cell reference in Excel works by locking a formula to a certain cell to keep the row and column constant. An Excel absolute reference adds a dollar symbol ($) before the column and row to keep the values intact. For instance, if A1 is the default cell reference, $A$1 is the absolute cell reference...
YouTube
youtube.com › watch
How to use Excel formula references - A1 vs. $A$1 vs $A1 vs A$1 explained - YouTube
Want to write better & smarter formulas? Then you must master the reference styles in Excel. There are 6 styles in Excel cell refs.1) Relative reference - A1...
Published August 21, 2025
YouTube
youtube.com › watch
Microsoft Excel - Absolute References $A$1 - YouTube
This lesson will cover how you can utilize $ symbols in your formulas to lock cell references when copying formulas within a spreadsheet or workbook.
Published December 1, 2015
MrExcel
mrexcel.com › forums › question forums › excel questions
Difference between $A$1 and A1 | MrExcel Message Board
May 15, 2007 - Relative references (no dollar signs) do ajust. The forms $A1 (or A$1) will give you absolute column, relative row references (or the reverse) Does that help? ... Gotcha, Thanks guys.
Microsoft
microsoft.com › home › making sense of dollar signs in excel
Making sense of dollar signs in Excel | Microsoft 365 Blog
June 11, 2025 - In an absolute reference, each part of the reference (the letter that refers to the row and the number that refers to the column) is preceded by a “$” – for example, $A$1 is an absolute reference to cell A1.
Excel Forum
excelforum.com › excel-formulas-and-functions › 502910-in-excel-what-do-the-dollar-signs-mean-in-a-1-a.html
In Excel, what do the dollar signs mean in $A$1 [SOLVED]
It means that the column and row references are locked. for example, if you typed =SUM(A1,A2) in cell A3, cell A3 would contain the sum of values in A1 and A2. If you then copied cell A3 and pasted into cell B3, excel would convert the formula to =SUM(B1,B2).
CK-12 Foundation
ck12.org › all subjects › cbse math › grouped data to find the mean › what does a $ mean in an excel formula?
Flexi answers - What does a $ mean in an Excel formula? | CK-12 Foundation
September 11, 2025 - In Excel, the @$\begin{align*}\end{align*}@$ symbol is used to create an absolute reference in a formula. Here’s what it means: A$1: Both the column (A) and the row (1) are fixed. If you copy the formula to another cell, it will always refer to cell A1. A$1: The row (1) is fixed, but the ...
Quora
quora.com › What-is-the-difference-between-A1-R1C1-and-A-1-notation-in-Microsoft-Excel-formulas
What is the difference between A1, R1C1, and $A$1 notation in Microsoft Excel formulas? - Quora
Answer: They all refer to the same cell. A1 is the basic cell reference, otherwise known as a Relative Reference. R1C1 references a cell by its Row and Column designation. It's and old style of referencing cells.
Super User
superuser.com › questions › 1582490 › what-does-a1-means-in-excel
worksheet function - What does ' '!$A$1 means in Excel? - Super User
September 2, 2020 - While looking for a dynamic tournament-schedule in Excel, I stumbled upon this formula: =IF(' '!$A$1=0;D7; ...) Usually, I use the "!"-Operator when referring to another worksheet. What...
Microsoft Community
techcommunity.microsoft.com › microsoft community hub › communities › products › microsoft 365 › excel
A$1 working as $A$1 instead of B$1, C$1, etc. | Microsoft Community Hub
June 4, 2013 - I tried using A$1 to keep the row the same, but then when I drag the formula down it acts as if I've put $A$1 and keeps the A1 reference throughout the whole column. Any ideas on what I'm doing wrong here? Here is an image of a simplified formula with the problems/what I am wanting to accomplish: excel · Formulas and Functions · Reply · OliverScheurich to Layton__ESep 28, 2023 · Layton__E · =INDEX(Sheet!$5:$5,,ROW(A7)) This works in my file if i correctly understand what you want to do.
Ablebits
ablebits.com › ablebits blog › excel › conditional formatting › excel cell references - relative & absolute references in conditional formatting rules
Excel cell references - relative & absolute references in conditional formatting rules
March 22, 2023 - In all Excel formulas, including conditional formatting rules, cell references can be of the following types: Absolute cell references (with the $ sign, e.g. $A$1) always remain constant, no matter where they are copied.
Top answer 1 of 2
8
The terminology is "absolute reference" vs. "relative reference" (and there's "mixed reference").
The dollar signs create an "absolute reference" and the row / column specified will remain fixed no matter where you move / copy+paste the cell. Example: $A$1 will stay $A$1 no matter where you move the cell.
Without it the address is a "relative reference" and is, more accurately, an offset from the current location. Moving the cell will adjust relative references accordingly. Example: A1 will become B4 if you move the cell containing the reference a column to the right and three rows down.
An address that only has one dollar sign (e.g. on just the row or just the column) is called a "mixed reference", since one of the row/column is absolute and the other is relative. Example: $A1 will become $A4 if you move the cell containing the reference a column to the right and three rows down. Likewise A$1 will become B$1.
More information can be found here.
2 of 2
4
Dragging the cell has different results when you apply the $ sign to a cell reference.
Consider the $ as a lock. In an ordinary case (A1), whenever you drag a cell, its references will be automatically adjusted to the created cells, relative to the position of the original cell.
An example. Suppose you are referring cell A1 from D2. If you drag the D2 cell to the E3 cell, E3 will now reference B2 (because the offset from the original cell is (1,1))
If you lock the row reference ($A1), when you drag the cell, the row reference will be preserved. In the aforementioned example, E3 will reference to A2. Locking the column reference (A$1) will make it so that the column reference is preserved. In the example, E3 now references to B1.
Referencing $A$1 "locks" the reference, as such that any cells created from dragging will not alter that specific reference based on the offset to the original cell.
Microsoft also has the following topics on the subject:
- About cell and range references
- Switch between relative, absolute, and mixed references
Iqaccountingsolutions
iqaccountingsolutions.com › iq accounting solutions › general tips › relative vs absolute cell references
RELATIVE VS ABSOLUTE CELL REFERENCES - IQ Accounting Solutions IQ Accounting Solutions
September 24, 2012 - $A1 would adjust the row number when copied but would still point to column A. And A$1 would keep the row number the same while adjusting the column reference. You can also highlight all or part of a formula and press F4 to change between relative and absolute references.
Spreadsheet Planet
spreadsheetplanet.com › home › what does $ (dollar sign) mean in excel formulas?
What does $ (dollar sign) mean in Excel Formulas?
July 1, 2024 - Below is a quick summary of what ... to change as the formula is copied · A$1 – Row 1 is fixed and will not change, but the column is allowed to change as the formula is copied....
Quora
quora.com › What-is-the-difference-between-the-formulas-A1-and-A-1-in-MS-Excel
What is the difference between the formulas '=A1' and '=$A$1' in MS Excel? - Quora
Answer (1 of 2): No difference - until you copy the cell to another location. Example: If cell C1 contains =A1 and you copy or move it to D1, then D1 will now contain =B1 (because it will remap to a cell that is the same distance (in rows and ...
Excel Functions
excelfunctions.net › excel-cell-references.html
Excel Cell References - Relative & Absolute
January 3, 2011 - A further example of mixed absolute and relative Excel cell references is shown in the example below. In this case, the reference =E$1 in cell A1, uses relative referencing for the column and absolute referencing for the row.
Exceljet
exceljet.net › toggle absolute and relative references
Excel Shortcut: Toggle absolute and relative references | Exceljet
A1 --> $A$1 --> A$1-- > $A1-- > A1 · This is much faster and easier than typing the $ character manually. To convert an existing formula, enter cell edit mode, place the cursor in or next to the reference you'd like to convert, then use the shortcut. Note: In earlier versions of Excel on the Mac, this shortcut is exclusively Command + T.