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 one page 4

 

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.

 

print two sheets on one page 1

 

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

 

print two sheets on one page 2

 

  1. 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.

 

print two sheets on one page 3

 

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.