How to make a wide report fit to one page wide by many pages tall
By Bill Jelen
Bill Jelen is the author of 24 books on Microsoft Office Excel. He is a regular guest on TechTV with Leo Laporte and the host of MrExcel.com, which includes more than 300,000 questions and answers about Excel.
Have you ever taped together multiple pages of a report into one wide report? You can avoid that problem by using the Scale to Fit settings to print to one page wide by any number of pages tall. But before you do that, you need to double-check a few things.
This article is an excerpt from Learn Excel 97-2007 from MrExcel by Bill Jelen. Buy the print edition or download a free e-book edition from MrExcel.com.