From the course: Excel 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Freezing and unfreezing panes
From the course: Excel 2019 Essential Training
Freezing and unfreezing panes
- As you start to scroll down a worksheet, using either mouse or possibly arrow keys, you've got a scroll bar on the right hand side, you can point to a box and scroll this way, what's missing as we move down the list? The top row. On this worksheet, called Freezing, in our workbook, 08 - Worksheet Views, we'd like to freeze the top row. And as long as it's visible, we can click anywhere in the worksheet, and go to the View tab in the ribbon. Freeze Panes, Freeze Top Row. And you see the description, Keep the top row visible while scrolling through the rest of the worksheet. There's a subtle difference on the screen, the line separator between rows 1 and 2 is darker than the other ones. But more important, and I'll be using the mouse wheel here, simply rolling it, and moving down the screen, seeing these other rows, but always seeing that title on top. This has nothing to do with printing, but it certainly makes it easier to work with your data. Now, sometimes you say, "Well, I don't…
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.