View your worksheet in Print Preview mode. If only a few rows of data spill onto a second page, you can alter the page scale; click the Setup button to begin.
On the Page tab of the Page Setup dialog box, click the Fit to 1 Pages(s) Wide by 1 Tall option button. (Or, type the number of pages to fit.)
Click OK.
Your worksheet appears in Print Preview mode, all on one page. Notice that the scaling change reduced the total number of pages to print from two to one.
INTRODUCTION
By default, Excel prints your worksheet at a scale of 100%. You can decrease this percentage if you want to fit more data on a page, or you can increase it to fit less. In addition, you can have Excel fit your entire worksheet on one page. (Although, if your worksheet is large, the data might become too tiny to read.)
TIP
Changing from Letter to Legal
To choose a different paper size for your printout, click the Options button on the Page Setup dialog box. The scaling setting automatically adjusts to the selected paper size.
TIP
Returning to the Default Scale
When you want to return the preview of your worksheet to the default scale, click the Adjust to option and type 100 into the % Normal Size field.