How to Add Paper Size in Excel (4 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

4 Easy Ways to Add Paper Size in Excel


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.

Using the Page Layout Tab to Add Paper Size in Excel

  • After that, go to the File tab.

Using the Page Layout Tab to Add Paper Size in Excel

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

Using the Page Layout Tab to Add Paper Size in Excel

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.

Use of Print Option to Add Paper Size in Excel

  • Thirdly, select the drop-down option for Page Size.

Use of Print Option to Add Paper Size in Excel

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.

Use of Print Option to Add Paper Size in Excel

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.

Employing Page Setup Feature to Add Paper Size in Excel

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.

Employing Page Setup Feature to Add Paper Size in Excel

Now, in the Print Preview, you can see how the page will look on the selected Page Size after printing.

Employing Page Setup Feature to Add Paper Size in Excel

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.

Adding Custom Paper Size

  • After that, select Printing preferences.

Now, you will get a dialog box.

  • Next, select Custom to make a custom size.

Adding Custom Paper 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.

Adding Custom Paper Size

Now, go to your Excel file.

  • Firstly, select the File tab.

  • Secondly, select Print.

  • Thirdly, select the Printer where you set your custom size.

Adding Custom Paper 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.


Related Articles

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mashhura Jahan
Mashhura Jahan

Mashhura Jahan, BSc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology, invested 1.5 years at ExcelDemy. In roles like Excel & VBA Content Developer, Excel Charts, and Dashboard course trainer, she wrote 90+ articles. She was previously part of the forum support team and a junior software analyst on the Excel Add-in project. With interests spanning Excel, VBA, Power Query, Python, Data Science, and Software Development, Mashhura brings a diverse skill set to her... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo