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.
There are some times when you'd like to place titles at the top of each page in your printed document, and you want them to be consistent from page to page. what that's called is called a header. You can also put the same kind of information down at the bottom of the page, and that's called a footer. What we're going to do now is we're going to explore easy ways to add that kind information to printed documents in Excel 2007. I'm going to work with my Page Layout view because that gives the easiest way to access the information, and it also shows me right up front, how it's going to look on my printed page, which has been a concern with previous versions of Excel in using headers and footers.
It's indicating to me where I can center the first piece of my header, so if I just click on that, you'll notice that it activates a line that has three sections. I have a left area, a middle area and a right area. And I can put separate header information in each of these. For example, if I wanted to put the date in the far left corner of my document, I could select that header quadrant, go up to Current Date in my Header & Footer Elements area, and select it. And you'll notice that it populates a tag. And what that's going to do is it's going to print the current date every time this particular document is open.
We'll see how this looks in a moment. So don't get worried that this is actually going to print out on your document, it's just a tag, it's some information that the computer understands that will pull in the date--the current date. And if I click over to my center, you'll notice that it populates the date that I'm working with today. in the center, I may want to put in a title. I could use a again, one of my footer elements. I can use my Sheet Name, which would pre-populate in my EatCake Inventory listA name.
I could input a picture so I can add a nice graphic. Here in the center of my document, I'm going to type the name of this particular list, so I'm going to call it the EatCake Inventory List. Over in the far right, I'm going to add one other smart element, and that's the number of pages. The actual page number that I'm working with. And if I click off that, I now have page number 1.
So I've set up the header for this particular page. If I scroll over to page number 2, by using my scroll bar, and I now go on to page number 2, you'll see that some of the information has stayed the same. The date is now the same, my list is-- title is now the same, but my page number has changed to show page number 2. So by using the Header & Footer Elements, it really saves you a lot of time.
If I click Go to Footer, it now pulls me from the top of the page down to the bottom of the page. And I can add other information at the bottom of each of the screens. Down at the bottom my page in my footer, I'm going to put in my tagline EatCake. I click off of my headers and footers, so that I now can go over to my Print Preview icon and see how this looks. Notice now, that I have my header's put at the top of my pages, I'm just going to click off the show margins so that we get a nice clean view here.
And if I go down to my Next Page, I see the headers there as well. Let's see if my footers came by. I scroll down to the bottom my screen, and there's my little tagline at the bottom. If I Zoom out, I get a nice view of how my print information is going to be presented. I think we've done a very good job at learning how to use our print options in the Excel 2007, and we're ready to go on to our next topic.
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.