See all How-To Articles

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

 

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

 

print two sheets on one page 2

 

3. The Properties window depends on the printer you have. But for any printer, you have to select two sheets per page, and click OK.

 

print two sheets on one page 3

 

As a result, two sheets will be 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.”