Hi SC from Lubbock, Texas,
To print on both sides of the paper from two worksheets in the same workbook, you need to follow these steps:
- Click on the first worksheet that you want to print.
- Go to the Page Layout tab on the ribbon.
- Click on the small arrow in the bottom right corner of the Page Setup group to open the Page Setup dialog box.
- Click on the Margins tab.
- Under the Multiple pages section, select "2 pages per sheet" from the drop-down menu.
- Click OK to close the Page Setup dialog box.
- Go to the second worksheet that you want to print.
- Repeat steps 2-6 for this worksheet.
- Go to the File tab on the ribbon and select Print.
- In the Print dialog box, select your printer that supports automatic duplex printing.
- Under the Settings section, select "Print on Both Sides" and choose "Flip on Short Edge" from the drop-down menu.
- Click Print to print both worksheets on both sides of the paper.