From the course: Google Sheets Essential Training (2021)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Freezing rows and columns - Google Sheets Tutorial
From the course: Google Sheets Essential Training (2021)
Freezing rows and columns
- [Instructor] If you have a large data set, 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 the sunshine and location chart. You can download this file and follow along. It's titled freeze in the exercise files Chapter four folder. Now this sheet has a lot of rows and I'd like the column headers to stay visible as I scroll down through the rows. In fact, I want these first three rows to stay visible as I scroll. 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 and select Freeze. I want to select more than one or two rows, in fact, I want to select up to my current row, so I select Up to current row, 3. Once I've frozen the rows, I now see a light gray line denoting the frozen…
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.