Using the Page Setup Dialog Box

In Excel page setup options can help you make your worksheet look more professional. Learn all about using the page setup feature in Excel here.

Headers and footers

A header is a title that appears at the top of each page of a document. Footers are printed at the bottom of the page. Headers and footers display in the 0.5-inch space between the header and footer margin and the regular margin. The default setting is no header and no footer.

If you want to add a header and/or footer to your spreadsheet, you can do so using the Page Setup dialog box's Header/Footer tab.

Page Setup dialog box Header Footer tab

To select and create headers and footers:

  • Choose Filelesson actionPage Setup from the menu bar.
  • In the Page Setup dialog box, select the Header/Footer tab.
  • Click the Header drop-down list and select a predesigned header or click the Custom Header button to create your own header. If you choose to create your own header, the Header dialog box appears. Make your entry and click OK to return to the Page Setup dialog box.
  • Click the Footer drop down list and select a pre-designed footer or click the Custom Footer button to create your own footer. If you choose to create your own footer, the Footer dialog box appears. Make your entry and click OK to return to the Page Setup dialog box.
Header Dialog Box

Footer Dialog Box