Adding paper size in Excel is needed when you want to print your Excel sheet. In this article, I will explain how to add paper size in Excel. I will explain 4 different ways of doing it.
4 Easy Ways to Add Paper Size in Excel
Here, I have taken the following dataset to explain this article. The dataset contains a Sales Overview.
1. Using the Page Layout Tab to Add Paper Size in Excel
In this method, I will explain how to add paper size in Excel using the Page Layout tab.
Let’s see the steps.
Steps:
- Firstly, go to the Page Layout tab from the Ribbon.
- Secondly, select Size.
A drop-down menu will appear.
- Now, select the Page Size you want from the drop-down menu. Here, I selected A5.
- After that, go to the File tab.
- Next, select Print.
Now, you will be able to see the Print Preview. Here, you can see how the page will look on the selected Page Size after printing.
Read More: How to Print Full Page of Excel Sheet in A4 SizeÂ
2. Use of Print Option to Add Paper Size in Excel
In this method, I will explain how you can add Paper Size in Excel by the use of the Print option.
Let’s see the steps.
Steps:
- Â Firstly, go to the File tab.
- Secondly, select the Print option.
- Thirdly, select the drop-down option for Page Size.
Now, a drop-down menu will appear.
- Next, select the Page Size you want. Here, I selected Statement.
Here, in the Print Preview, you can see how the page will look on the selected Page Size after printing.
Read More: How to Adjust Page Size for Printing in Excel
3. Employing Page Setup Feature to Add Paper Size in Excel
In this method, I will explain how you can employ the Page Setup feature to add Paper size in Excel.
Let’s see the steps.
Steps:
- Firstly, go to the Page Layout tab.
- Secondly, select the dialog box option from Page Setup.
Now, you will see the dialog box named Page Setup.
- Firstly, go to the Page tab.
- Secondly, select the drop-down button from Paper size.
Here, a drop-down menu will appear.
- Next, select the Paper size you want from the drop-down menu. Here, I selected A3.
- After that, select Print Preview.
Now, in the Print Preview, you can see how the page will look on the selected Page Size after printing.
Read More: How to Add A3 Paper Size in ExcelÂ
4. Adding Custom Paper Size
In this method, I will explain how you can add a custom Paper Size.
Let’s see the steps.
Steps:
- Firstly, search for Printers & scanners in your Windows Search.
- Secondly, select Printers & scanners.
Now, your Printers & scanners settings will open.
- After that, select your printer. Here, I selected my printer which is HP LaserJet Pro M12w.
- Next, select Manage.
- After that, select Printing preferences.
Now, you will get a dialog box.
- Next, select Custom to make a custom size.
Custom Paper Size dialog box will appear.
- Firstly, write the Name for your custom size.
- Secondly, select the Width.
- Thirdly, select the Height.
- Finally, select Save.
Now, go to your Excel file.
- Firstly, select the File tab.
- Secondly, select Print.
- Thirdly, select the Printer where you set your custom size.
- After that, select the drop-down option for Page Size.
Now, a drop-down menu will appear.
- Next, select the custom Page Size you want. Here, I selected new size (which I created earlier).
Here, in the Print Preview, you can see how the page will look on the selected Page Size after printing.
Read More: Why Is My Excel Sheet Printing So SmallÂ
💬 Things to Remember
- It should be noted that the custom page size is not a feature of Excel.
- To customize the paper size you will need a Printer connected to your device.
Practice Section
Here, I have provided a practice sheet for you to practice how to add paper size in Excel.
Download Practice Workbook
Conclusion
To conclude, I tried to explain how to add page size in Excel in this article. I covered 4 different methods of doing it. I hope this was helpful for you. If you have any questions, feel free to let me know in the comment section below.