Introduction
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
Step One
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.
Step Two
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.
Step Three
Go to “File” in the menu bar and select “Page Set-up.” A new box with options will appear. If you do not see “Page Set-up” in your options from the drop-down menu, click the arrow at the bottom of the “File” list to see more options.
Step Four
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, centre or right). Once you have entered the words, click the “A” to change the font to whatever type, size and colour 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, centre or right) can have its own font selection.
Step Five
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.
Step Six
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.