The first dollar sign ($a) locks the column. The second dollar sign ($15) locks the row. Useful when copying a formula with a static value both horizontally across columns and vertically across rows. Answer from Ebonystealth on reddit.com
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 - In this example, I've selected cell C4, and see that the cell reference in the formula is relative to row 4, exactly as it should be: An absolute reference in Excel is a cell address with the dollar sign ($) in the row or column coordinates, like ...
Microsoft Support
support.microsoft.com › en-us › office › switch-between-relative-absolute-and-mixed-references-dfec08cd-ae65-4f56-839e-5f0d8d0baca9
Switch between relative, absolute, and mixed references - Microsoft Support
If you want to maintain the original cell reference in this example when you copy it, you make the cell reference absolute by preceding the columns (B and C) and row (2) with a dollar sign ($). Then, when you copy the formula =$B$4*$C$4 from D4 to D5, the formula stays exactly the same.
Whats the difference between one and two dollar signs for absolute references?
u/SamB7334 - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
6
1
August 23, 2022There is a shortcut for $.
Pro tip. There is a short cut for everything there is no need to ever use a mouse. alt is your best friend. Learn all shortcuts and you’ll speed up and improve your work massively 👏 More on reddit.com
32
61
November 17, 2023Absolute and Relative Cells
Relative means the reference can change when copied. An absolute reference doesn't change and column and row references can be different within the same reference. Some examples follow: =A1 - This reference will update both A and 1 when copied. Copied to column B, the referece becomes =B1. If copied to column C it updates to C1. If you copy it to the second row, it updaes to =B1, and so on. =$A$1 -- This reference will not update even when copied. It will always refere to cell A1. =$A1 -- This reference will update the row but not the column. If copied to column B it remains =$A1. If copied to the second row it updates to $A2. =A$1 -- This reference will update the column reference but not the row. Copied to column B, it will update to B$1. If copied to row 2 in column A, it remains $A$1. Often, it won't matter; sometimes it's the only way to get the correct results. Try these siimple examples and then expand on the above until it makes sense. You will catch on quickly I'm sure. Susan H. More on reddit.com
11
1
June 24, 2022I am having trouble getting F4 to Absolute Reference on a Lenovo
Just Type the $ sign before what you want to be fixed. A1 << Relative reference $A1 << Fixed columns A$1 << Fixed Rows $A$1 << Absolute reference More on reddit.com
12
4
January 27, 2016Videos
00:40
Learn Absolute Value References in Microsoft Excel! - YouTube
03:43
How to Use the ABS Function in Excel for Absolute Values - YouTube
02:26
How to Use the ABSOLUTE VALUE (ABS) Function in Excel 2024 - YouTube
11:27
How to Get an Absolute Value in Excel - Two Examples of its Use ...
How to Get the Absolute Value in Excel in Under 2 Minutes ⏳
How to Use Absolute (ABS) Function in Excel? #exceltips #excelformula ...
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 Excel, a dollar sign can denote a currency format, but it has another common use: indicating absolute cell references in formulas. Let’s consider both uses of the dollar sign in Excel. Turn data into insights. ... If you want to display numbers as monetary values, you must format those numbers as currency.
GCFGlobal
edu.gcfglobal.org › en › excel-tips › absolute-references-with-the-f4-key › 1
Excel Tips: Absolute References with the F4 Key
You can change the cell reference to an absolute reference by adding dollar signs before the row and column (for example, $D$2). Although you can type the dollar signs manually, the F4 key on your keyboard allows you to add both dollar signs ...
Reddit
reddit.com › r/excel › whats the difference between one and two dollar signs for absolute references?
r/excel on Reddit: Whats the difference between one and two dollar signs for absolute references?
August 23, 2022 -
For example if you have $a15 and $a$15, is there a difference between the two?
Top answer 1 of 3
7
The first dollar sign ($a) locks the column. The second dollar sign ($15) locks the row. Useful when copying a formula with a static value both horizontally across columns and vertically across rows.
2 of 3
3
Using your example, $a15 is a reference to column A only, so if you copy a formula containing that in any other row (20) it will change the row number to that ($a20) whereas $a$15 is a reference to that cell only, it will not change.
Microsoft Support
support.microsoft.com › en-us › office › switch-between-relative-and-absolute-references-981f5871-7864-42cc-b3f0-41ffa10cc6fc
Switch between relative and absolute references - Microsoft Support
If you want to maintain the original cell reference when you copy it, you "lock" it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula =$A$2+$B$2 from C2 to D2, the formula stays exactly the same. This is an absolute reference.
W3Schools
w3schools.com › excel › excel_abs_ref.php
Excel Absolute References
Convert Time to Seconds Difference Between Times NPV (Net Present Value) Remove Duplicates · Excel Exercises Excel Syllabus Excel Study Plan Excel Certificate Excel Training ... Absolute reference is when a reference has the dollar sign ($).
Oreate AI
oreateai.com › blog › understanding-the-dollar-sign-in-excel-formulas-a-guide-to-absolute-references › 5c169e4173b22a67e76b97013f14215a
Understanding the Dollar Sign in Excel Formulas: A Guide to Absolute References - Oreate AI Blog
January 15, 2026 - When you see a formula like =A2*$C$2, what does that $ mean? The dollar sign indicates an absolute reference for cell C2. In simpler terms, it tells Excel to always refer back to this specific cell (C2), no matter where you copy or move your formula.
MyExcelOnline
myexcelonline.com › home › $ dollar sign in excel: absolute, relative, and mixed cell references
$ Dollar Sign in Excel: Absolute, Relative, and Mixed Cell References | MyExcelOnline
March 22, 2024 - Absolute cell references are when ... of where the formula goes. By placing a dollar sign ($) in front of the column and/or row reference, you can “lock” that specific part of the reference....
GoSkills
goskills.com › microsoft excel › resources
Absolute Reference Excel - A Beginner's Guide | GoSkills
April 9, 2021 - Without the dollar sign ($) in the formula, Excel naturally interprets the cell address as a relative reference, where the point of reference changes as the relative row and column coordinates move. The idea of an absolute cell reference is to hold a specific cell constant, so the value remains the same when being copied to other cells.
University of Waterloo
student.cs.uwaterloo.ca › ~cs100 › F21content › 04-09-absolute-reference.html
Excel: Absolute References
By carefully using the right dollar signs in the right places it will make our life a lot easier when we cut and paste (or we autofill) our cell contents in our Excel spreadsheets. To recap, a dollar sign means we're using absolute referencing. If you use two dollar signs then it says always ...
Microsoft Support
support.microsoft.com › en-us › office › abs-function-3420200f-5628-4e8c-99da-c99d7c87713c
ABS function - Microsoft Support
The absolute value of a number is the number without its sign. ... Number Required. The real number of which you want the absolute value. Copy the table below, and paste into cell A1 in Excel. You may need to select any cells that contain formulas and press F2 and then Enter to make the formulas ...
Jotform
jotform.com › home › microsoft excel tutorial › how to use absolute reference in excel
How to use absolute reference in Excel | The Jotform Blog
December 1, 2025 - Select a cell, and then type an arithmetic operator (=, −, /,*). Select another cell, and then press the F4 key to make the cell reference absolute. If you continue to press F4, Excel will cycle through the different reference types.
Simplilearn
simplilearn.com › home › resources › data science & business analytics › excel tutorial for beginners › how to create an absolute reference in excel?
How to Create an Absolute Reference in Excel?
July 31, 2025 - Learn what is an absolute reference in excel✔️, how to create an absolute cell reference, and how to use an absolute cell reference. Read on👍and learn!
Address 5851 Legacy Circle, 6th Floor, Plano, TX 75024 United States
Indeed
ca.indeed.com › career guide › career development › the excel dollar sign formula: cell referencing tips
The Excel Dollar Sign Formula: Cell Referencing Tips | Indeed.com Canada
August 17, 2024 - In absolute referencing, the $ character appears before the row digit and column letter, such as "$C$3". This is useful for replicating a formula without modifying the cell reference.
Quora
quora.com › What-does-a-dollar-sign-mean-in-an-Excel-formula
What does a dollar sign mean in an Excel formula? - Quora
Answer (1 of 21): The $ is used in a cell reference to create an absolute reference. An absolute reference is one that will not change when the formula is copied. There are many variations of absolute references: * $A$1 will always point to ...
ExcelTrick
exceltrick.com › home › what does dollar sign ($) mean in excel formulas?
What does Dollar Sign ($) mean in Excel Formulas?
March 25, 2024 - The dollar sign ($) in Excel, when attached to cell references, denotes an absolute reference.
Indiana University
ittrainingcontent.iu.edu › training › vlkup › files › pc › vlookup-absolute-references.html
Using absolute cell references in the VLOOKUP function: IU Only: Files: Spreadsheets: Using VLOOKUP to find data: All Training Topics: UITS IT Training Content Library: Indiana University
To make a reference absolute, place dollar signs ($) before the parts of the reference you want to remain the same.