Workbook Views in Excel 13

There are different ways to display our Workbook in Excel 13. We can used the predefined Views that Excel offers us, or we can even create our own Custom View with specific settings that suit us. Lets see the Workbook Views 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 Workbook Views, we notice that the Normal View is selected as we can see in the image below.

View - Workbook Views - Normal

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 Workbook Views we select the Page Break Preview as we can see in the image below.

Page Break Preview

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 Workbook Views we select the Page Layout View as we can see in the image below.

Page Layout

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.

Custom Views

In order to create a Custom View, from the area of the ribbon named Workbook Views we select the Custom View command. Once selected the Custom Views 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.

Custom Views - Add

Once we select the Add button, the Add View window appears where at the right of the area Name: we type in the name for the Custom View that we want. Under the area Include In View, we can activate or deactivate what we want to include in our Custom View. The commands that we can activate or deactivate are Print Settings and Hidden Rows, Columns And Filter Settings. Once finished we press the OK button and that’s it.

Add Views

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

Custom Views - Show

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

Workbook Views in Excel 13

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

Posted on July 28, 2014, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Workbook Views in Excel 13.

Comments are closed.