For large worksheets, you may wish to visually freeze a column—to lock it into place so that it stays on your screen even as you scroll. Freezing a column locks that column, and all columns to the left of it, on your screen when you scroll horizontally (left and right).
Freeze important columns, like task names in your project plan, candidates in your interview tracker, or ID numbers in your customer analytics worksheet. For instance, in the animation below we freeze our task name column (A) and it stays on our screen even as we scroll to the right.
How to Freeze and Unfreeze a Column
To freeze a column, select the desired column and either right-click on the column and select Freeze, or use the Freeze Column option in the menu bar: Views > Freeze > ... You can choose to freeze multiple columns by selecting multiple columns when you right-click and select Freeze, or by selecting 2 columns or Up to current column from the menu options.
Similarly, you can unfreeze a column by right-clicking on the frozen column and selecting Unfreeze column.
In the animation below, we first freeze one column (column A) and test this by scrolling right and left. Then we use the View > Freeze > 2 columns option to freeze both columns A and B. Finally, we unfreeze both columns.
Note: Because frozen columns can not be horizontally scrolled away, there is a limit to how far to the right you can freeze columns. To prevent users from accidentally freezing so many columns that users cannot scroll past the first few frozen columns, an error like the following may appear.
If you get this error, try moving the desired column to one of the early column positions (like column A or B) and then freezing just one of the first few columns.