224k views
0 votes
When is it appropriate to use an absolute reference

User Teetrinker
by
3.5k points

2 Answers

5 votes

Absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant. An absolute reference is designated in a formula by the addition of a dollar sign. It can precede the column reference, the row reference, or both.

User Arghol
by
4.1k points
0 votes

when the information in a formula always relates to the same cell

User Tim Ryan
by
4.8k points