Table of Contents## Move Relative Formulas Without Changing References

Entire Site

**In Excel, a formula reference can be either
relative or absolute. Sometimes, however, you might want to reproduce
the same formulas somewhere else in your worksheet or workbook, or on
another sheet**.

When a formula needs to be made absolute,
type ** $** (a dollar sign) in front of the column
letter and/or row number of the cell reference, as in $A$1. Once you
do this, no matter where you copy your formula, it will reference the
same cells.

Sometimes, however, you might set up a lot of formulas that contain not absolute references, but relative references. You would usually do this so that when you copy the original cell formula down or across, the row and column references change accordingly.