How to Print Each Worksheet of an Excel 2013 Workbook on One Page

When you have an Excel workbook with a lot of individual worksheets, you might need to print all of those sheets at once, and you may want them each to fit on one page.

Microsoft Excel is a great program for managing your data, but it can be a frustrating application when you need to print out that data in a manner that is easily digestible. Worksheets can easily run off of a single page and wind up wasting a lot of paper, or they can print as a giant mess of data.

Maybe you’ve already learned how to configure a worksheet to avoid these problems, and you now need to apply that fix to multiple worksheets in the same workbook.

Unfortunately, the same method does not work when you go to print an entire workbook, so you need to find an alternative method to set each worksheet page of an Excel 2013 workbook to fit on one page. Fortunately, Excel lets you select multiple worksheets at once and apply the same changes to all of them.

As an Amazon affiliate, I earn from qualifying purchases.

How to Set Up the Selected Worksheets So That They Each Print on One Page

  1. Right-click a worksheet tab at the bottom of the window and click Select All Sheets, or hold down the Ctrl key and click each individual sheet that you want to print.
  2. Click the Page Layout tab.
  3. Click the Page Setup button.
  4. Click the Fit to option, then set it to 1 page wide by 1 tall.
  5. Click the Print button.
  6. Click the Print Active Sheets button, then select Print Entire Workbook.
  7. Click the Print button.

Our guide continues below with additional information and pictures for each of these steps.

How to Print Each Page of an Excel Worksheet on Just One Page

You’ve probably gotten to this page because you have an Excel workbook that has a high number of worksheets in it, and you want to avoid having to go through and manually set each individual worksheet to the Fit on One Page option.

By following the method below you can apply that setting to all of your worksheets at once and save yourself some time.

Step 1: Open the workbook containing the worksheets that you want to all print on just one page.

Step 2: Right-click one of the sheet tabs at the bottom of the screen, then click the Select All Sheets option.

Alternatively, if you don’t want to print every worksheet, you can hold down the Ctrl key on your keyboard, then click each worksheet that you want to print. You can then continue the steps below to set up the selected worksheets so that they each print on one page.

excel-2013-print-all-worksheets-on-their-own-page-1

Step 3: Click the Page Layout tab at the top of the window.

excel-2013-print-worksheets-on-their-own-page-2

Step 4: Click the small Page Setup button at the bottom-right corner of the Page Setup section of the ribbon.

excel-2013-print-worksheets-on-their-own-page-3

Step 5: Click the option to the left of Fit to in the Scaling section of the window, then make sure that it is set to 1 page(s) wide by 1 tall.

excel-2013-print-all-worksheets-on-their-own-page-4

Step 6: Click the Print button at the bottom of the window to open the Print menu.

excel-2013-print-all-worksheets-on-their-own-page-5

Step 7: Use the scrolling buttons at the bottom of the window to see that your worksheets have all been set to print on just one page each.

Since all of your worksheets should still be selected and, therefore, active, you could click the Print button to print all of the active sheets. However, if all of the worksheets are not still selected, you can click the Print Active Sheets button, and click the Print Entire Workbook option.

how to print worksheets on their own page in excel 2013

Now that you know how to print each worksheet in an Excel workbook on one page, you can use these steps to quickly print an entire workbook without using a lot of paper.

While the method in this article is focused on printing every worksheet of a workbook so that each one fits on a single page, you can apply other changes to an entire workbook by selecting every sheet as well. This is helpful when you need to apply the same formatting change and want to save yourself some time.

We have previously written about how to fit all of the columns in a single Excel 2013 on one page.

Amazon gift cards are the perfect choice for the difficult-to-shop-for person in your life. They can be used on almost any item sold through Amazon’s website, and you can use your own images to customize the way the card looks. You can even create a video gift card.

Continue Reading

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy