A cell address formatted as an absolute reference doesn't change when you copy and paste it to other parts of your worksheet, enabling you to easily apply it to the entire column.

Q: My partner says there’s an F4 shortcut to creating absolute cell references in Excel formulas, but for the life of me I can’t make it work.

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does.