Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.
To reduce the amount of paper needed to print a large amount of information.
On the Layout tab, under Print, select the Fit To check box.
Type 1 in both the page(s) wide box and page(s) tall box.
To print a sheet so that the columns appear on one page and the rows extend to more than one page, type 1 in the page(s) wide box, and then type 9999 in the page(s) tall box.
You can see how your sheet prints before you print it. On the File menu, click Print, and then click Preview.