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

Microsoft Excel is a great program for managing your data, but it can be a frustrating one 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. But 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.

 

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.

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

 

 

 

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.

Share this...Share on FacebookTweet about this on TwitterShare on Google+Pin on PinterestShare on TumblrShare on RedditEmail this to someone