Changing the Paper Orientation and Size in Excel 2007

In Excel 2007, you select the portrait or landscape page orientation, which affects the layout of the printed page. You also can adjust the Size setting based on the size of the paper you plan to print your worksheet on.

Adjusting the page orientation

Because many worksheets are wider than they are tall, you may find that their printouts look better if you switch the orientation from the normal portrait mode to landscape mode.

On the Page Layout tab of the Ribbon, you'll find the Orientation button in the Page Setup group. Clicking the Orientation button reveals a drop-down menu with these two options:

  • Portrait (the default), where the printing runs parallel to the short edge of the paper.

  • Landscape, where the printing runs parallel to the long edge of the paper.

    The Orientation setting comes in two flavors: Portrait and Landscape.
    The Orientation setting comes in two flavors: Portrait and Landscape.

In the following figure, you see the first page of a report in landscape mode in the Page Layout view. For this report, Excel can fit three more columns of information on this page in landscape mode than it can in portrait mode. The total page count for this report decreases from ten pages in portrait mode to six pages in landscape mode. Of course, the portrait orientation may work better for other reports. Experiment with the settings and use Print Preview until you find the best fit.

A report in landscape mode.
A report in landscape mode.

Selecting a paper size

In most cases, you'll use the standard 8.5-x-11-inch letter size paper to print your worksheets. However, if you find that you need to print on 8.5-x-14-inch legal paper size, an envelope, or another paper size, you must tell Excel which size paper you want to use.

To change the paper size setting, click the Size button in the Page Setup group of the Page Layout tab and select the desired size from the resulting drop-down list.

Use the Size drop-down list to select a paper size.
Use the Size drop-down list to select a paper size.
blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.