- You can freeze columns in Google Sheets in a few quick steps on a computer or mobile device.
- Similarly, it is very simple to unfreeze columns in Google Sheets as well.
- Visit Business Insider's homepage for more stories.
You can freeze columns in Google Sheets to make it easier to scroll through content in the rest of the document.
Freezing or unfreezing a column in Google Sheets is a quick process on your Mac or PC or the Google Sheets mobile app for iPhone or Android. Here's how to do it.
Check out the products mentioned in this article:
iPhone 11 (From $699.99 at Best Buy)
Samsung Galaxy S10 (From $899.99 at Best Buy)
Macbook Pro (From $1,299 at Best Buy)
Microsoft Surface Pro 7 (From $999 at Best Buy)
How to freeze columns in Google Sheets on a computer
1. Open the Google Sheet you want to edit.
2. Select the column(s) you want to freeze.
3. Click the View menu, then select Freeze. Choose the number of columns you want to freeze (i.e. 1 column, 2 columns, or a range of columns).
To unfreeze columns, repeat these steps and choose No Columns instead of Freeze.
How to freeze a column in Google Sheets on a mobile device
1. Open the Google Sheets app and choose the spreadsheet you want to edit.
2. If you have an iPhone, simply select the column you want to freeze and tap the letter of the column. On the menu that appears, tap the Freeze column option.
3. For Android users, tap and hold the column you want to freeze. Tap again on the three vertical dots icon on the menu that appears then select Freeze.
To unfreeze columns, repeat these steps and choose Unfreeze instead of Freeze.
Originally $749.99Save 23%
Apple Macbook Pro 13-Inch Display with Touch Bar
An icon in the shape of a lightning bolt. Great Price
The Microsoft Surface Pro 7 is sleek and portable with excellent performance for on-the-go use — making it still the most premium 2-in-1 tablet available. Right now, it's on sale for $750, or $50 less than usual.
Originally $1,029.99Save 27%
Related coverage from How To Do Everything: Tech:
How to make a bar graph on Google Sheets in 5 simple steps, to make your spreadsheet data more digestible
How to set a print area in Google Sheets, so you can print selected cells or sheets
How to merge cells in Google Sheets on desktop or mobile, to combine multiple cells into one larger cell
How to add a drop-down list in Google Sheets to group and organize data in your spreadsheet
How to draw in Google Docs using the built-in 'Drawing' tool, to add customized drawings to your documents
Insider Inc. receives a commission when you buy through our links.
Two crossed lines that form an 'X'. It indicates a way to close an interaction, or dismiss a notification.