Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams (2023 Update)
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11 (2023 Update)
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Data Analytics
        • Introduction to Analytics and Artificial Intelligence
        • Data Analytics in Excel
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > Workbook Views and Using the Zoom Feature in Microsoft Excel 2016

Workbook Views and Using the Zoom Feature in Microsoft Excel 2016

During this Microsoft Excel 2016 training tutorial video, you will learn about the different workbook views and how you can use them. We will also demontsrate zooming in/out and freezing panes.


Facebook


Linkedin


Twitter

Like what you see? Get our complete Microsoft Excel 2016 training courses for beginner, intermediate and advanced learners. Click here to learn more. >>

Video Transcript

In this section we’re going to look at Viewing in Excel 2016. You’ve already seen a few aspects of that but I’d like to fill out a bit more of the detail. And the first thing we’re going to do is to select the View Tab on the Ribbon.

Now the left most group on the View Tab is the Workbook Views Group and there are actually four options here: Normal, Page Break View, Page Layout View, and Custom Views. Now Custom Views are out of scope for this course so we’re only going to look at Normal, Page Break View and Page Layout View. I mentioned the three of these earlier on in the course and those three option correspond to the three buttons down towards the right hand end of the Status Bar. So you can actually use those buttons to switch between the three views.

Now in reality you can work in any one of the three views. There are a few restrictions and constraints and most of the time most people use Normal View but you may sometimes find it convenient to use the other two.

Page Break View is very often used to preview printing. So let’s suppose you wanted to print out this list of the top 50 movies and you wanted to see how it was going to be on paper. And if you look at this particular example you can see the big Page 1 in the middle there. If you look towards the bottom of it you’ll see a blue dashed line which indicates a page break. And in fact that’s one of the reasons it’s called Page Break View. You can see where the page breaks would occur if you just printed this worksheet now with the current printer settings.

Now as far as printer settings are concerned we’re going to look at those in the next section. And the page breaks when you are printing a worksheet from a workbook will depend not only on how much data you’ve got on the sheet of course but things like the font size in use and the size of the paper you’re printing on to the orientation of the paper. Are you using landscape or portrait orientation, for example? So there are many factors that come into the determination of where pages break. And the issue of page break is one of the ones we’re going to be looking at particularly in the next section.

The third option, Page Layout View, gives you some very straightforward facilities for adding headers to pages and for adjusting margins and so on. So you can use that if you like to fine tune how the pages are going to look when you print them.

Want More? Get Started With a Free Excel 2016 Course! Click Here

Now we’re going to cover those printing options and the many aspects of Page Layout View in the next section as well.

So for the moment let’s go back into Normal View and let’s take a look at the Zoom functionality.

Now I demonstrated to you a couple of times earlier on. You have the Zoom Slider down there in the bottom right hand end of the Status Bar and you have a number of ways of using the Zoom Slider. You can either click and hold the slider, slide it backwards and forwards to adjust the view or you can use the minus button there which effectively zooms out, plus button to zoom in or you can just click on that number there, the zoom level. Now if you click on that you get this little Zoom Dialogue. And the Zoom Dialogue lets you zoom to a specific magnification, 100%, 200%, etcetera. Then you click on OK and you’ll see your worksheets at that particular magnification. And then you have options there for those fixed sizes or in fact you can click in this box and type in a custom magnification.

There is another option on there, that’s Fit Selection. Let me just cancel here for the moment. I’m just going to zoom out. Let’s suppose that I selected the title and say the first 25 movies, made a selection, and now what I do is say Fit Selection, click on OK and it will zoom to the selection I made, the top 25 movies.

The corresponding controls on the Ribbon there for that are in the Zoom Group. So you’ve got a Zoom button, you’ve got a 100% button which will zoom the document to 100% and you’ve got a Zoom to Selection button as well.

Now of course if you’re using a touch device of course apart from those controls you can use pinch and stretch to achieve zoom. So let me just pinch this particular sheet now and of course I can stretch it out as well.

And then one other thing I’d like to show you here is Freezing Panes.

Now it’s not immediately apparent from this straightforward list of movies but you can get problems where you have many columns of data and perhaps quite structured rows and columns that as you scroll up and down and across a sheet you can lose header information. Let me give you an example here.

Here we just have two columns, title and year of release. And if I scroll down as I get to the movies further down the list you see that I’ve lost the header. Now in this case it’s not very difficult because it’s pretty obvious that column A is a title, column B is probably a year of release. But if you had other information such as, for example, director and photographer you may not know which column was the director and which column was the photographer and maybe which column showed the person in charge of special effects and so on.

Now what you can do is that you can Freeze rows and columns of your worksheets to make it easier for people to understand the data. And let’s suppose that I wanted to Freeze, in this case just the top row. In the Window Group on the View Tab there is a Freeze Panes button with a dropdown. And I’m going to choose first of all Freeze Top Row and you should just about have seen a little line appear at the bottom of the top row. The top row is now frozen. Watch what happens as I scroll now. You see that the title remains in place.

Now you should also be able to see that if I had many other columns of information, such as director, location of filming, photographer, producer, and so on that would soon go off the right hand end and as I scroll left and right across the sheet I would lose the name of the movie. Well supposing I wanted to keep the top row with the headings and the name of the movie. So I want to keep the top row and the left most column. Let me first of all stop freezing the top row. So I’m going to click on Unfreeze Panes there. And then I click in the cell that is below the rows that I want to freeze and to the right of the columns I want to freeze. So I want to freeze just the top row so I’m going to click below the top row. And I want to freeze just the left hand column. So I click to the right of the left hand column which means I’m going to click in cell B2. So that’s below the top row and to the right of the left most column. Now I go back to Freeze Panes and click on Freeze Panes. It’s now frozen row 1 and column A. And as I scroll about, move about within the sheet, you’ll see that they stay frozen.

Want More? Get Started With a Free Excel 2016 Course! Click Here

So that gives me the facility to keep headings and other identifiers in view. Whenever I’ve had something frozen I can unfreeze it with an Unfreeze Panes there from the menu. And also there’s an option there to just freeze the first column. So I’m going to Unfreeze Panes on this worksheet and that’s freezing panes.

That’s the end of this section. I’ll see you in the next one.

Alprazolam pharmacy
Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

START LEARNING Workbook Views and Using the Zoom Feature in Microsoft Excel 2016 ON SIMONSEZIT.COM

START MY MEMBERSHIP

Similar Posts

How to Create Charts and Graphs Using Excel 2010

ClickUp Templates – A Complete Overview for Newbies [2022]

How to Add Slide Numbers in PowerPoint the Easy Way? 

Create an Invoice from an Estimate for Completed Job in QuickBooks Pro 2017

Identifying the Components of the QuickBooks 2019 Environment

How to Create a Database in Microsoft Access 2013

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)