How to Print Each Worksheet on One Page in Excel

This post will guide you how to print each worksheet on one page in Excel. How do I print each worksheet of an Excel workbook on one page.

Print Each Worksheet on One Page

Assuming that you have a high number of worksheets in your workbook, and you want to print each worksheet on just one page, even if the content in some worksheet is a little more that one page. The following method will show you how to set each individual worksheet to the Fit on One page in the same workbook.

Step1: open your workbook that containing the worksheet that you want to all print on just one page.

Step2: right click on any one worksheet tab at the bottom of the Excel Window, then click the Select All Sheets option from the popup menu list. All worksheets should be selected in your workbook.

print each worksheet on one page1

print each worksheet on one page3

Note: if you do not want to print every worksheet, you just need to hold down the Ctrl key on your keyboard, and then click each worksheet that you want to print. Then continue the below steps to setup the selected worksheets so that each sheet can print on one page.

print each worksheet on one page2

Step3: go to Page Layout tab in the Excel Ribbon at the top of the window, and click Page Setup icon at the bottom-right corner of the Page Setup group. Then the Page Setup dialog will appear.

print each worksheet on one page4

Step4: switch to Page tab in the Page Setup dialog box, click the Fit to option in the Scaling section, and then set 1 page(s) wide by 1 tall. Then you can click Print Preview button to view the result if it is expected. Click Ok button.

print each worksheet on one page5

Step5: or you can click the Print button at the bottom of the Page Setup window, it will open the Print pane. You should see that your worksheets have all been set to Fit Sheet on One Page. Then click the Print button, it will print all of the selected worksheets.

Note: if all of the worksheets are not selected, you can click the Print Entire Workbook option to print the entire workbook.

print each worksheet on one page6



Related Posts

Match Single Criteria in Excel

No repeat statistic based on a single condition is used wildly in daily work, for example, count type of products, the duplicate types are not encountered. This article describes the way of no repeats statistics for data in a single ...

Excel Array Construction

This article will talk about how to create one-dimensional array or two-dimensional array by using some functions in Excel. When using array formulas in Excel, we often use functions to construct arrays. Generate Array with ROW or COLUMN Functions Array ...

Excel Array Operation

We have all heard of arrays. Depending on the dimensionality, they are divided into one-dimensional arrays and two-dimensional arrays. Depending on the data type, they can also be divided into numeric arrays, logical arrays, and so on. The concatenation and ...

Excel Array Matrix Operation

In Excel, we have a built-in function used to perform matrix operations. It is the MMULT function. This function accepts two arrays as parameters and returns the product of the two arrays. However, this function has a prerequisite that the ...

A1 Reference Style and R1C2 Reference in Excel

In Excel, there are two reference styles. A1 reference style and R1C2 reference style. These two reference styles can help us find the cell by the cell address. Some functions return these two addresses through the argument settings. A1 Reference ...


So empty here ... leave a comment!

Leave a Reply