Freezing panes in Excel
Excel offers a few extremely helpful user interface features that make viewing our sheet easy: zooming and freezing panes. In this tutorial, we'll take a look at both of these features to get a feel for how they can help us navigate our sheets.
Zooming in and out
Our Excel sheets can contain quite a bit of data, and often it's helpful to be able to zoom in and out to either magnify data, or fit more data on the screen. Fortunately, Excel makes zooming easy: we can do it using the slider on the bottom-right of the screen:
We'll drag this slider to the right to zoom in:
And drag it to the left to zoom out:
If we want to set a specific zoom level, we can also click the current zoom level (by default,
When we're working with large sheets of data, it's easy to forget what pieces of data certain rows and columns represent. Check out the following screenshot, for example, in which we've scrolled around a large data set. We've got data on the screen, but we're not sure which column headings correspond to which columns:
To fix this problem, Excel has a handy feature called
Then, we'll head to the
Magically, the top rows and left columsn of our sheet are frozen in place when we scroll. Reading our chart is now much, much easier:
If we decide that we no longer want our panes frozen, we can select the
Save three hours of work a day with these 5 simple Excel hacks
Work smarter, not harder. Sign up for our 5-day mini-course to receive must-learn lessons on how to automate your work using Excel.
- Why the TRUE and FALSE functions are so important...
- Why to rethink the way you do VLOOKUPs...
- Plus, we'll reveal why you shouldn't use PivotTables and what to use instead...