If you want to reduce the size of data on a printout, you can use the Scale to Fit tools on the Page Layout Ribbon. This is especially helpful if your data spans more than one page in width or height and you wish to shrink it so that it fits on one page. Reducing the scale of your printout allows you to fit more rows and columns on each page. Be careful though – reducing the scaling too much can result in a printout that is unreadable.
To Force a Worksheet to Fit on a Specified Number of Pages
- Click the Page Layout tab on the Ribbon.
- To scale the worksheet to fixed percentage, enter a value between 10 and 400 in the Scale box under the Scale to Fit group.
- To adjust the printout to a specific number of pages, click the Width and Height drop-down arrows and choose the desired number of pages.
Tip: You can also set worksheet scaling from the Page tab of the Page Setup