How to Add a Header and Footer in Excel

By eHow Computers Editor

Rate: (5 Ratings)

Excel is commonly used in workplaces and schools and also in many homes for personal information. When printing Excel files, it is helpful when the pages have a header or footer to help you identify the documents. Follow these steps to add both a header and footer to an Excel file.

Instructions

Difficulty: Moderately Easy

Step1
Create or open the file you will be working with. A header and footer can be changed in an existing file or added to a new or existing file.
Step2
Determine if you will use a header, footer or both. Also decide what you want each of these to look like and say. These steps show how to add both a header and footer so choose the steps suitable to what you need.
Step3
Go to "File" in the menu bar and select "Page Setup." A new box with options will appear. If you do not see "Page Setup" in your options from the drop-down menu, click the arrow at the bottom of the "File" list to see more options.
Step4
Click the tab that says "Header/Footer," and then the "Custom Header" button. Type the words you want displayed into the appropriate box (or boxes) for where on the top of page you want the header to display (left, center or right). Once you have entered the words, click the "A" to change the font to whatever type, size and color you want these words to be displayed as and click "OK" on both the font and header boxes. Each word or section of words (left, center or right) can have its own font selection.
Step5
Include a footer by clicking the "Custom Footer" button of the "Header/Footer" tab. Again enter and format the text where you wish it to be displayed. You can automatically add the page numbers, date, time, file path, file name or tab name by using the buttons. Note that a code automatically appears depending on what you choose. You should not edit that information, but you can include text before or after that code.
Step6
Select the "OK" button once done formatting the footer. Click the "Print Preview" button to verify that you header and footer look the way you want. Edit them as needed and click "OK" to add them to your document. Save the file by selecting "Save" or "Save As" from the "File" menu.

Tips & Warnings

  • If you want the same header and footer on multiple tabs of one document, hold the "Ctrl" key on your keypad down and select the tabs to include the same header and footer information. Then follow Step 3 through Step 6.

Post a Comment

POST A COMMENT

Request a New How-To Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article:  How to Add a Header and Footer in Excel

eHow Computers Editor

eHow Computers Editor

Category: Computers

Articles: See my other articles

Related Ads