How to Freeze Cells on a Google Spreadsheet
Launch your browser., Log in., Open a spreadsheet file., Access the View menu., Point your mouse over the option you want., Select the number of columns or rows to freeze.
Step-by-Step Guide
-
Step 1: Launch your browser.
To get started, open your preferred web browser (Internet Explorer, Mozilla Firefox, Google Chrome, etc.) by tapping on its icon on your desktop, and go to drive.google.com. -
Step 2: Log in.
If you are not already logged in, Google Drive will ask you to sign in with your Google account information.
If your account name is already indicated on the page, just enter your password; otherwise, type in your username and password on the fields provided. , You can either open an existing file or create a new one.
The spreadsheet file will open on a new tab of your browser.
If you have an existing spreadsheet file, locate and click on the file name in the file list at the middle of the screen.
If you are going to create a file, click the “Create” button on the top-left corner and click on “Spreadsheet.” , Click “View” at menu bar of the spreadsheet to bring down the View menu. , You can either freeze rows or freeze columns; whichever option you point to, a small window will pop up on the side of the View menu.
If you want to freeze the cells at the top of the spreadsheet, point your mouse to “Freeze rows.” If you want to freeze the cells vertically, point to “Freeze columns.” , You can freeze up to 10 rows and 5 columns.
Simply click on the number rows or columns you would like to freeze. -
Step 3: Open a spreadsheet file.
-
Step 4: Access the View menu.
-
Step 5: Point your mouse over the option you want.
-
Step 6: Select the number of columns or rows to freeze.
Detailed Guide
To get started, open your preferred web browser (Internet Explorer, Mozilla Firefox, Google Chrome, etc.) by tapping on its icon on your desktop, and go to drive.google.com.
If you are not already logged in, Google Drive will ask you to sign in with your Google account information.
If your account name is already indicated on the page, just enter your password; otherwise, type in your username and password on the fields provided. , You can either open an existing file or create a new one.
The spreadsheet file will open on a new tab of your browser.
If you have an existing spreadsheet file, locate and click on the file name in the file list at the middle of the screen.
If you are going to create a file, click the “Create” button on the top-left corner and click on “Spreadsheet.” , Click “View” at menu bar of the spreadsheet to bring down the View menu. , You can either freeze rows or freeze columns; whichever option you point to, a small window will pop up on the side of the View menu.
If you want to freeze the cells at the top of the spreadsheet, point your mouse to “Freeze rows.” If you want to freeze the cells vertically, point to “Freeze columns.” , You can freeze up to 10 rows and 5 columns.
Simply click on the number rows or columns you would like to freeze.
About the Author
Catherine Roberts
Brings years of experience writing about pet care and related subjects.
Rate This Guide
How helpful was this guide? Click to rate: