Scale Sheet Size For Printing In Excel. An Excel worksheet has basically large areas which require printing customization before you can fit your data on one page. Make sure to scale all patterns consistently.
Microsoft Excel Steps 7-9. In the worksheet click File Print. Under Settings click Custom Scaling Custom Scaling Options.
However keep in mind that this will make Excel print to multiple pages.
Define the number of pages to print on First open the worksheet the you want to print On the Page Layout tab Scale to fit group you will see a number of options There are two dropdown boxes one for width and one for height. I have a workbook with about 45 worksheets. So you can increase the print area by reducing the print scal. Option to scale the print size of your document up or down to fit it to the number of pages youd like.