How to Change Page Margins to Wide in Excel

In this article, I will show you how to change page margins to wide in Excel. While working on an Excel workbook, sometimes you may need to plot any dataset on paper to make a printout copy. In Excel, you can easily plot any dataset on a page. But there are some issues to be fixed while plotting on papers in Excel. You need to set margins before printing the dataset. I hope this will make you more expert in Excel. Follow the procedures of two methods. Moreover, I have added necessary illustrations with every step of the procedures.


Download Practice Workbook

Please download the workbook to practice yourself.


2 Effective Ways to Change Page Margins to Wide in Excel

In this article, I will consider the following dataset to change page margins to wide in Excel. In this dataset, you can see that there are four columns, B, C, D, and E called ID, Products, Price, and Delivery Date. The dataset ranges from B4 to E12. Though the dataset has the least work here, I will use this dataset where it is needed. From here, I will describe the procedures step by step. Follow the steps one by one.

Dataset to change page margins to wide in excel


1. Use Page Layout Tab to Change Page Margins to Wide in Excel

This is the first method of this article. Here I will use the Page Layout tab to change page margins in Excel. This is an easy way. Follow the instructions carefully. However, I have added images with every step for your better understanding.

Steps:

  • First, select the Page Layout tab on your toolbar.

Use Page Layout Tab to Change Page Margins to Wide in Excel

  • Then, select the Margins option under the Page Layout option.

Use Page Layout Tab to Change Page Margins to Wide in Excel

  • Meanwhile, a pop-up window will appear.
  • Then, select the wide option from the pop-up window.
  • After selecting this option, Excel will plot the dataset on a paper with a wide margin.

Use Page Layout Tab to Change Page Margins to Wide in Excel

This is how you can change page margins in Excel by using the Page Layout tab.

Read More: How to Apply Margin Setting in Excel (2 Handy Approaches)


2. Change Page Margins to Wide in Excel by Using Print Option

This is the last method of this article. I will show you the procedures for changing page margins to wide in Excel using the Print option. Follow the step-by-step procedures of this method.

Steps:

  • First, select the File option in your toolbar.

Change Page Margins to Wide in Excel by Using Print Option

  • Then, select the Print option.

Change Page Margins to Wide in Excel by Using Print Option

  • Under the print option, you will find the margins option. Click on it.

  • After that, select the Wide Margins

  • Then, you will find a preview of how the dataset will be printed on a page.
  • By following these steps, Excel will add a wide margin to your page.

This is how a page margin can be changed to wide in excel by using the Print option.

Read More: [Fixed] Excel Margins Not Printing Correctly (6 Possible Solutions)


Things to Remember

  • You can also change the margins to a normal or narrow shape.

Conclusion

In this article, I have explained the procedures to change page margins to wide in excel. I hope you have learned something new from this article. Now, extend your skill by following the steps of these methods. You will find such interesting blogs on our website ExcelDemy.com. I hope you have enjoyed the whole tutorial. If you have any queries, feel free to ask me in the comment section. Don’t forget to give us your feedback.


Related Articles

Souptik Roy

Souptik Roy

Hello there. This is Souptik Roy. I graduated from Naval Architecture & Marine Engineering department. I am trying to explore the world of Microsoft Excel and want to increase my analytical power apart from my Engineering degree, as I have a curious mind. this is why I am trying to learn Excel Operations and write articles to help others.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo