This wikiHow teaches you how to freeze a column in a Google Sheets file on an Android phone or tablet.

Method 1
Method 1 of 2:
Freezing Any Column

  1. 1
    Open Google Sheets. The app has a green icon with a white table inside. You’ll usually find it in the app drawer.
  2. 2
    Tap the file you want to edit.
    Advertisement
  3. 3
    Tap the letter above the column you want to freeze. This highlights the column.
  4. 4
    Tap the letter above the column again. A menu will appear.
  5. 5
    Scroll down the menu and tap Freeze.
  6. 6
    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)

  1. 1
    Open Google Sheets. The app has a green icon with a white table inside. You’ll usually find it in the app drawer.
  2. 2
    Tap the file you want to edit.
  3. 3
    Tap the Sheet button. It’s near the bottom-left corner of the screen. A menu will expand.
  4. 4
    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.
  5. 5
    Tap anywhere on the sheet. This closes the menu at the bottom of the screen.
    Advertisement

About This Article

Nicole Levine, MFA
Written by:
Tech Specialist
This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 1,711 times.
How helpful is this?
Co-authors: 2
Updated: May 25, 2021
Views: 1,711
Categories: Google Applications
Article SummaryX

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?
Advertisement