Freeze header rows or columns

Freeze header rows or columns in Google Sheets — with three ready prompts, from the immediate task to the lasting pattern.

3prompt heights
Open it in the interactive atlas →

3 ready prompts

Written for the moment this actually comes up.

Execute — do the immediate task

+
Header rows keep scrolling offscreen during reviews. Freeze the top two header rows and the…
Header rows keep scrolling offscreen during reviews. Freeze the top two header rows and the leftmost column of client IDs on the 'Client Ledger' sheet so reviewers always see labels and IDs when scrolling through transactions. Confirm that freeze is set for everyone who uses the sheet and that printing preserves the header rows.

Improve — make it easier to accept

+
Before I hand this to the teaching team, make the sheet easy to navigate. Freeze the first two rows…
Before I hand this to the teaching team, make the sheet easy to navigate. Freeze the first two rows and the client ID column, add a short note at the top explaining the freeze, and make sure the view works for laptop and phone screens. Flag any merged header cells that will break freezing or printing.

Decide — diagnose the stuck moment

+
I froze the top two rows and the client ID column on the Client Ledger, but teachers on mobile say…

I froze headers but some collaborators report they still lose column labels on mobile.

I froze the top two rows and the client ID column on the Client Ledger, but teachers on mobile say labels disappear when they scroll. I suspect their mobile view behaves differently or they have a different visible range. Explain the likely cause and the best fix so labels remain readable on both desktop and phone without forcing them to change device settings.

Next to this one

Other spreadsheet work people do in Google Sheets.

Every task here came from the work, not from a feature list — which is why the prompts name what you want done and never the button that does it. The tool changes; the work does not.
Copyright © LLOS.ai · 2026 — original pedagogy, voice, and design — all rights reserved.

The rest of the map

Same library, five ways in.