top of page
Search

How to Freeze Rows or Columns in Google Sheets

  • Jan 22
  • 1 min read

It can be useful to pin your top row of data or first column of data, so that when you scroll, your data in those rows and columns will be frozen.


You can do this by freezing rows or columns in Google Sheets.


Step 1 - In your Google Sheet, select the 'View' menu and click the 'freeze' menu.


You can select which rows or columns you would like to freeze; it doesn't have to be just the first one.


Spreadsheet interface showing a menu with options like Freeze and No rows. Text includes CloudShed & Learning Space Social Tracker.

You can also do this by selecting a row, right-clicking to open the menu, clicking 'View more row actions' and selecting freeze.


Spreadsheet titled "CloudShed & Learning Space Social Tracker" with a Google Sheets menu open. Columns show apps and content instructions.

You can do the same by selecting a column and right-clicking.


Spreadsheet interface with a context menu open, showing options like cut, copy, paste, and insert columns. Blue and white color scheme.

If you would like to learn more about Google Sheets, book one of CloudShed's live sessions or purchase our on-demand courses.

bottom of page