How to Fit an Excel Printout on a Page

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.

Article Continued Here

This post appears with permission from Allen Wyatt and Excel.Tips.Net.

(Visited 11 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *