To create an absolute reference, insert a pound sign (#) before the column reference and another pound sign before the row reference.

Name: To create an absolute reference, insert a pound sign (#) before the column reference and another pound sign before the row reference.
Brand: Quizplus
Rating: 4.9 (34 reviews)

Question

Quizplus · Accepted Answer

To create an absolute reference in Excel, you insert a dollar sign ($) before the column reference and another dollar sign before the row reference (e.g., $A$1).

To Create an Absolute Reference, Insert a Pound Sign (#)