Use the Page options found in the worksheet's File | Page Setup to set page size and scaling.
Paper
Use the Paper group to choose the paper Size and Source for the active printer.
Orientation
Orientation sets the page in either Portrait or Landscape mode.
Scaling
Scaling controls the print size for the worksheet. There are two options with Scaling:
The Adjust to ___ % full size option sets the percent of full size that worksheet will print. The arrow buttons are used to scroll up or down from 100 percent (full size), or values can be entered into the box. The amount of data in the worksheet determines how many pages are required to print the worksheet. This is independent of the Fit to option below.
The Fit to __ page(s) across by __ page(s) down option tells the program to print the worksheet at 100 percent scale or less. This option does not automatically scale the printed worksheet at greater than 100 percent. This is most useful when the worksheet is large and the number of printed pages needs to be limited.