You can include that information by creating a header, which appears at the top of the printed page, and a footer that appears at the bottom of the page.
- When you look at worksheet data for the first time, or the first time in a long time, it can be difficult to see exactly what type of data the worksheet contains. You can include that information by creating a header which appears at the top of the printed page, and a footer that appears at the bottom of the printed page. I'll demonstrate those tasks in this movie. My sample file is the Headers workbook and you can find it in the Chapter Four folder of your exercise files collection. This workbook contains monthly revenue, but let's say that I want to add some elements to it.
For example, perhaps page numbers or a logo. To do that I can go to the Insert ribbon tab. Then with my screen resolution I need to click the Text control. You might be able to see Header & Footer by itself but at my resolution I couldn't. Then I'll click Header & Footer and the header and footer are displayed. In addition, you'll also see the header and footer contextual tab on the ribbon. The header that I have here is split into three different parts.
I have the header, left, center, and right. Let's say that I want to add a pre-made header. I can then, on the Header & Footer contextual tab on the ribbon, click the Header button's down arrow and I can select exactly what I want. Let's say that in the middle section I just want to put in the name of the workbook. That is Headers.xlsx so I'll click that and it appears. Then I'll click over to the left and edit the left side.
Let's say that here I want to put in the current date. On the Header & Footer contextual tab, I can click the Current Date button and I get an ampersand date argument. What that does is indicate that it will show whatever the current date is. Again, not the date that the file was created or last edited, but the current date. Now let's say that I want to add a logo. To do that I can click in another header section or it could be the footer. Everything you can do in one you can do in the other.
Then I'll click the Picture button on the Header & Footer contextual tab. Then in the Chapter04 folder, click KinetecoLogo.png and click insert. When I do, I get an ampersand picture argument, indicating that the image will appear there. When I move away, you see that the image is much too large so I need to format it. Go to the header and click there. With ampersand picture selected, click Header & Footer and then click Format Picture.
Here I can change the size using the Format Header Picture task pane. Wow. Yes, with this, almost 14 inches. Let's change that to, say, three inches and press return. I've changed the width to three inches and I'll click away. Okay, it's still pretty large so I will go back, click it again, and change it to two inches, and return. Then I'll click away. All right. That's much better.
When I'm done with the Format Header Picture task pane, I can just click its close button and it goes away. As I mentioned before, all the techniques that you can use for a header work just as well in a footer.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.