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.
How to Set Up the Selected Worksheets So That They Each Print on One Page
- 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.
- Click the Page Layout tab.
- Click the Page Setup button.
- Click the Fit to option, then set it to 1 page wide by 1 tall.
- Click the Print button.
- Click the Print Active Sheets button, then select Print Entire Workbook.
- 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.
Step 3: Click the Page Layout tab at the top of the window.
Step 4: Click the small Page Setup button at the bottom-right corner of the Page Setup section of the ribbon.
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.
Step 6: Click the Print button at the bottom of the window to open the Print menu.
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.
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.
- How to subtract in Excel
- How to sort by date in Excel
- How to center a worksheet in Excel
- How to select non-adjacent cells in Excel
- How to unhide a hidden workbook in Excel
- How to make Excel vertical text
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.