To select Excel worksheets for printing on a single page, open the workbook, right-click on the sheet tabs, and then choose Select All Sheets. Click the Page Setup button and select One Page for the Fit To option. Produce the worksheets on paper.
Launch the file
Launch the Excel file you wish to print.
Click with the right mouse button on one of the tabs at the bottom of the screen.
Click the option Select All Sheets
Click the Select All Sheets option at the bottom of the menu that opens.
Visit Page Setup
Select the Page Layout tab at the top of the window by clicking on it. Then, click the Page Setup button in the upper toolbar’s Page Setup area. It is a little button in the section’s lower right corner.
Choose the Fit To option.
On the Page tab of the Page Setup window, locate the window’s scaling section. Find the Fit To option and adjust the dimensions to one page wide by one page tall. This setting allows the worksheet to be printed on a single page.
Produce the worksheets on paper.
To open the Print Menu, click the Print button. Utilize Print Preview to ensure that everything is accurate. You can choose to print simply the active sheets, the full workbook, or specific worksheets.