From the course: Learning Excel 2016
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Freezing panes
- In an Excel 2016 worksheet, you have over a million rows to work with and over 16,000 columns to work with. Now, if you start to add so much data that you can't see it all in one screen, there are some cool features to help you with getting things lined up. We can freeze rows and columns, also known as panes, and that's what we're going to do in this movie. With our Landon Hotels revenue sheet, RH_Revenues0205, if you're getting caught up. This can also be an issue when you zoom in. Let's go down to our zoom slider down below and click the Plus sign. I'm going to zoom in to over 140%. I'm going to go up to 150%, and you'll notice now we have a scroll bar here that allows us to scroll left to right, and when we go over to the right to see the last few columns we can no longer see the first column with our location, so when we look at these values, we can't really line them up with anything unless we've memorized that... Okay, there they are: London, Paris, San Francisco, Hong Kong…
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.