How to Get the Header on Every Page in Microsoft Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

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.

Advertisement

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.

Advertisement

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

Advertisement

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

Advertisement

Advertisement

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

Advertisement

Advertisement

references & resources