This wikiHow teaches you how to freeze a column in a Google Sheets file on an Android phone or tablet.
Steps
Method 1
Method 1 of 2:
Freezing Any Column
-
Open Google Sheets. The app has a green icon with a white table inside. You’ll usually find it in the app drawer.
-
Tap the file you want to edit.Advertisement
-
Tap the letter above the column you want to freeze. This highlights the column.
-
Tap the letter above the column again. A menu will appear.
-
Scroll down the menu and tap Freeze .
-
Tap the blue check mark. It’s at the top-left corner of the sheet. The column is now frozen in place.Advertisement
Method 2
Method 2 of 2:
Freezing the First Column(s)
-
Open Google Sheets. The app has a green icon with a white table inside. You’ll usually find it in the app drawer.
-
Tap the file you want to edit.
-
Tap the Sheet button. It’s near the bottom-left corner of the screen. A menu will expand.
-
Scroll down to “Freeze columns” and tap. Now you’ll see “1” beside “Freeze rows.” This means the first column in the sheet is now frozen.
- To freeze the first two columns, tapagain. Tapping again will freeze the first three columns, etc.
- To unhide one of the frozen columns, tap.
-
Tap anywhere on the sheet. This closes the menu at the bottom of the screen.Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
About this article
Article Summary
X
1. Open Sheets
.
2. Tap the file.
3. Tap the letter above the column.
4. Tap the letter about the column again.
5. Tap Freeze
.
6. Tap the check mark.
Did this summary help you?
Thanks to all authors for creating a page that has been read 1,943 times.
Advertisement
