How to Set Print Area to One Page in Excel (with Easy Steps)

In many cases, you may need to set the print area to one page in your Excel file. You can do this task in Microsoft Excel within seconds. This article demonstrates how to set the print area in Excel to one page in 3 quick steps. Moreover, this article also discusses how to modify the print area on a page and how to clear the print area from a page.


Download Practice Workbook

You can download the practice workbook from the link below.


3 Steps to Set Print Area to One Page in Excel

Let’s assume you have a dataset where you have a lot of rows and columns as shown in the screenshot below. Now, you want to set a print area to one page from this worksheet or dataset. You can easily do this by following the 3 easy steps mentioned below.

3 Steps to Set Print Area to One Page in Excel

We have used Microsoft Excel 365 version for this article, you can use any other versions according to your convenience.


⭐ Step-01: Select Cells to Set Print Area

In this step, we will select the cells we want to set as the print area and then assign the print area. Here, we want the range B4:G16 as our print area.

  • First, select the range B4:G16.
  • Then, go to the Page Layout tab.
  • After that, click on Print Area.
  • Consequently, select Set Print Area.

Select Cells to Set Print Area

Eventually, you will finish selecting cells to set the print area.

Read More: How to Print Selected Area in Excel (2 Examples)


⭐ Step-02: Set Print Area to One Page in Excel

Now, in this step, we will set the print area to one page. We will do this by scaling the width and height of the print area to fit one page.

  • First, go to the tab Page Layout.
  • Next, from Scale to Fit change go to Width.
  • After that, change the width to 1 page.

Set Print Area to One Page in Excel

  • Now, from Scale to Fit change go to Height.
  • After that, change the height to 1 page.

Set Print Area to One Page in Excel

Consequently, you will finish setting your print area to one page in Excel.

Read More: How to Print Selected Area in Excel on One Page (3 Methods)


Similar Readings


⭐ Step-03: Check Print Preview

Finally, in this step, we will check the print preview. This is a very important step before printing because sometimes we may make some mistakes while setting our print area.

  • Now, to check the print preview press CTRL + P.
  • Lastly, you will have your output as shown in the below screenshot.

Check Print Preview

Read More: How to Set Print Area to Selection Using VBA in Excel (3 Methods)


How to Modify Print Area of a Page in Excel

Now, suppose you want to modify your print area by adding some more columns to it. In this case, you want to add range H4:K16 to your previous print area. In Microsoft Excel, you can easily do this. At this point, to do so follow the steps below.

Modify

Steps:

  • First, select the range H4:K16.
  • Next, go to the Page Layout tab.
  • After that, click on Print Area.
  • Consequently, select Add to Print Area.

Modify

  • Now, press CTRL + P to check the print preview.
  • Finally, you will have an output as shown in the below screenshot.

How to Modify Print Area in a Page in Excel

Read More: How to Change Print Area in Excel (5 Methods)


How to Clear Print Area from a Page in Excel

Let’s assume now you have a print preview as shown in the below screenshot. But, you want to clear the print area. You can easily do this in Excel. Now, to do so follow the below steps.

 Clear Print Area

Steps:

  • At the very beginning, go to the Page Layout tab.
  • Next, click on Print Area.
  • Consequently, select Clear Print Area.

How to Clear Print Area in a Page in Excel

Eventually, you will clear your print area and set it to default.


Conclusion

In this article, we see how to set the print area in Excel to one page. Moreover, we discuss how to modify the print area on a page and also how to clear the print area from a page. Last but not least, I hope you found what you were looking for from this article. If you have any queries, please drop a comment below. Also, if you want to read more articles like this, you can visit our website  ExcelDemy.


Related Articles

Sowmik Chowdhury
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo