Add a header or footer to an Excel document and it takes on a professional appearance. Header or footer content options include multiple text lines, images and logos. Available document-generated fields including date, spreadsheet title, or file name and path. In Excel 2010, there are four different ways to add a header or footer to spreadsheets. If you customize the ribbon or quick access toolbar, then there are two additional methods of getting a header on every page in Excel.
Different Methods for Getting the Header on Every Page in Excel 2010
Video of the Day
Step 1
Click "Header & Footer" from the "Text" group on the Excel 2010 ribbon's "Insert" tab. Enter and format the header content in the displayed header field. Clear the "Different First Page" check box, if checked, in the "Options" group" of the "Header & Footer Tools" tab. Add images by clicking the "Picture" button on the "Header & Footer Elements" group.
Video of the Day
Step 2
Click the "Margin" button in the "Page Setup" group on the "Page Layout" tab and select "Custom Margins" from the drop-down list. Choose the "Header/Footer" tab when the "Page Setup" window opens. Clear the "Different First Page" check box, if checked, underneath the "Footer" display pane. Select a preset header from the "Header: drop down list box or click "Custom Header."
Step 3
Click the "Expand" arrow at the bottom right side of the "Page Setup" group in the "Page Layout" tab. Choose the "Header/Footer" tab when the "Page Setup" window opens. Clear the "Different First Page" check box, if checked, underneath the "Footer" display pane. Select a preset header from the "Header: drop down list box, or click "Custom Header."
Step 4
Click the "Page Setup" link at the bottom of "Settings" in the "Print" command window on the "File" tab. Choose the "Header/Footer" tab when the "Page Setup" window opens. Clear the "Different First Page" check box, if checked, underneath the "Footer" display pane. Select a preset header from the "Header: drop down list box, or click "Custom Header."