Join Sally Norred for an in-depth discussion in this video Freezing rows and columns, part of Google Sheets Essential Training.
Let us take a few minutes to talk about freezing rows or columns on a Google Sheets spreadsheet. If you have a large dataset, it can be useful to freeze rows or columns. This way, you can keep rows or columns visible while you're scrolling through the rest of the spreadsheet. This can be especially useful if you want to keep a row or a column header in one place as you scroll. First, let's talk about freezing rows in Google Sheets. I'll show you how, using the sunshine and location chart. It has a lot of rows, and I'd like the column headers to stay visible as I scroll down through the rows.
To freeze rows, start in the View menu. Point your mouse to Freeze rows. Select the number of rows that you'd like to freeze, starting from the top of the spreadsheet. Keep in mind that you can freeze up to ten rows on any particular sheet. In this sheet, I only need to keep the top three rows visible, so I'll freeze three rows. Once I've frozen the rows, I'll see a light gray line denoting the frozen rows. Now, when I scroll through the spreadsheet, those top three rows stay visible. To unfreeze those rows, I'll go back to the View menu and select No frozen rows. Now, when I scroll through the spreadsheet, those rows are no longer frozen.
It's a similar process for freezing columns. I'll show you on this solar panel chart. I'd like to keep the first column visible as I scroll through the other columns. To freeze columns, select View > Freeze columns, and select the number of columns that you'd like to freeze. I'll select Freeze 1 column. That light grey bar appears again to the right of column A. And now, when I scroll across the spreadsheet, my first column stays visible. To unfreeze columns, I'll select View > Freeze columns > No frozen columns. Consider freezing rows or columns before you present a spreadsheet, or before you send a spreadsheet to others for review.
Freezing row or column headers can make it easier to read and understand the spreadsheet data
- Navigating Google Sheets
- Creating, naming, and saving spreadsheets
- Importing files
- Converting other file formats such as Microsoft Excel to Google Sheets
- Editing cells
- Inserting, deleting, and moving rows and columns
- Adding hyperlinks and images
- Formatting data
- Using formulas and functions
- Sharing spreadsheets
- Using the Google Sheets mobile app
Skill Level Appropriate for all
Q: This course was updated on 04/17/2018. What changed?
A: We revised five videos to reflect the latest features and enhancements in Google Sheets.
1. Getting Started with Google Sheets
2. Creating Spreadsheets
3. Editing Spreadsheets
4. Viewing and Printing Spreadsheets
5. Formatting Spreadsheets
6. Working with Spreadsheet Data
7. Collaborating with Google Sheets
Commenting on a spreadsheet3m 26s
8. Using the Google Sheets Mobile App
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.