Mixed References — Excel Course

Use A$1 and $A1 when only the row or only the column should remain fixed. Learn it step by step with guided practice on Excelquro.

Understand

Use A$1 and $A1 when only the row or only the column should remain fixed.

Worked example

Follow along

1. Copy a formula across and down and identify which reference part stays fixed.

Interactive practice runs in your browser.