What is VIEW Tab in Microsoft Excel & It's Uses

In this article, we will learn What is VIEW Tab in Microsoft Excel & It's Uses.

View Tab

This bar provides different options for viewing the sheets in an Excel workbook. It also provides options for viewing different windows in Excel, for enlarging or reducing the size of the worksheet while it is being viewed, and what elements in the Excel window should be displayed. The commands for hiding and showing worksheets are on the Home Tab under (Format > Unhide).

The commands for hiding and showing workbooks (and windows) can be found on this tab.

Sheet View
Lets you create different views of the same worksheet when you are collaborating with others.

Only enabled in Excel online or on the Desktop when your workbook has been saved in OneDrive.

Options - Displays sheet view options.

Workbook Views
Normal - Displays the worksheet in the normal view. There is also a shortcut to this view in the bottom right corner of the status bar.
Page Break Preview - (Moved in 2013). Used for adjusting page breaks. There is also a shortcut to this view in the bottom right corner of the status bar.

Page Layout - Displays the worksheet as it will appear on a printed page.Displays a very useful horizontal and vertical ruler plus you can add/change headers and footers, check margins, row/column headings and scaling options. Not to be confused with Print Preview. There is also a shortcut to this view in the bottom right corner of the status bar.

Custom Views - Displays the "Custom Views" dialog box.

Full Screen - (Removed in 2013). Displays the workbook in full screen mode. Press Esc to return to the normal screen.

Ruler - Toggles the display of the horizontal and vertical rulers. This is only available when you are in the Page Layout view. You can change the units displayed from the (Excel Options, Advanced tab)(Display, Ruler Units). By default the ruler displays the default units that are specified in the control panel, regional settings. These units can be either inches, centimeters or millimeters.
Gridlines - Toggles the display of gridlines on the active worksheet. Provides a shortcut to (Excel Options, Advanced tab)(Display options for this worksheet, show gridlines).

Formula Bar - Toggles the display of the formula bar. Provides a shortcut to (Excel Options)(Advanced tab, Show formula bar).

Headings - Toggles the display of the heading rows. Provides a shortcut to (Excel Options)(Advanced tab, Show row and column headers).

Zoom - Displays the "Zoom" dialog box.
100% - Zoom the workbook to 100% of its normal size.

Zoom to Selection - Zoom the worksheet to display just the currently selected cells.

New Window - Creates a new window of your current workbook.
Arrange All - Tile all open windows side by side on the screen.

Freeze Panes - Drop-Down. The drop-down contains the commands: Freeze Panes, Freeze Top Row and Freeze First Column.

Split - Splits the window into multiple resizable panes which allow you to have multiple views of the same workbook.

Hide - Hides the current workbook or window.

Unhide - Displays the "Unhide" dialog box allowing you to unhide a workbook or window.

View Side by Side - View two workbooks side by side to allow you to compare their contents.

Synchronous Scrolling - Synchronize the scrolling of two windows so they scroll together. The View Side by Side option must be switched on for this command to be enabled.

Reset Window Position - Reset the window position of the two windows being compared so that they share the screen equally. The View Side by Side option must be switched on for this command to be enabled.

Save Workspace - (Removed in 2013). Displays the "Save Workspace" dialog box. This allows you to save the layout of all the workbooks that are currently open so this layout can be reopened at a later date.

Switch Windows - Drop-Down. The drop-down contains a list of all the workbooks/windows that are currently open.

Macros - Button with Drop-Down. The button is a shortcut to View Macros which displays the "Macro" dialog box displaying all the available macros. The drop-down contains the commands: View Macros, Record Macro and Use Relative References.

Hope this article about What is VIEW Tab in Microsoft Excel & Its use is explanatory. Find more articles on calculating values and related Excel formulas here. If you liked our blogs, share them with your friends on Facebook. And also you can follow us on Twitter and Facebook. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write to us at info@exceltip.com.

Useful Articles :

10+ Creative Advanced Excel Charts to Rock Your Dashboard : These creative charts can make you stand apart from the crowd. These charts can be used for different types of reports. Your dashboard will be more expressive than ever.

How to Save and Use an Excel Chart Template : It is important to save chart templates for repetitive charts to save time and energy. To save chart templates in excel follow these steps.

Best Charts in Excel and How To Use Them :  These are some of the best charts that Excel provides. You should know how to use these charts and how they are interpreted. The line, column and pie chart are some common and but effective charts that have been used since the inception of the charts in excel. But Excel has more charts to explore.

Excel Sparklines : The Tiny Charts in Cell : These small charts reside in the cells of Excel. They are new to excel and not much explored. There are three types of Excel Sparkline charts in Excel. These 3 have sub categories, let's explore them.

Change Chart Data as Per Selected Cell : To change data as we select different cells we use worksheet events of Excel VBA. We change the data source of the chart as we change the selection or the cell. Here's how you do it.

Popular Articles :

50 Excel Shortcuts to Increase Your Productivity : Get faster at your tasks in Excel. These shortcuts will help you increase your work efficiency in Excel.

How to use the VLOOKUP Function in Excel : This is one of the most used and popular functions of excel that is used to lookup a value from different ranges and sheets. 

How to use the IF Function in Excel : The IF statement in Excel checks the condition and returns a specific value if the condition is TRUE or returns another specific value if FALSE.

How to use the SUMIF Function in Excel : This is another dashboard essential function. This helps you sum up values on specific conditions.

How to use the COUNTIF Function in Excel : Count values with conditions using this amazing function. You don't need to filter your data to count specific values. Countif function is essential to prepare your dashboard.


Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.