View Tab in Microsoft 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.


image 1


View tab contains 5 groups:-


image 2


a)    Workbook Views: -Excel offers 4 types of workbook views: – Normal, Page break preview, Page layout & Custom View. We use “Normal” option to see the normal view of Excel. We use Page break preview option to see that where the page-breaks appear when we print the document. Through “Page layout” option, we can check  from where does the page begin and end as well as to see any header / footer on the page. We use Custom View option to save the current display and setting as a custom view which we can apply in future.

image 3


b)    Show: – We use this option to show and hide the Excel’s view. Ruler is used to show the rulers next to our documents. Grid lines option is used to show the lines between rows and columns in the sheet to make the sheet easier to read. Through Formula bar, we can obtain the formula for the active cell. Heading is used to show the heading of columns and rows number.

image 4


c)    Zoom: -We can adjust the view as per our convenience. Zoom 100% is the standard view for viewing the Excel file. We use Zoom to selection to zoom the sheet so the selected range of cells fills the entire window.

image 5


d)    Window: -We use this option to access the window options. New window is used to open the same document in the new window, and we can perform in the both windows and thus both documents will get updated. Arrange all option helps us to stack the already opened window so that we can see all of them at once. Freeze Panes option is very useful for viewing vast data with the headers or we can use it to mark the comparison. Its usage always depends on requirement. Split option is used to divide the window into different panes such that each scrolls separately. Hide option is used to hide the current window.

image 6


e)    Macros: -With this option, we can record the macro and then we can view the macro.

image 7




If you liked our blogs, share it 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 us at

Users are saying about us...

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube