How to Freeze Cells in Google Sheets (on Android, iPhone or a PC)

-

|

This Itechguide teaches you how to freeze cells in Google Sheets. The guide offers steps to freeze cells in Google Sheets on Android, iPhone Apps or a PC/Mac.

1
How to Freeze Cells in Google Sheets from a PC/Mac

Advertisements


  • Open Sheets.Google.com from your PC or Mac. Then open the Google Sheets document you want to freeze cells in.
  • You can open an existing document by clicking File -> Open. You could also open a document directly from Google Drive.
How to Freeze Cells in Google Sheets from a PC/Mac
  • When the document opens, click on the cell you want to freeze. Then click View, point to Freeze and select your Freeze option:
  1. For this example, I selected row A1 – row 1, column 1 – based on this, I have the option to freeze 1 row or 2 rows. I could also freeze Up to current row (1) – the reason I have (1) is because I selected cell A1.
  2. I could also freeze 1 column, 2 columns or Up to current column (A).

For this example, I will freeze 1 row and 1 column. This will freeze the sheet on the first row and the first column…

How to Freeze Cells in Google Sheets from a PC/Mac
  • One way to confirm that a row is frozen is the gray horizontal line running beneath the row. The same applies to a column.
  • To unfreeze a row or column, click View, point to Freeze and select either No rows or No column.

2
How to Freeze Cells in Google Sheets from Android App

How to Freeze Cells in Google Sheets from Android
  • Open Google Sheets App on your Android App.
How to Freeze Cells in Google Sheets from Android
Advertisements


  • Then open the document you want to free cells in. You can open the document from the Last opened by me section or from Google Drive. To access Google Drive click the folder icon on the top right of the App.
How to Freeze Cells in Google Sheets from Android
How to Freeze Cells in Google Sheets from Android
  • When the document opens, tap the column or row you want to freeze. Then tap it again to display a menu option. In this example, I want to freeze column A. So I will tap on A twice.
The tapping described above is NOT double-tap. Here is how you do it: you tap on the row or column. Then wait and tap again.
How to Freeze Cells in Google Sheets from Android
  • Then click the 3 dots top right of the displayed menu options.
  • When you click the 3 dots, another set of options will be displayed. To freeze the column in Google Sheets, tap Freeze.
  • To confirm that the column is frozen, a vertical bold gray line will be displayed just after the frozen column.

3
How to Freeze Cells in Google Sheets from iPhone App

Advertisements


  • Open the Google Sheets App on your iPhone.
How to Freeze Cells in Google Sheets from iPhone App
  • Then open the document you want to work on. You can open the document beneath Last opened by me group. You could also open a saved document from Google Drive. To access Google Drive, tap the folder icon on the top right of the Google Sheets App.
  • When the document opens, tap the column or row you want to freeze. Then tap it again to display a set of options.
  • In this example, I want to freeze row 1. I will tap the part of the cell with number 1. Then tap the row again to display the Cut, Copy, Clear options.
The tapping described above is NOT double-tap. Here is how you do it: you tap on the row or column. Then wait and tap again.
  • Then, to display the freeze option, tap the next arrow until Freeze row is available – see the second image below. To freeze the row, tap Freeze row.
If you were freezing a column Freeze column will be displayed in place of Freeze row.
  • The row will freeze – with a gray horizontal line running beneath it.
Advertisements


That is it! It is that easy to freeze cells in Google Sheets. Whether you want to freeze a column or row in the Android, iPhone App or a PC/Mac, I hope you found the steps in this Itechguide helpful.

If you found the guide helpful, kindly vote Yes below. You could also ask a question, leave a comment or a give a feedback using the “Leave a Reply” form below this page.

For more Google guides visit our Google How To page.

  • Was this post Helpful?
  • YesNo

LEAVE A REPLY

Please enter your comment!
Please enter your name here

FEATURED POSTS

How to Embed YouTube Video on Facebook

How to Embed YouTube Video on Facebook

This Itechguide teaches you how to embed YouTube video on Facebook. There are 2 high-level steps discussed in this guide:
How to Cancel Amazon Music Unlimited

How to Cancel Amazon Music Unlimited (PC or Amazon Apps)

This Itechguide teaches you how to cancel Amazon music unlimited. It offers steps to cancel Amazon music unlimited from a PC, Amazon...
How to Change Default Font in Google Docs

How to Change Default Font in Google Docs

This Itechguide teaches you how to change default font in Google Docs. Here are the high-level steps to change default font in...
How to Print Google Slides with Notes

How to Print Google Slides with Notes

This Itechguide teaches you how to print Google Slides with notes.
How to Add Bullet Points in Google Slides

