How to Freeze a Row on Google Sheets on Android

Last Updated: May 25, 2021

This wikiHow teaches you how to freeze a row in a spreadsheet using the Google Sheets app. Freezing a row is helpful when you want a certain row to act as a header in a column.

Steps

1
Open Sheets on your Android. It’s the green icon with a white spreadsheet outline. You’ll typically find it on the home screen or in the app drawer.
2
Tap +. It’s in the orange circle at the bottom-right corner of the screen.
3
Tap New spreadsheet. This opens a blank spreadsheet. The remaining steps will provide an example so you don’t have to test the freezing function on your live spreadsheet.
4
Type header into cells A1, B1, and C1. This is just data so you can test freezing the row. In our example, this is the row that will be frozen.
5
Type test into cells A2, B2, and C2.
6
Type test into cells A3, B3, and C3. Now you have enough sample data to freeze a row.
7
Tap the Sheet tab. It’s at the bottom of the screen. A menu will appear.
8
Scroll down to “Freeze Rows” and tap
. This tells Sheets to freeze the first row (the one that says “header” in the example). A line will now appear beneath this row, splitting it from the rows beneath.
- To freeze additional rows, tap
  again. If you increase the number to 2, the first 2 rows will be frozen.