Garyh650 

Scale a worksheet

If your worksheet has a lot of columns, you can use the Scale to Fit options to reduce the size of the worksheet to better fit the printed page.

Follow these steps:

1. Click the Page Layout tab on the ribbon.

2. In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic. Columns will now appear on one page, but the rows may extend to more than one page.To print your worksheet on a single page, choose 1 page in the Height box. Keep in mind, however, that the printout may be difficult to read because Excel shrinks the data to fit. To see how much scaling is used, look at the number in the Scale box. If it's a low number, you may need to make other adjustments before you print. For example, you may need to change the page orientation from portrait to landscape or target a larger paper size. For more information, see the section below to understand a few things about scaling a worksheet to fit a printed page.

3. To print your worksheet, press CTRL+P to open the Print dialog box, and then click OK.