Shawn is now navigating quite comfortably around his Excel workbook, but when we have a really massive workbook like this, it still does present a lot of challenges. One thing that can help us are some of our view options. We'll start by looking at the bottom of the screen, on our status bar. We have a small tool called a zoom slider, and this allows us to quickly zoom in by clicking on the plus, zoom out by picking on the minus, or simply drag the zoom slider to get to exactly where we need it. To the left of the zoom slider are three view options. We are working in normal view, but to the right of that you will also see the page layout view. This gives us a good indication of how the Excel workbook sits on the page, and is useful when we come to print. To the right of that is the Page Break view, and this is very good for getting an overview of a launch worksheet. For the most part though, we will work in normal view. So, I'm going to click back on that. Coming up to our ribbon now, I'm going to click on the View tab. You will notice a lot of the tools we've just looked at like the page breaks views, and the zoom tools are also available on the ribbon tab. If I needed to quickly zoom in for example to 100 percent, I can just click on 100 percent. If you find that tool really useful, don't forget you can always add it to Quick Access toolbar. So, I'm going to right-click and add Quick Access toolbar. There are also several checkboxes which will allow you to turn off and on some view options. For example, if I'd like to hide my grid lines, I can untick Gridlines and they're gone. Usually, it's easier to work with them all. One tool which can be quite useful, is the split. This allows us to split our screen, so we can view different sections simultaneously. I'm going to click near the middle of my screen, and click split, and where these gray lines have appeared, my screen is actually being split into four sections. I find this a bit difficult to work with, so I'm going to double-click on the middle split to remove it. Now just have a top and a bottom. If I wanted to see some data at the top and compare it to data near the bottom, I can come to my lowest scroll bar and scroll down until I get to near the bottom, and you can see I look to different sections my screen simultaneously. To turn split off, I can double click back on this line or come back up to split and click it off. Now while the split is quite useful, even more useful, is the Freeze Panes. Sometimes, I want to be able to simply scroll down or scroll across and still be able to see my headings, and you can see at the moment I can't. I'm going to bring this little scroll bar backup, and I'm going to come to freeze panes. If I click the dropdown and say Freeze Top Row sounds good, but you'll see it's only frozen the top row which doesn't really help me in this situation. So, to turn that off, come back to freeze panes and click unfreeze. Now, what I actually want to be able to do is freeze the top three rows and my first three columns. The trick to this is to click in the cell directly right and directly below the columns and rows I want to freeze. So, you can see are below row three and to the right of column three. I now come up to freeze panes, and I click Freeze Panes. Some faint black lines appeared, but you'll notice now when I scroll down, my heading stay fixed. When I scroll right, my three columns on the left also stay fixed. Again, to turn freeze panes off back to Freeze Panes and unfreeze. Now the last quick option I want to look at, is the option to switch windows. This is useful when you have multiple workbooks open. So, let's get another workbook open. We've up to now looked at file open, but I'm going to press Ctrl+O which is the shortcut, and I'm going to choose W01-V02-Select and Navigate. We're not looking at a different workbook, but what about if I want to get back to the one I was working in previously? I come to my View tab, I come to Switch Windows, and I now have a list of all my Excel workbooks that are currently open, and I can just click to Switch. There's also a useful shortcut key, it's Ctrl+F6. So, I press Ctrl+F6, and you can see I quickly switches me between my open windows. So, that are some view options to help speed up your workflow and make it easier to work with larger workbooks. Get in that and have a play.