Choose your dojo

Master every interface, one skill at a time

Freeze Rows & Columns

What This Does

Freeze panes locks rows and/or columns so labels remain visible as you scroll through large datasets.

Why It's Useful

Losing column headers on row 500 causes misreads and errors. Freeze eliminates guesswork.

How to Do It

  1. View → Freeze → choose rows or columns
  2. Or drag the thick gray lines in the top-left corner
  3. Freeze top row for column headers
  4. Freeze first column for row labels

Try This Now

Freeze the top row and first column on a sample sheet.

Mental Hook: Headers stay, data scrolls.