Workbook Views in Excel 13
Posted by officesmart
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.
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.
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 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.
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 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.
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.
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.
Below you can check out the video describing the different Workbook Views in Excel 13.
About officesmartMVP: 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 Add View, Columns And Filter Settings, Custom View, Excel 13, Footers, Headers, Microsoft Office 13, MVP, Normal View, Office Smart, Page Break Preview, Page Layout, Print Settings, Smart Office, View, Workbook Views, Workbook Views in Excel 13. Bookmark the permalink. Comments Off on Workbook Views in Excel 13.
Comments are closed.