View Tab and its Usage in Excel

What is View Tab ? Where is it in Excel ?

      This is the last Tab after Review Tab in Excel. Every tab has its own importance in Excel ribbon in which View tab helps to change the view of Excel sheet and make it easy to view the data. Also, this tab is useful for preparing the workbook for printing.
It looks like image below.

View Tab in Excel

It has Five Groups.
1. Workbook Views
2. Show/Hide
3. Zoom
4. Window
5. Macros

1. Workbook Views :

 Excel offers 4 types of workbook views: – Normal, Page break preview, Page layout & Custom View. 

Normal - View the document in Normal view.

Page Layout - View the document as it will appear on the printed page. Use this view to see where pages begin and end, and to view any headers or footers on the page.

Page Break Preview - View a preview of where pages will break when this document is printed.

Custom Views - Save a set of display and print settings as a custom view. Once you have saved the current view, you can apply it to the document by selecting it from the list of available custom views.


Full Screen - View the document in full screen mode.

2.Show / Hide:

We use this option to show and hide the Excel’s view. Ruler is used to show the rulers next to our documents. 

Ruler - View the rulers used to measure and line up objects in the document.

Grid lines - Show, or hide, the lines between rows and columns in the sheet. Showing makes numbers in columns or rows easier to read or edit. Hiding Grid lines is useful if you are making a graphic organizer in Excel. These lines will not print unless the Print box is checked.

Message Bar - Open the Message Bar to complete any required actions on the document.

Formula Bar - View the formula bar in which you can enter text and formulas into cells.

 Headings - Show row and column headings. Row headings are the row numbers on the side of the sheet that range from 1 to 1,048,576. Column headings are the letters that appear above the columns on a sheet that range from A to XFD. This is also found on the Page Layout tab of an Excel Workbook.

3.Zoom:

-We can adjust the view as per our convenience.

Zoom - Open the Zoom dialog box to specify the zoom level of the document. In most cases, you can also use the zoom controls in the status bar at the bottom right portion of the window to quickly zoom the document.

100% - Zoom the document to 100% of the normal size.

Zoom to Selection - Zoom the worksheet so that the currently selected range of cells fills the entire window. This can help you to focus on a specific area of the worksheet.

4.Window :

We use this option to access the window options. 

New Window - Open a new window containing a view of the current document.

Arrange All - Tile all open program windows side-by-side on the screen.   

Freeze Panes - Keep a portion of the sheet visible while the rest of the sheet scrolls.   

Reset Window Position - Reset the window position of the documents being compared side-by-side so that they share the screen equally. To enable this feature, turn on View Side by Side.

Split - Split the window into multiple resizable panes containing views of your worksheet. You can use this feature to view multiple distant parts of your worksheet at once.

Save Workspace - Save the current layout of all windows as a workspace so that it can be restored later.

 Hide - Hide the current window so that it cannot be seen. To bring the window back, click the Unhide button.

Switch Windows - Switch to a different currently open window.

  

Unhide - Unhide and windows hidden by the Hide Windows feature.

View Side by Side - View two worksheets side-by-side so that you can compare their contents.

Synchronous Scrolling - Synchronize the scrolling of two documents so that they scroll together. To enable this feature, turn on View Side by Side.

5. Macros

With this option, we can record the macro and then we can view the macro.

 View the list of macros, from which you can run, create, or delete a macro. The keyboard shortcut for viewing macros is 

Alt + F8 .