How to Add Bullet Points in Google Slides (Android or iOS Apps or PC)

This Itechguide teaches you how to add bullet points in Google Slides. The guide offers steps to add bullet points in Google...

ADVERTISEMENTS

TRENDING POSTS

Remote Desktop Connection

Remote Desktop Connection an Internal Error Has Occurred [Fixed]

Introduction I recently received the error message "Remote Desktop Connection an Internal Error Has Occurred". It was strange because...

Find My Samsung: Register and Use Samsung Find my Mobile

Introduction Ever wondered how you could find your Samsung phone if you lost it? Find my Samsung or Samsung...
What is the Difference Between PowerShell and CMD?

Windows Powershell vs CMD: Differences and Similarities

Introduction This short guide compares Windows PowerShell vs CMD (Windows command prompt). I will cover the history and nature...
Spotify No Longer Supports this Version of Microsoft Edge

Spotify No Longer Supports this Version of Microsoft Edge [Fixed]

Introduction When you open Spotify web player on Microsoft Edge, you may receive the error message "Spotify No Longer...
Windows 10 Won't Boot

Windows 10 Won’t Boot With Black Screen? 3 Ways to Fix It

Why Won't Windows 10 Boot Up? If your Windows 10 stops with a black screen, the first question in...

BEST OF ITECHGUIDES

How to Install IIS in Windows 10 (3 Methods)

Introduction This guide demos 3 methods to install IIS in Windows 10. IIS (Internet Information Services) is a Windows...
How to Fix Black Screen in Windows 10

How to Fix Black Screen in Windows 10 (4 Methods)

Introduction This guide offers 4 options to fix black screen in Windows 10 after login. A number of users...
bad pool header blue screen error

How to Fix Bad Pool Header Blue Screen Error in Windows 10

Introduction Bad Pool Header error is related to memory allocation issue in Windows 10. Bad Pool Header error usually...
WSCRIPT and CSCRIPT Commands: Syntax, Parameters, Examples

WSCRIPT and CSCRIPT Commands: Syntax, Parameters, Examples

Introduction WSCRIPT is the Windows-based version of Windows Script Host while CSCRIPT is the command-prompt-based version. This guide...
Check Disk (CHKDSK) Windows 10

Check Disk (CHKDSK) in Windows 10: Syntax, Parameters, Examples

Introduction Check Disk (CHKDSK) is a Windows 10 command tool that checks a disk for errors, fixes errors, recovers...

ADVERTISEMENTS

RECENT POSTS

How to Embed YouTube Video on Facebook

How to Embed YouTube Video on Facebook

This Itechguide teaches you how to embed YouTube video on Facebook. There are 2 high-level steps discussed in this guide:
How to Cancel Amazon Music Unlimited

How to Cancel Amazon Music Unlimited (PC or Amazon Apps)

This Itechguide teaches you how to cancel Amazon music unlimited. It offers steps to cancel Amazon music unlimited from a PC, Amazon...
How to Add to outline in google docs

How to Add to Outline in Google Docs

This Itechguide teaches you how to add to outline in Google Docs. The guide offers steps to add to outline in Google...
How to Go Frame by Frame in YouTube

How to Go Frame by Frame in YouTube

This Itechguide teaches you how to go frame by frame in YouTube. YouTube does not have an inbuilt tool that allows you...
How to Change Default Font in Google Docs

How to Change Default Font in Google Docs

This Itechguide teaches you how to change default font in Google Docs. Here are the high-level steps to change default font in...

MUST READ

How to Share a Folder in Windows 10 (3 Methods)

Introduction This guide demos how to share folder in windows 10. It covers 3 methods. Options...
How to Change Time Zone in Windows 10 (4 Methods)

How to Change Time Zone in Windows 10 (4 Methods)

Introduction This guide demos how to change time zone in Windows 10. Options to Change Time...
How to Activate Google Voice for G Suite Users

How to Activate Google Voice – Guide for G Suite Users

Introduction This guide demos how to activate Google Voice. The steps in this guide can...
How to Take Ownership of Folder in Windows 10

How to Take Ownership of Folder in Windows 10 (2 Methods)

Introduction This guide demos 2 methods to take ownership of folder in Windows 10. Options to...

Routing and Remote Access in Windows Server 2016 (Part 4): Configure Web Application proxy

Introduction This is part 4 of a 4-part "Routing and Remote Access" series. This part covers how to configure...

LATEST DEALS

Exclusive Student Offer_Save 10% on selected Surface devices

By using this website you agree to accept our Privacy Policy and Terms & Conditions