Page Setup (Worksheet) - Page

Click on the Page tab in the Page Setup dialog to set page size and scaling. Click the File | Page Setup command in the worksheet to open the Page Setup dialog.

Change page setup properties in the Page Setup dialog Page page.

Paper

Use the Paper section to choose the paper Size and Source for the active printer.

Size

Click the down arrow next to the paper Size to change the size of the paper. The paper size options available for your printer are listed in the list.

Source

If your printer has multiple print trays, choose the paper Source by clicking the down arrow.

Orientation

The Orientation section controls whether the page is set to Portrait or Landscape mode. Select Portrait to have a vertical page. Select Landscape to have a horizontal page.

Scaling

The Scaling section controls the printed size of the worksheet. There are two options with Scaling: Adjust to and Fit to .

Adjust To

The Adjust to ___ % full size option sets the percent of full size that the worksheet will print. The arrow buttons are used to scroll up or down from 100% (full size), or values can be typed into the box. The Adjust to ___ % full size setting is independent of the Fit to option.

Fit To

The amount of data in the worksheet determines how many pages are required to print the worksheet. The Fit to __ page(s) across by __ option tells the program to print the worksheet at 100% scale or less. This option does not automatically scale the printed worksheet greater than 100%. This option is most useful when the worksheet is large and the number of printed pages needs to be limited.

Printer

The active printer can be changed by clicking the Printer button at the bottom of the Page Setup dialog.

See Also

Margins

Options

File | Page Setup