Monday, August 27, 2012

How to Add a Header and Footer in Excel


1. 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.
2. 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.
3. 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.
4. 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.
5. 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.
6. 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.

Blogger news