Video: The Page Layout View

Page Layout view gives you a nice way to fine-tune the look and feel of your document that's going to be printed out. By looking at a view that presents the information is if you were looking at the page itself. So let's go explore that at the moment. I'm just going to select cell A7 so that when I go move to my Page Layout view, I'm looking at the top of my screen. I've indicated where I want to start my Page Layout view, And I'm going to go down to my view options at the bottom of the screen and click Page Layout.

Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.

The Page Layout View

Page Layout view gives you a nice way to fine-tune the look and feel of your document that's going to be printed out.By looking at a view that presents the information is if you were looking at the page itself. So let's go explore thatat the moment. I'm just going to select cell A7 so that when I go move to myPage Layout view, I'm looking at the top of my screen.I've indicated where I want to start my Page Layout view, And I'm going to go down to my view options at the bottom of the screen andclick Page Layout.

Now I see the Page Layoutview in front of me.And I started at the top of my page, So you'll see here that it presents the information as if I waslooking at iton a printed document.So it'smuch more visually appealing to see what the information's going to be like--look like--when it actually gets printed out.The advantage of using the Page Layout view rather than the Print Preview icon is that I can actually manipulate thescreen here and add information into it, where as the Print Preview just gives me a snapshot before I actually go to print.

SO, what I'm looking at here is the ability tochange things up, but it is a very busy screen.I think I'm going to close off some of the options that I can look at here. And I do that by going over to the sheet optionsgrouping.First of all, I want to turn off the headings.So I deselect the box that I see here and that removes the headings, the column headers, and the row numbers that wereidentified or showing on the side. I'll just re-click that so you can see what happened. If I select View headings,you'll see that the row,the row numbers,and the column letters are shown.

That's good if I'm identifying a particular cell like I did at the beginning of the lesson, but it's not necessary for me to seethis anymore, so I'm going to turn them off.I also have the ability to view gridlines, and if I scroll down through the screen,you'll see that in the other screens here, the grid lines are shown.This is great if I'm going to add-in some information, butit could be distracting because it doesn't give me a clear view of what's going to actually be printed out. So I couldremove seeing the gridlines by just clicking off the view, and the gridlines are removed from that particular sheet.

SO you can see more and more in my Page Layout view, I get a very cleardescription of what information is going to be printed out on my page.And I can play with the data just as if I was in the Excel spreadsheet itself, but it's printed out in a much nicer fashion.In the Scale to Fit grouping, you can play around with the size of the information that's presented on your page. Andby playing with the Scale to Fit grouping, you caninclude more information because it adjusts theprinted outputto the percentage of the actual information that you're seeing on the screen here. So if I increase the scale just by one click up to105%, you'll notice that I've pushed off my final costcolumn on to another page.

Now if I was playing with this in a print preview environment, I wouldn't necessarily see that I've pushed the informationright off the page.And this is unacceptable if I'm going to print on it. So, all I have to do is go back,click back to 100%, and you'll see that Ihave moved back my column onto the proper page. This is another way to work with margins and again, for those of youthat are more visuallyinclined, this is a nice way to see where the information's going to fit before you print it off. In our next movie, we'regoing to discover how to work with headers and footers,so hang tight!

Q: When trying to apply the techniques from the “Relative and absolute referencing” video to a worksheet other than the exercise file included with the title, the formulas did not work for the entire worksheet. The formulas would only work when going through the worksheet row by row. What could be causing this to happen?

A: When trying to apply formulas to a whole workshee, here is a tip to try:

If you want to always refer to the same cell then use an absolute reference. For example, always pulling the value from cell A3 would be referenced as $A$3. This will never change no matter where you copy it to in the spreadsheet.

If you want to reuse the same formula, but with values in different cells, use the relative reference, A3. This way formula =A3*B3 will become =A4*B4 as you copy it down a column.

Q: In the chapter 7 video "Sorting and Grouping" at approximately 4:05, the author says to go to cell 5 on the worksheet and click on Subtotal to subtotal the grouping. My screen will not allow me to click on the Subtotal option at the top of the page. Is this an issue with my version of Excel?

A: It seems that there is an error in the instructions in this video. The video should have instructed users to do the subtotaling first, then create the table.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.

Already a member ?

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships.
Learn more

Upgrade to our Annual Premium Membership today and get even more value from your lynda.com subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Thanks for signing up.

We’ll send you a confirmation email shortly.

Sign up and receive emails about lynda.com and our online training library:

new course releases

newsletter

general communications

special notices

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

new course releases

newsletter

general communications

special notices

Here’s our privacy policy with more details about how we handle your information.