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.
If I scroll to the right to see the data in later years, I lose the list of names:
However, I can freeze the first column, so that it doesn’t scroll when the sheet does:
Now when I scroll, the list of names stays in its place:
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.