How to Print Full Page in Excel (4 Simple Ways)

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.

How to Print Full Page in Excel


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.

Apply Fit Sheet on One Page to Print Full Page in Excel

  • A new window will appear. Click on the Print option from that window.

Apply Fit Sheet on One Page to Print Full Page in Excel

  • Another window with different print options will open. Select Fit Sheet on One Page from the Settings.

Apply Fit Sheet on One Page to Print Full Page in Excel

  • 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.

Apply Fit Sheet on One Page to Print Full Page in Excel

  • If everything is ok, you can click on the Print button to print the full worksheet on one page.

Apply Fit Sheet on One Page to Print Full Page in Excel

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.

Use Custom Scaling to Print Full Page in Excel

  • 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.

Use Custom Scaling to Print Full Page in Excel

  • We will see that the entire data range of the worksheet will be printed on a full page.

click on the Print

  • If everything is ok, you can click on the Print button to print the full worksheet on one page.

click on the Print

Read More: How to Print Excel Sheet in A4 Size (4 Ways)


Similar Readings:


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.

Fit and Print All Columns or All Rows 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.

Fit and Print All Columns or 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.

click on the Print

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.

Using Page Break to Print Full Page in Excel

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.

Using Page Break to Print Full Page in Excel

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.

Using Page Break to Print Full Page in Excel

  • Upon clicking the Set Print Area option, Excel will only highlight Page 2 and rename it to Page 1.

Using Page Break to Print Full Page in Excel

Step 4:

  • If we now check the Print Preview, we will see that Excel will only print Page 2.

Print Preview

  • If everything is ok, you can click on the Print button to print Page 2 of the worksheet on one page.

click on the Print

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!!!


Related Articles

ASM Arman

ASM Arman

Hi there! I am ASM Arman. I Completed B.Sc. in Naval Architecture and Marine Engineering. I take a great interest in learning about new technologies and sharing my ideas and thoughts on them with others. Please do reach out to me if you have any queries or recommendations. Have a great day!!!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo