Skip to main content
Back to homepage →

How do I make an absolute reference? - Knowledgebase / Calc XLS - Mariner Software

How do I make an absolute reference?

Authors list

How do I make a reference to a cell such that it stays unchanged when I do a fill down? I have for example a sales tax amount reference in my formula, and when I fill down the reference to my sales tax cell is incremented too - I want it to stay fixed!

What you are looking for is called an Absolute reference. 

To make an absolute reference you add a dollar sign on each vector of the address. 
So, for an absolute reference to cell A1 - you'd write $A$1
 
Here is an example:
123
34
45
56
 
lets write a function for cell D1
 
=$A$1+B1+C1
 
Now, we fill down column D and the next formulas will be (for D2,D3,D4):
 
=$A$1+B2+C2
=$A$1+B3+C3
=$A$1+B4+C4
 
So, you see, the absolute reference doesn't change while the other ones fill correctly.
Helpful Unhelpful

11 of 21 people found this page helpful