Get a FREE 2.4 hour Excel 2019 Beginners course here ►https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/

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 demonstrate zooming in/out and freezing panes.

Checkout some of our other training on YouTube:

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Excel 2016 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jUeMoLReqNzzuKj7rdLhZ2

Excel 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jVfCjoptJb_mimawnVezqh

Access 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gbtcZ9Z3kbhk-2v65bfGeX

Project 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i1QJ6-Z91KRjFg5dzacD1O

Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF

SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge

PowerPoint 2013 training for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gX0kiJc3k8d31y0zTLcECq

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)


Hello again and welcome back to our course on Excel 2016.
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.

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.


Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.