How to Print More Than One Worksheet on a Page in Excel 2013

Printed Excel spreadsheets often waste a lot of paper. This is usually because there is a row or column that won’t fit on one page, causing an extra (sometimes multiple extra) page(s) to print. But you might find that you need to print all of the worksheets within a workbook, and that each of those sheets only contains a small amount of data.

You may often be able to set or clear print areas to manage the data that you print, but another way to reduce the amount of paper in this situation is to print multiple worksheets on one page. This is accomplished by changing a setting in Excel, as well as a setting for your printer. The exact method will depend on your specific printer model, but most printers will offer an option that makes it possible to print more than one page on a sheet of paper.

How to Print Multiple Worksheets on a Single Page in Excel 2013

The steps in this article will show you how to change the printing settings in Excel 2013 to allow for the printing of multiple worksheets within a workbook on one page. Note that all of the worksheets that you are trying to print must be part of the same Excel workbook.

Note that these directions assume that each worksheet will fit on one page. If not, read this article if you would like to change the layout of a worksheet.

Step 1: Open the workbook in Excel 2013.

Step 2: Click the File tab at the top-left corner of the window.

click the file tab

Step 3: Click the Print button in the column at the left side of the window.

click the print button

Step 4: Click the Print Active Sheets button, then click the Print Entire Workbook option.

print entire workbook

Step 5: Click the Printer Properties button.

click the printer properties button

Step 6: (Note that this step will vary depending upon your specific printer) Look for an option that allows you to control the layout of your printed pages. In the example image below, that option is Page Layout. You can then select the number of sheets to print per page. I am selecting the 4 on 1 option.

click the 4 on 1 option

Depending upon the amount of data and number of sheets that you are trying to fit on a page, your data might be very small. In that case, you might have more luck printing each worksheet on its own page.

solveyourtech.com newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.