How to Get the Header on Every Page in Microsoft Excel

By Eric Jay Toll

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

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.

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."

Tips & Warnings

  • Getting headers on each page in Excel 2007 uses the same methods as Excel 2010.
  • Creating the header using the "Insert" tab method (step 1) provides the greatest flexibility for header design, appearance and content.
  • Using the three optional methods (steps 2, 3 and 4) provides the "comfort" of the same system used in earlier versions of Excel.
  • Clicking the "Options" button on the "Page Setup" window in methods 2, 3 and 4 opens the printer's options and do not offer any layout options.
  • Customize the ribbon or quick access toolbar by adding the "Header" command from the "All Commands" list.
  • Scaling headers to keep proportions as the document is enlarged or reduced for printing are the default check box setting.
  • Aligning headers to change with changes in spreadsheet margins is the default check box setting.