What number a formula using instructs Excel to keep both the row and column?

In Excel, to keep both the row and column constant when referencing a cell in a formula, you use absolute referencing by placing a dollar sign ($) before both the column letter and row number. For example, if you want to reference cell A1 absolutely, you would write it as $A$1. This ensures that when you copy or drag the formula to other cells, the reference to A1 remains fixed.