Search

How to freeze rows in Sheets

Freezing a row in OfficeSuite Sheets means locking it in place so that it stays visible when you scroll down or across the worksheet. This can be useful if you want to keep the row headings or labels always in view.

 

How to freeze rows in Sheets for Windows
1. Select the row below the row(s) you want to freeze. For example, if you want to freeze the first row, select the second row. If you want to freeze the first two rows, select the third row.

2. Go to the View tab on the ribbon and click Freeze.


3. To unfreeze the rows, go back to the View tab and click Freeze Panes again. Then choose Unfreeze Panes from the menu.
4. You can also freeze columns or both rows and columns using the same method. Just select the column or cell to the right of the ones you want to freeze and choose Freeze Panes from the menu.

 

Freeze or unfreeze rows or columns in Sheets for Android

To pin data in the same place and see it when you swipe down, you can freeze rows or columns.

Freeze or unfreeze rows

  1. Select the row below the one you want to freeze. For example: 
    you want to freeze row 1. Then, select row 2. 

  2. On the View tab, swipe the toolbar to reveal more options.

  3. Tap Freeze or Unfreeze. 

Freeze column 

  1. Select the column to the right of the one you want to freeze. For example:
    you want to freeze column A, then select column B.  

  2. On the View tab, tap Freeze or Unfreeze. 

 

Freeze or unfreeze rows or columns in Sheets for iOS

To pin data in the same place and see it when you swipe down, you can freeze rows or columns.

Freeze or unfreeze rows

  1. Select the row below the one you want to freeze. For example: 
    you want to freeze row 1. Then, select row 2. 

  2. On the View tab, swipe the toolbar to reveal more options. 

  3. Toggle on or off the Freeze button to freeze to unfreeze the selection. 

Freeze or unfreeze columns

  1. Select the column to the right of the one you want to freeze. For example: 
    you want to freeze column A, then select column B.  

  2. On the View tab, toggle on or off the Freeze button to freeze to unfreeze the selection.