Gaining Mastery of MS Excel View Tab

Learn MS Excel view tab. There are many menu bars in Microsoft Excel, one of which is the main menu bar, View Tab, which has many blocks. It is important to know about all these blocks because many important options have been given in it, which can be easily worked in Microsoft Excel after learning.

Therefore, if you also want to learn all the options of the menu bar one by one on a computer, then definitely read this article. As we know Microsoft Excel is a spreadsheet software in which data entry work is done. Now when we prepare the data, at that time we use different formats to view the data, for which the view menu bar is very important.

To understand each option in detail, it is most important to learn about its use, when you learn the use of each option, you will get complete information about it as well. Make Money Online.

MS Excel View Tab

The view tab menu bar is a major and important menu bar inside Excel, from which the data created in Excel can be viewed in different ways. When any data has to be printed, then for that it is set in print format. From this, it is seen that there is no data loss of any kind in the data that we are about to print.

Ms excel view tab

Apart from this, there are many important points like page break preview, custom view, full screen, etc.

Excel View the Tab Menu Bar Explained Below

  1. Workbook views
  2. Show/hide
  3. Zoom
  4. Window
  5. Macros

There are many major options inside all these blocks which are used for different types of work. So first of all learn all the options of all the blocks one by one below.

Ms excel view tab screen image

1. Workbook views


This is the option that appears in a normal state. When one opens Microsoft Excel, it is in a normal state. There is no need to use this option. When this option is used when using any other option, after that if the page is to be seen in normal condition then use this option.

Page layout

When any data is to be printed in the Microsoft Excel view tab, we see that data in the print layout view. By which we know that the page we are about to print is not getting any type of data wasted. It means that we have checked whether the document is ready to print and whether the printed document will be clearly visible or not.

Page break preview

when any document is prepared for printing. After that it is ensured that there is no text cut of any kind in whatever data is being printed, to adjust this use the page break preview option. By which you can adjust whatever page is breaking. 

Through this option, it is known how many pages will be printed in whatever document we are about to print. Where is one page breaking and then another page starting from there? And what is the text above whatever page is breaking? And what is the text below which can be seen through this option? And it can be adjusted according to your needs.

In Microsoft Excel, when data is prepared and its work is done, at that time nothing is known on the screen so that you can know which page is ending from where and where it is being cut. To know which, when we go to the page break preview, a line appears inside Excel from where the page is separating.

Custom views

Custom views If you want to set any data in a different view according to your custom view and want to see it in the same view whenever it is needed, then you can use the custom view option for that.

Once we have set display and print settings in custom views. It means that once we have saved the document on that particular view we need to display the document as a selected custom view.


Click on this option to view the Microsoft window on the full screen, after which the entire working area of ​​the Excel view tab will appear. Which means you can see the working area on the whole screen.

After clicking on this option, menu bar blocks, etc. get hidden. To view the Microsoft Excel window in the full-screen press the window key+ up arrow key. For normal view, press the window key down arrow key.

2. Show hide

So/Hide blocks, which are also used for different works, are known below.


Like in Microsoft Word, the ruler is used to set where to start the paragraph, where to end, where to start the paragraph from above, and where to end it at the bottom. In the same way in Excel if any object alignment has to be done left right up down it has to be set at the same place. So for that, you can use this option.


A normally visible cell in Microsoft Excel appears as a grid line. Which are arranged in the form of columns and rows. So that you can easily read the words written in the cell. And whatever work has to be done, it can be easily done in the form of rows and columns.

This means that gridlines are used to keep the cells represented in the form of rows and columns in an orderly form for easy reading or making any changes to them. It usually exists as a grid line by itself.

Message bar

If any security-related message or alert appears in the document from this option, tick this option.

Formula bar

If any formula has to be used in whatever data is created in the Excel view tab. Let’s turn on this option to see it on the screen. After which whatever formula we use appears on the screen.


Turn on this option to see the headings of the row and column. The headings option is used when a row or column is to be shown as a heading.

Excel appears as rows and columns. If any heading is to be given in the form of a row and column, then better to use the option for that.

3. Zoom


Zoom Excel documents in different sizes. If we want to see the Excel document in a custom size. Or use the zoom option to set the pre-defined size from Excel like 200% 100% 75% 50% 25%.

100% zoom

We can use this option to zoom in on 100% of Excel documents. This is the normal size of the Excel documents.

Zoom to selection

You can use this option to zoom any selected area in Microsoft Excel, which can reduce or enlarge any selected area in the View Tab.

4. Window

New window

In Excel, You can use this option to open the open workbook to compare more than one document simultaneously.

Arrange all

You can use this option to view different windows of Microsoft Excel simultaneously on the screen. In which many different windows will appear on the screen simultaneously. Arranging all is the option of weaving all windows together.

Freeze panes

Sometimes when we scroll large data, the heading above it gets hidden. But whatever data we see below, complete information about it is not available. Because the heading above is not visible. 

That’s why we freeze whatever heading or whatever column or row is there so that when we scroll the data, whatever our selected column remains visible. For that use the option.


This option can be used to split the Microsoft Excel window into multiple parts. When we split a window using this option, separate parts are created in it, due to which a window is divided into several parts.


This option is used to hide the current Microsoft Excel window. After using this option we cannot see anything on the screen of the MS Excel View Tab window.


When you hide an Excel window, then use the unhide option to see it again, so that our window becomes fully visible.

View side by side

Use this option to compare two worksheets simultaneously. Thereby, two different worksheets appear on the screen at the same time. Which can be easily compared.

For example, if I have two worksheets and want to compare them simultaneously on the screen, then by using this option, both options can be compared there.

Synchronous scrolling

Synchronous scrolling option, first of all, the side-by-side option has to be turned on, after that, we can scroll two documents simultaneously.

Reset window position

To use this option in MS Excel, first, we have to turn on the view Tab side-by-side option. Then we used this option for resetting the window position.

For example, when we set two windows together, after their position changes from here to there, we use reset window position to bring it back to the same position.

Save workspace

This option is used to save the current layout of all windows like a workspace. Because again we can restore as a later.

Switch window

When we work in one window, after that when we want to switch to another window, we can use this option for that. 

We can switch from one window to another, for example, as one window is currently open and at the same time another window is also open and if we want to go from one window to another, then we can go through this option.

5. Macros

Sometimes it happens that in Microsoft Excel, we have to do the same work by going to different cells, which takes a lot of time. But macros are such an option that by recording our work once, we can easily update it at all places in one click.

For example, I have to write Ram in every cell, now if we go and write them one by one, it will take a lot of time. But we can do the same thing in one go by recording macros. So that you will not have to go to every cell and write again and again.


MS Excel view tab. Information about all the options available in the view tab menu bar of Microsoft Excel has been given in this article, however, if you have any questions related to any option, then definitely ask in the comment box.

Leave a Comment