By Allen Wyatt for Excel.Tips.Net
How to Fit an Excel Printout on a Page
I can’t tell you how many times I have gone to print a worksheet, only to have the very last column or the very last row spill over onto another page. This not only wastes paper, but it is very frustrating.
To get around this, Excel has a handy scaling feature that allows you to specify how many pages you want your printed output to occupy. You set the page dimensions, and Excel shrinks everything down so it fits in the specified area. To take advantage of this feature, follow these steps:
1. Set up your worksheet as desired.
2. Display the Page Layout tab of the ribbon.
3. Using the Width and Height drop-down lists (in the Scale to Fit group), specify how many pages you want the output to occupy.
4. Print your worksheet as normal.
This post appears with permission from Allen Wyatt and Excel.Tips.Net.