Google Sheets Roadmap
The lesson player with the free lesson Your first pivot table in the practice Google Sheets: a pivot table of revenue by region, the Pivot table editor beside it, and the lesson panel with the step "Click Add next to Values and choose Revenue" checked.
How a lesson looks on a computer.

Beginner · 7 min · 10 steps · checked as you go

Why your formula broke when you copied it

Lock a cell with $ so a formula keeps working when you copy it down.

Do this lesson on your computer.

It runs beside a practice Google Sheets in your browser, and every step is checked as you go. Free, with no sign-up.

On your computer, go tolearnford.com/go/39MP

The full Google Sheets course: 215 lessons, US$149.

Lifetime access, a practice Google Sheets in your browser, and new lessons as we add them.

See the Google Sheets course

In this lesson

  • A relative reference (F1) moves when you copy the formula.
  • An absolute reference ($F$1) stays on F1 wherever the formula lands.
  • F$1 locks only the row, $F1 only the column. $F$1 is always safe.
Google Sheets Roadmap

Not affiliated with Microsoft or Google.