Defining Page Setup Options

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

Changing page orientation and paper size

The Page tab of the Page Setup dialog box lets you change page orientation (portrait or landscape) and paper size (e.g., letter size or legal size). The default paper size in Excel XP is 8.5 x 11 inches with a portrait orientation, which prints up and down on the long side of the page. A landscape orientation, on the other hand, prints up and down on the short side of the page.

Page Orientation

To change page orientation:

  • Select the correct worksheet.
  • Choose FilePage Setup from the menu bar.
  • Click the Page tab.

    Page Tab on the Page Setup Dialog Box
  • Choose an orientation—portrait or landscape—for the worksheet.
  • Select a paper size from the list of available paper size options that appear in the list box.
  • Click the paper size.
  • Click OK to accept the page settings.

The Page tab of the Page Setup dialog box lets you shrink the spreadsheet data so it fits on a specified number of pages when you print. Click the Fit to: option button, then enter the desired number of pages wide and pages tall.

The Page tab of the Page Setup dialog box lets you define the resolution of the print job. Print quality is measured in dpi, or dots per inch. A higher dpi provides a better print quality.