To reduce the amount of paper needed to print a large amount of information, you can print a sheet on just one page.
Print a sheet on one page
On the Page Layout tab, select Page Setup.
Under Scaling, select Fit to, and type 1 in both the page(s) wide box and page(s) tall box. Select OK.
On the File menu, select Print.
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 Pages wide by box, and then type 9999 in the Tall box.
You can see how your sheet prints before you print it. On the File menu, click Print, and use the arrows to page through the worksheet.