To select Excel worksheets so they each print on one page, open the workbook, right click on the sheet tabs, and click Select All Sheets. Click on the Page Setup button, and set the Fit To option to one page. Print the worksheets.Continue Reading
Open the Excel file that you want to print.
Right click on one of the sheet tabs at the bottom of the screen.
In the menu that appears, click the Select All Sheets option at the bottom of the menu.
Click on the Page Layout tab located at the top of the window. Then, click on the Page Setup button in the Page Setup section of the upper toolbar. It is a small button in the bottom right corner of the section.
On the Page tab of the Page Setup window, and look in the scaling section of the window. Find the Fit To option and set it to one page wide by one page tall. This setting makes the worksheet scale to fit on just one page when printed.
Click the Print button to open the Print Menu. Use the Print Preview function to make sure everything is correct. You may print only the active sheets, the entire workbook or the selected worksheets.