What happens if you copy a formula containing an absolute reference?

When you copy a formula that contains an absolute reference, the absolute reference remains unchanged in the new location. Absolute references are designated by the use of the dollar sign ($) before the column letter and/or row number (for example, $A$1). This means that when you move or copy the formula to another cell, the reference to the original cell will not shift based on the new cell’s position.

This behavior allows for consistent referencing of specific cells in your formulas, which is particularly useful when you want to perform calculations based on a fixed value or range across multiple cells. For example, if you have a formula that multiplies a value in a cell by a constant factor located in another cell, using an absolute reference for that constant will ensure that it always refers to that particular cell regardless of where the formula is copied.