If you are working with a large worksheet that has a lot of columns or rows, then you will find out that you can not print the entire worksheet on one page. But changing some settings in Excel, you can print the entire worksheet on a single page. In this tutorial, I will show you how to print full page in Excel.
Download Practice Workbook
Download this practice book to exercise the task while you are reading this article.
4 Suitable Methods to Print Full Page in Excel
Let’s assume a scenario where we have an Excel worksheet that contains information about the employees of a company. We will print the entire worksheet on a single page. The image below shows how the worksheet will look if we print the entire worksheet on one page.
1. Apply Fit Sheet on One Page to Print Full Page in Excel
We can use the Fit Sheet to One Page option from the Print option in Excel to print the full page in Excel.
Steps:
- First, we will click on the File.
- A new window will appear. Click on the Print option from that window.
- Another window with different print options will open. Select Fit Sheet on One Page from the Settings.
- If you now check the Print Preview, you will see that the entire data range of the worksheet will be printed on a full page.
- If everything is ok, you can click on the Print button to print the full worksheet on one page.
Read More: How to Print Selected Area in Excel on One Page (3 Methods)
2. Use Custom Scaling to Print Full Page in Excel
Along with changing the Settings on the Print option, you can also use the Custom Scaling option of Excel to print full page in Excel.
Steps:
- First, We will have to click on the dialogue box launcher tool icon on the down-right corner of the Page Setup section under the Page Layout tab like the image below.
- A new window titled Page Setup will appear. We will click on the Page tab from that window.
- Then, we will select the Fit to 1 page(s) wide by 1 tall under the scaling option.
- Now, we will click on the Print Preview from that window.
- We will see that the entire data range of the worksheet will be printed on a full page.
- If everything is ok, you can click on the Print button to print the full worksheet on one page.
Read More: How to Print Excel Sheet in A4 Size (4 Ways)
Similar Readings:
- How to Print Landscape in Excel (3 Easy Methods)
- How to Print to PDF in Excel VBA : With Examples and Illustrations
- Excel VBA: How to Set Print Area Dynamically (7 Ways)
- How to Set a Row as Print Titles in Excel (4 Methods)
- Print Titles in Excel Is Disabled, How to Enable It?
3. Fit and Print All Columns or All Rows on One Page
If we only need to print all the columns or all the rows of a worksheet instead of the full worksheet, then we can do so by changing the Settings on the Print option.
Steps:
- We will select Fit All Columns on One Page under the Settings section in the Print option if we want to print all columns on one page.
- Instead of all the columns, if we only want to print all the rows of an Excel worksheet, then we will select Fit All Rows on One Page to print all rows on one page.
- Upon clicking the Fit All Rows on One Page, if we now check the Print Preview, we will see that Excel will print all the rows but only 3 columns of the worksheet on a single page.
Read More: How to Fit to Page and Print in Excel (10 Ways)
4. Using Page Break to Print Full Page in Excel
We can use the Page Break options in Excel to break a large worksheet into small pieces to print it more conveniently.
Step 1:
- First, we will click on the View We will then select the Page Break Preview option from the Workbook Views section.
- Now, we will see that Page 1 is written on the worksheet in transparent black color. That means our worksheet has not been broken into smaller pieces yet.
- We will also see blue color border encircling the worksheet. These blue color lines indicate the demarcation line where the worksheet will be broken into smaller pages.
Step 2:
- If we now drag the handle (2 sided arrow), we will see that the worksheet will be broken into multiple pages depending on where we place the handle.
Step 3:
- We will now select a cell on the segment titled Page 2 and right-click on it.
- A window with different options will appear. We will click on the Set Print Area So, Excel will only print Page 2 as it is now our print area.
- Upon clicking the Set Print Area option, Excel will only highlight Page 2 and rename it to Page 1.
Step 4:
- If we now check the Print Preview, we will see that Excel will only print Page 2.
- If everything is ok, you can click on the Print button to print Page 2 of the worksheet on one page.
Related Content: How to Print Gridlines in Excel (2 Ways)
Things to Remember
- While using the Page Break to break a worksheet into smaller pages, you should select No Scaling instead of Fit Sheet on One Page from the Settings section in the Print option.
- You can press CTRL+P to activate the Print feature of Excel.
Conclusion
In this article, we have learned to print full page in Excel. Along with that, we also learn to print all columns and rows of an Excel worksheet in Excel. I hope from now on you can print full page in Excel very easily. However, if you have any queries or recommendations about this article, please do leave a comment below. Have a great day!!!