Sowmik Chowdhury
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.
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.
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.
- Now, from Scale to Fit change go to Height.
- After that, change the height to 1 page.
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
- Excel VBA: How to Set Print Area Dynamically (7 Ways)
- How to Center the Print Area in Excel (4 Ways)
- Excel VBA: Set Print Area for Multiple Ranges (5 Examples)
⭐ 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.
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.
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.
- Now, press CTRL + P to check the print preview.
- Finally, you will have an output as shown in the below screenshot.
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.
Steps:
- At the very beginning, go to the Page Layout tab.
- Next, click on Print Area.
- Consequently, select Clear Print Area.
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.
