From the course: Excel 2016 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 2016 Essential Training
Freezing and unfreezing panes
- Like many lists in Excel, this list that we're seeing here is on a worksheet called Freezing in the Workbook 08 Worksheet Views, if we start to scroll downward using either arrow keys or the mouse, we lose sight of the top row. Titles are often in a single row up top, they can be in multiple rows in some cases, but the idea is as we move up and down we'd like to see row one all the time in this particular worksheet. Make sure it's visible, go to the Freeze Panes option, it's on the View tab and the ribbon. Freeze Panes, now we've got a choice called Freeze Top Row. The active cell doesn't have to be in the top row right now, but it has to be visible, the row that you'd like to freeze. Freeze Top Row. And now as we start to scroll downward, using either arrow keys or mouse wheel, or the scroll bar on the right hand side, we always see row one. This has no implications what-so-ever about printing, it's not related to that at all. It's just a visual change on the worksheet. If at a…
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.