From the course: Google Sheets Essential Training
Join today to access over 24,400 courses taught by industry experts.
Freezing rows and columns - Sheets Tutorial
From the course: Google Sheets Essential Training
Freezing rows and columns
- [Instructor] If you have a large dataset, it can be useful to freeze rows or columns on your spreadsheet. This way you can keep rows or columns visible while you scroll through the rest of the spreadsheet. First, let's talk about freezing rows. I'll show you how using this Sunshine & Location Chart. This sheet has a lot of rows, and I'd like the column headers to stay visible as I scroll down through the rows. I only need to keep the top three rows visible, so I'll freeze three rows. I'll select the third row since that's the last row I'd like to stay visible. Then I'll go up to the View menu, select Freeze, and Google Sheets gives me the option to freeze up to row 3 because that's the row I've selected. So I'll select Freeze, Up to row 3. In this sheet, 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 just go back to the View menu, select Freeze…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
