This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?

Microsoft Excel 2003

About the Page Setup Dialog Box

The Page Setup dialog box provides many options for customizing your print settings for Microsoft Excel 2003. Changes made for the page setup are made for each sheet individually. This means that one sheet can be printed in landscape orientation and another printed in portrait orientation without readjusting the settings for each sheet.

Different option tabs are available in the Page Setup dialog box, each of which are explained in this document.

return to topAccessing the Page Setup Dialog Box

The Page Setup dialog box is accessible by several methods. It can be selected directly from the File menu or the Print Preview dialog box. Depending on how you access the Page Setup dialog box, some options may not be available. For all options to be available, the dialog box must be accessed using the File menu option:

  1. From the File menu, select Page Setup...
    The Page Setup dialog box appears.

return to topPage Setup Dialog Box Options

The following options are available in the Page Setup dialog box, regardless of what tab you are using. They are located along the right and bottom of the dialog box.

Option Description
OK Accepts the settings and returns you to your Excel worksheet.
Cancel Exits the Page Setup dialog box without implementing any changes.
Print... Opens the Print dialog box, which allows you to adjust the number of copies and print range before printing.
Print Preview Allows you to preview the current sheet using current options before printing. Available options on the Print Preview screen include adjusting print settings and changing margins.
Options... Opens a dialog box where you can adjust printer settings.

return to topPage Tab Options

Under the Page tab of the Page Setup dialog box, you will find several options enabling you to specify how your worksheet(s) will print. This section provides information about Page tab options; for instructions on adjusting specific Page tab options, refer to Customizing Page Layout.

Page Setup dialog box, Page tab

Option Description
Orientation Selects the width of the printed page. Most documents are portrait; however, many worksheets may be easier to read in the landscape mode.
Scaling Adjusts the percentage of the printed copy's actual size. Options are available for fitting all columns or rows to a certain number of pages. The default size of the printed copy is 100%.
Paper size Selects the paper size to match the stock currently loaded in the printer.
Print quality Adjusts the resolution of your printer. Options include 300 dpi or 600 dpi.
First page number Sets the page number that will print on the first page. If you want the first page number to be number one (1), leave the selection on Auto.

return to topMargins Tab Options

The Margins tab of the Page Setup dialog box provides options enabling you to set all your margins and center your sheet both vertically and horizontally. This section provides information about Margins tab options; for instructions on adjusting specific Margins tab options, refer to Customizing Page Layout.

Page Setup dialog box, Margins tab

Option Description
Top, Bottom Adjusts the top and bottom margins.
Left, Right Adjusts the left and right margins.
Header, Footer Adjusts the location of the header and footer.
Center on page Centers the worksheet on a printout horizontally, vertically, or both.

return to topHeader/Footer Tab Options

The Header/Footer tab of the Page Setup dialog box allows you to access options to adjust the information at the top of each page (header) or the bottom of each page (footer). Headers and footers are descriptive text printed at the top and bottom of every page in your worksheet. Headers and footers may contain the date, page number, filename, text, or the contents of a cell.

Excel has two types of headers and footers available. The first, preset, comprises Microsoft Excel samples and headers or footers you have used in the past. The second type, custom, is created by you. This section provides information about Header/Footer tab options; for instructions on adjusting specific Header/Footer tab options, refer to Modifying Header and Footer Information or Customizing Page Layout.

Page Setup dialog box, Header/Footer tab

Option Description
Header Offers a choice from a list of preset headers. Previously used headers will appear in this list.
Custom Header... Allows you to create your own header. Options include adding time, data, page numbers, and text. In addition, you can change the font associated with all of these options.
Custom Footer... Allows you to create your own footer. Options include adding time, data, page numbers, and text. In addition, you can change the font associated with all of these options.
Footer Offers a choice from a list of preset footers. Previously used footers will appear in this list.

return to topSheet Tab Options

Under the Sheet tab of the Page Setup dialog box, you are provided with several options for selecting what you want printed. This section provides information about Sheet tab options; for instructions on adjusting specific Sheet tab options, refer to Other Printing Options.

Page Setup dialog box, Sheet tab

Option Description
Print area Specifies a range of cells to print.
Print titles Specifies the rows or columns to print on each page. This is useful in printing heading rows at the top of each page in a report. Options for this section include Rows to repeat at top and Columns to repeat at left.
Print Allows only certain elements of your worksheet to be printed. Options include Gridlines, Black and white, Draft quality, Row and column headings, Comments, and cell errors as. This is most useful for selecting whether gridlines should be printed.
Page order Controls the order in which the pages of your worksheet are numbered and printed when the printout does not fit on one page.
Excellence. Our Measure. Our Motto. Our Goal.