How to Print Two Sheets on One Page in Excel & Google Sheets

This tutorial demonstrates how to print two sheets on one page in Excel and Google Sheets.

 

 

Print Two Sheets on a Page

If you want to print two sheets on one page, follow these steps:

1. In the Ribbon, go to File > Print.

 

 

2. In the Settings part, choose Print Entire Workbook, and click on Printer Properties.

 

 

3. The Properties window depends on the printer you have. But for any printer, you have to select two pages per sheet, and click OK. This “sheet” refers to a piece of paper, not a worksheet.

 

 

As a result, two sheets are printed on one page.

Print Two Pages on a Sheet in Google Sheets

Google Sheets prints through your browser, and the appearance of the Properties window will vary, but there should be, just like above, a field to set pages per sheet.