Understanding the View tab

Views Tab holds access to certain regularly used routines & shortcuts. The most common of which has to be freeze panes. Following is a brief description of all the major command groups:

Views Ribbon menu

Workbook Views: You can switch to Normal (default & the usually used view), Page Layout (where you can set margins, Header/footers for individual pages, useful when the excel is being made for eventual printing purpose), Page Break Preview (Allows the user to adjust page breaks by clicking & dragging them using your mouse)

 

 Show/Hide:

You can hide Headings(the Column numbers A, B, C, D...), Formula Bar, Ruler(applicable in Page Layout/Page break view) lines that are used for print page settings, and Gridlines(the default light color lines on all rows/columns). These default gridlines don’t come on prints and for graphics heavy excel files (charts etc) it could be a good idea at times to de-select gridlines.

Zoom:

There are 3 commands visible here, first & the most useful one is Zoom, clicking on which opens a pop-up that allows you to choose the magnification value. By default we see excel at 100% magnification.

Zoom slider is also by default found in status bar (Bottom Right corner)

The second command resets the magnification to 100%. The last one provides maximum Zoom around the current selection of cells (up to 400%)  

Freeze Panes: Allows the user to fix a certain part of excel file as always visible while the sheet is scrolled down/right. This is likely to be used quite frequently & hence we cover this in detail in our next tutorial.

Split: Split command can be used to create panes (2 or 4) that have identical copies of the workbook.

View Side by Side: Can be used to see 2 different excel files side by side. This could be very useful when matching the two files to see the differences etc.

Save Workspace: Saves the information about all the opened excel files as a workspace. When you open the workspace again, it will open all your excel files opened at the time of saving the workspace. This could be a time saver if your job requires you to work with a fixed set of files every day.

Macros: To view & record Macros

We cover Splits, Side by Side Viewing/Workspaces & Macros in later sections.

 

Section: