Google Sheets Lock Row

When you're working in large spreadsheets, it can be hard to know what you're looking at once you scroll away from the row and column headings. But there's no need to sweat! Freezing cells solves the problem by keeping the headings in place while scrolling through other data.

Freeze a Row or Column

1. Click View on the menu bar.
2. Select Freeze.
3. Select 1 row or 1 column.
   

The selected row or column is frozen and will stay in place for context while other data scrolls.

Unfreeze Rows or Columns

1. Click View on the menu bar.
2. Select Freeze.
3. Select No rows or No columns.
   

The columns are unfrozen and will now scroll normally.