You’ve probably already used the View tab at one time or another if you’ve been using Excel for even a short time. But, since our next two topics utilize this tab, this seemed like a good time to review the groups and commands available on this versatile tab.
Figure 5. View Tab
The View tab’s primary purpose is to assist you by providing different ways to view your worksheet data.
Figure 6. Workbook Views Group
The first group on the View tab is the Workbook Views group. This group provides a similar function to the View toolbar located in the lower-right corner of your screen by providing commands for switching between Normal, Page Layout and Page Break Preview.
The next group, Show/Hide, simply provides a set of check boxes for common screen elements such as gridlines and the formula bar. Simply check a box to enable an element and uncheck a box to hide a specific element from view.
Figure 7. Show/Hide Group
Figure 8. Zoom Group
The Zoom group provides quick commands for changing the zoom level of your current worksheet view. Just like the Workbook Views group, an additional zoom option can be found on the lower-right portion of your screen in the form of a slider bar.
Figure 9. Window Group
The Window group contains commands for splitting and hiding a worksheet as well as a command for switching between multiple open Excel windows.
Finally, the Macros group contains only one command, Macros. Here, you can view and record Excel macros.
Figure 10. Macros Group