Interested in becoming an Affiliate Trainer? We are now accepting applications for local and international positions. No need for cold calling! Receive referrals of people looking for specialized training in your area and get access to all of the training curriculum I have created and continue to create to use at your appointments.

 Views  Show/Hide  Zoom  Window                         Macros

     Excel 2007 Workbook Views 

The Workbook Views section in Excel 2007, will allow you to format a worksheet the way you want it. In this section, you will be able to customize a pages layout, create custom view, which will allow you to apply a document to your worksheet, etc. We will be learning from left to right, step by step, the Workbook Views section in Excel 2007.

First, we have Normal View. It is the first icon with a blank worksheet and says “Normal” below it. This will allow you to go back and look at your work in a simple review when needed. By doing, so you can make any changes you may need to by going back to this view.


The second icon is Page Layout. It is the small piece of paper, with the upper right corner folded down, and says “Page Layout” below it. This will allow you to view the way a page will look on paper before you print it out. You will also be able to add some details to you worksheet to put it all together such as, headers, or footnotes. This may be helpful when wanting to be sure your page has the detail and organization you may want. When clicking on where you will like to add the such, the worksheet section turns into a section to help you make those changes customized and detailed. It will look like this: 

As you can see, this will allow you to add things such as, the time and date, pictures, and of course, headers and footers.


The Page Break icon has a blank chart and says “Page Break Preview” below it. This will allow you to see and change where pages will break off when printed them. This will help you manage how many pages you want printed out, or what documents you want printed on certain pages. On your sheet there will be a little grey box, which you can see in the photo presented. To create breaks , simply drag the little box to where you want your pages to break off. When you are done making the changes you want you can go back to the Normal layout and will be able to see  where your page breaks off. It will look something like this:

If you find that the break is not where you want it, you can back into the Page Break Preview, and move it to your liking just by clicking on it and dragging it to the desired place. 

To delete a break , click on Page Layout. From there click Breaks, and it will show the option that says “Remove Break”. Here’s what that will look like:


Custom Views is going to be helpful when you want to be taken to a specific document right away. When you want to add/create a custom view, click “Custom Views’’

By doing so, a small window will pop up that looks like this:

To add/create a custom view click on where it says, “Add…”.  This will transition into a different window that allows you to write the name of the document and check of if you would like print setting, hidden rows, etc.  It will look like this:

From here you will be able to type in the name of the document you want to custom view. When finished click OK and then click on the same Custom Views icon as before to review the custom view you just created. Once you review the custom view you created, click on the one you would like to see/edit. It will give you the option to Show, Close, Add, or Delete. It will look like this:

Lastly in the Workbook Views section, is the Full Screen icon, which is a blank chart sheet with a smaller photo in front of it at the lower right corner and says “Full Screen” below it.  

This feature allows you to view your document without any extra icons surrounding it. When you click on Full Screen, it will appear like this :

To exit Full Screen, simply right click on your mouse, and go to the bottom where it says “Close Full Screen”.

That was our step by step review of the Workbook View section in Excel 2007.