From the course: Excel Essential Training (Microsoft 365)
Join today to access over 23,200 courses taught by industry experts.
Freezing and unfreezing panes
From the course: Excel Essential Training (Microsoft 365)
Freezing and unfreezing panes
- [Instructor] If you work with large lists in Excel, a problem is that when you start to scroll down, perhaps using the mouse wheel or the arrow keys, at different times you might be forgetting which column is which. What does it stand for? What's the heading? We're missing row one. We can easily freeze row one. Make sure it's visible. You can click anywhere on the screen. But make sure row one is visible. And then on the View tab up in the ribbon, you'll see a choice called Freeze Panes. Click it. Freeze Top Row. Slight subtle change on the screen. The separator between row one and two is a black line as opposed to the other separators, which are likely to be gray lines if you're showing grid lines. As I start to scroll now, look what happens. Row one stays in place, and that's really handy. You can leave it there indefinitely. It has nothing to do with printing. If you save the file, open it, this feature will…
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.