When is it appropriate to use an absolute reference

Question

Dario Mendez

Computers & Technology

1 February, 16:53

When is it appropriate to use an absolute reference

+3

Answers (2)

Know the Answer?

Moriah Woods · Answer 1

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

Jakob Moody · Answer 2

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.