Chat with us, powered by LiveChat

Google Sheets Lock Row

How to Freeze Rows and Columns in Google Sheets

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.
    How to freeze rows and columns in Google Sheets.

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.
    How to freeze rows and columns in Google Sheets.

The columns are unfrozen and will now scroll normally.

FREE Quick Reference

Click to Download