In this post, we will see how to freeze panes and how to zoom in and out of data in excel.
Freezing Panes is especially important when you have really huge data. Like shown in the figure below, where the data size is large and you need to scroll down, in such case you are not able to see the headers as you scroll down.
Same is the problem with large number of columns.
Key to Freeze Panes
The shortcut to freeze panes is Alt+W+F+F for Excel 2007 and Alt+W+F for Excel 2000 and Excel 2003. What it exactly does is it takes top left corner of whichever cell you are currently in and freezes the panes then-and-there.
As shown in the above figure, the first row i.e. the row of titles is freezed so that even if there is huge data and you have to scroll down, still you will be able to see the titles and don’t have to scroll up every time to see them. Same is the case with columns.
Use Alt+W+F+F (Excel 2007) or Alt+W+F(Excel 2000 or Excel 2003) to unfreeze the frozen cells.
The Freeze Panes functionality is most commonly used to freeze the first row and/or first column. You will see why when we study models further.
If you are using Excel 2007, then you can use Alt+W+F+R to freeze the first row and Alt+W+F+Cto freeze the first column.
Even though this option is not present in Excel 2000 or 2003, there you can use Alt+W+F+Fto freeze row above your current cell and column to the left of your current cell.
So this was about freezing panes.
Now we will see how to use the zoom feature in excel.
Use Alt+V+Z to zoom the excel sheet.
As shown in the above figure, you can zoom using Alt+V+Z. It asks you the percent of zoom,which you can select using arrow keys.
Similarly you can zoom in as shown in the figure below using the same combination of keys.
Also, you can use the Fit Selection option of zoom to fit the selected data on one screen. This can be done using Alt+V+Z+F.
So this was all about how to Freeze panes and zooming feature in excel. These features are also used frequently in financial modeling.
Let me know if you have any queries regarding freeze panes and zoom in excel .