How to Freeze and Unfreeze Rows or Columns in Google Sheets GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > Google Apps

How to Freeze and Unfreeze Rows or Columns in Google Sheets

Keep important info front and center as you work

By Scott Orgera Scott Orgera Writer Scott Orgera is a former Lifewire writer covering tech since 2007. He has 25+ years' experience as a programmer and QA leader, and holds several Microsoft certifications including MCSE, MCP+I, and MOUS. He is also A+ certified. lifewire's editorial guidelines Updated on November 21, 2021 Tweet Share Email Tweet Share Email Google Apps Sheets Docs Slides

What to Know

In a browser, select a row and then select View > Freeze. Select your desired option.On mobile, open the Sheets app and select a row or column. Open the context menu, select the three dots, and then choose Freeze. When working with a large spreadsheet, keeping specific rows or columns always in view can be helpful. Perhaps you want column headers to display as you scroll down the page, or maybe you'd like to compare two rows of data that are positioned far apart from each other. Here's how to freeze and unfreeze rows and columns in Google Sheets using a web browser and the mobile app.

Freeze a Row in the Sheets Web App

In this example, we'll freeze the first row to show how it works when you scroll away from the first row. Select the row you'd like to freeze. Click or tap the row number to the left of the row you want to freeze to select the entire row. To select an entire column, select the letter at the top of it. Select View > Freeze. From the options that are displayed, select the one that fits your needs. No rows: Unfreezes all rows. 1 row: Freezes the first row. 2 rows: Freezes the first two rows. Up to current row (x): Freezes all rows up to the one currently selected, represented by x. No columns: Unfreezes all columns. 1 column: Freezes the first column. 2 columns: Freezes the first two columns. Up to current row (x): Freezes all columns up to the one currently selected, represented by x. When you scroll horizontally or vertically, the column or row that you chose to freeze remains in view no matter where you are within the spreadsheet. To unfreeze a column or row at a later time, follow steps 1 and 2 again and select No rows or No columns.

Freezing a Column or Row on a Smartphone or Tablet

Follow these instructions to freeze columns and/or rows on Android and iOS (iPad, iPhone, iPod Touch) devices. The following steps were performed in Android version 8 but will be similar across devices. Launch the Google Sheets app. Open the spreadsheet you're working on (or create a new one). Select the row or column that you wish to freeze by tapping on it once so that it becomes highlighted. Tap the row number to the left of the row you want to freeze to select the entire row. To select an entire column, select the letter at the top of it. Tap the highlighted column again so that the context menu appears. Tap the three dots at the right to open the context menu. Select FREEZE. Now, when you scroll horizontally or vertically, the column or row that you chose to freeze remains in view no matter where you are in the spreadsheet. To unfreeze a column or row at a later time, follow steps 3 and 4 again and select UNFREEZE COLUMN or UNFREEZE ROW. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Hide and Unhide Columns, Rows, and Cells in Excel How to Add, Hide, Freeze, or Remove Columns in Sheets How to Freeze Column and Row Headings in Excel How to Highlight and Find Duplicates in Google Sheets How to Search in Google Sheets How to Use Google Sheets How to Limit Rows and Columns in an Excel Worksheet How to Sum Columns or Rows in Google Sheets How to Wrap Text in Google Sheets How to Hide or Unhide Rows in Google Sheets How to Remove Duplicates in Google Sheets How to Use the Concatenate Function in Google Sheets How to Make a Calendar In Excel How to Save a Google Spreadsheet to Desktop How to Put a Spreadsheet in Google Slides How to Use the Excel INDEX Function Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies