Absolute References — Excel Course

Use $A$1 to lock both row and column when a formula is copied. Learn it step by step with guided practice on Excelquro.

Understand

Use $A$1 to lock both row and column when a formula is copied.

Worked example

Follow along

1. Use a fixed target cell in a copied calculation.

Interactive practice runs in your browser.