Click on the Page tab in the Page Setup dialog to set page size and scaling.
The Page Page
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 __ page(s) down 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