Easy Steps on How to Freeze Columns in Google Sheets

Have you ever experienced scrolling through a column in Google Sheets and had to scroll back to double-check what that column’s title was? You are not alone. By freezing columns in your spreadsheet, the column titles will scroll with you!

By locking columns and rows in your Google Sheets spreadsheet, you no longer have to scroll all the way back just to remind yourself what you are looking at. By doing so, it will also make your spreadsheet look more professional and easier to view, especially if you have lots of data in it.

Freezing or unfreezing a column in Google Sheets is a quick and easy process on your computer or the Google Sheets mobile app on your phone or mobile device. We will instruct you on how to do it now.

How to freeze columns in Google Sheets on your computer

  • Open the Google Sheet you want to edit.
  • Select the column(s) you want to freeze by clicking on the topmost part of the column.

    How to freeze column in Google Sheet

    How to freeze column in Google Sheet

  • On the taskbar, click the View menu, and hover your mouse on Freeze. Another menu will pop up, then select the number of columns you want to freeze (i.e. 1 column, 2 columns, or up to the current column selected).

    How to freeze column in Google Sheet

    How to freeze column in Google Sheet

  • After selecting the column you want to freeze, you should see a thick line that separates the column you froze from the rest of the columns in your spreadsheet.

    How to freeze column in Google Sheet

    How to freeze column in Google Sheet

To undo these steps and unfreeze the column you selected, just repeat the steps and choose No Columns instead of Freeze.

How to freeze columns in Google Sheets on your mobile phone or device

  • Open the Google Sheets app and choose the file or spreadsheet you want to edit.
  • If you are using an iPhone or iPad, simply select the column you want to freeze and tap the letter of the column (topmost part). A menu should appear. Tap on the arrow to the right until you see the Freeze column. Tap on this option to freeze the column you selected.

    How to freeze column in Google Sheet

    How to freeze column in Google Sheet

  • If you are using an Android phone or tablet, tap and hold the column you want to freeze. Tap again on the more menu icon (three vertical dots) on the menu that appears. Scroll down and select Freeze.

    How to freeze column in Google Sheet

    How to freeze column in Google Sheet

  • To freeze multiple columns in Google Sheets, tap the blue circle that appears in the middle of the column you selected and then drag it until the column you want to freeze.

To unfreeze columns, repeat these steps and just choose the Unfreeze option instead of Freeze. You can also freeze rows in your spreadsheet. All you need is to just follow the same steps and select Freeze Rows instead of Freeze Columns.

Conclusion

The Freeze option in the Google Sheets View menu is a feature that lets you keep the selected columns or rows in place when you scroll through the spreadsheet. This is commonly used as the top row(s) and the leftmost column(s) often contain headings that should always remain visible. 

Was this article helpful? Please stay tuned for our next posts.

You may also like...