Workbook Views in Excel 13

There are different ways to display our Workbook in Excel13. We can used the predefined Views that Excel offers us, or we can even create our own CustomView with specific settings that suit us. Lets see the WorkbookViews that we have available one by one.

Normal View

First, we must select the View tab and then from the left area of the ribbon named WorkbookViews, we notice that the NormalView is selected as we can see in the image below.

Page Break Preview: By using this view we can see where the page breaks will appear when we print our document.

In order to activate the view, from the area of the ribbon named WorkbookViews we select the PageBreakPreview as we can see in the image below.

Page Layout: By using this view, we will see how our printed document will look like. This is a good way to see where the pages begin and end and also to see the Headers and Footers that we might have in our document.

In order to activate the view, from the area of the ribbon named WorkbookViews we select the PageLayoutView as we can see in the image below.

Custom View: We can save our current display and print settings that we have applied to our document as a custom view, that we can quickly use and apply in the future to other documents.

In order to create a CustomView, from the area of the ribbon named WorkbookViews we select the CustomView command. Once selected the CustomViews window appears as shown in the image below. In this window, we press the Add button, which is located in the middle right corner as shown below.

Once we select the Add button, the AddView window appears where at the right of the area Name: we type in the name for the CustomViewthat we want. Under the area Include In View, we can activate or deactivate what we want to include in our CustomView. The commands that we can activate or deactivate are PrintSettings and HiddenRows, ColumnsAndFilterSettings. Once finished we press the OK button and that’s it.

Once we press the OK button, we return to the CustomViews window, where under the area Views we notice the name of our CustomView. At the right we can press the Show button to display our CustomView. We can also Close the view, Add another view or Delete the view.

Below you can check out the video describing the different Workbook Views in Excel 13.

Workbook Views in Excel 13

Related

About officesmart

MVP:
Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide.
Microsoft Master Specialist:
This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system