Freeze Rows and Columns in Google Sheets

Freezing rows and columns allows you to keep some of your cells in the same place as  the rest of your spreadsheet scrolls. This is especially useful if you have headings that you’d like to stay visible you scroll through a lot of data.

Take a look at the sheet in the first figure, showing data for various individuals over several years.

Click image to enlarge

Click image to enlarge

If I scroll to the right to see the data in later years, I lose the list of names:

Click image to enlarge

Click image to enlarge

However, I can freeze the first column, so that it doesn’t scroll when the sheet does:

Click image to enlarge

Click image to enlarge

Now when I scroll, the list of names stays in its place:

Click image to enlarge

Click image to enlarge

You can freeze up to ten rows or five columns in any single sheet.

To freeze your chosen rows or columns, first highlight them, then go to View > Freeze rows… (or View > Freeze columns…) and make your selection. Now when you scroll you’ll see that the frozen row(s) or column(s) stay in place.

You can unfreeze rows or columns, by going once again to View > Freeze rows… (or View > Freeze columns….) and selecting No frozen rows / No frozen columns. Your sheet will once again scroll as a unit.