Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
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.
Now I see the Page Layout view 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 was looking at it on a printed document. So it's much 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 the screen 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 to change 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 options grouping. 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 were identified 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 see this 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, but it could be distracting because it doesn't give me a clear view of what's going to actually be printed out. So I could remove 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 clear description 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. And by playing with the Scale to Fit grouping, you can include more information because it adjusts the printed output to 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 to 105%, you'll notice that I've pushed off my final cost column 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 information right 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 I have moved back my column onto the proper page. This is another way to work with margins and again, for those of you that are more visually inclined, this is a nice way to see where the information's going to fit before you print it off. In our next movie, we're going to discover how to work with headers and footers, so hang tight!
Find answers to the most frequently asked questions about Excel 2007 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.