How to Remove Print Margins in Excel (3 Quick Tricks)

An individual might need to print some Excel data on a piece of paper. To do that, Excel worksheets need to be properly aligned to the printing page to get the printed copy in the desired format. For this purpose, one might need to change margins, customize margins, or delete margins. In this article, we will show you how to remove print margins in Excel using 3 quick tricks.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


3 Suitable Methods to Remove Print Margins in Excel

In this article, we will learn how to remove print margins in Excel in 3 quick methods. We will use the following dataset to demonstrate these methods.

how to remove print margins in Excel


1. Use Print Area Tool

In the first method, you will see how to use the Print Area Tool to remove print margins in Excel. Read the following steps to learn.

Steps:

  • First, go to the Page Layout tab and click Print Area.
  • Next, select Clear Print Area.

Use Print Area tool remove print margins in Excel

  • This will remove the print margins from the Excel sheet.

Read More: How to Change Page Margins to Wide in Excel


2. Uncheck Show Page Break Option

Now, you will learn to remove the print margins by unchecking the Show Page Break option. To do that, follow the steps given below:

Steps:

  • First of all, click on the File tab.

Use show page break to remove print margins in Excel

  • Then select Options from the bottom left corner of the window.

Use show page break to remove print margins in Excel

  • You will find several options now. Select the Advanced option from there.
  • Then scroll down until you find Display options for this worksheet.

Use show page break to remove print margins in Excel

  • Now uncheck the box of Show Page Break.

Use show page break to remove print margins in Excel

  • After that, go back to the worksheet and you will see that the margins have disappeared.

Read More: [Fixed!] Excel Margins Disappeared (4 Possible Solutions)


3. Run a VBA Code

In this method, we will demonstrate the use of VBA code to remove margins in Excel. Keep on reading to learn the procedure.

Steps:

  • First, go to the Developer tab and select Visual Basic. The Visual Basic window will pop up.
  • You can also open the Visual Basic window using a keyboard shortcut. Just press Alt+F11.

Use VBA code to remove print margins in Excel

  • In the window, click on the Insert tab and then select Module. It will open a window to write VBA code.

Use VBA code to remove print margins in Excel

  • Next, copy and paste the following VBA code into the window.
Sub Runme()
ActiveSheet.DisplayPageBreaks = False
End Sub
 Use VBA code to remove print margins in Excel
  • To get back to the Excel sheet, click on the File tab and then Close and Return to Microsoft Excel.

  • Now we will run the VBA code. To do that, go to the Developer tab and select Macros from the ribbon. A pop-up box will appear.
  • Or you can open the pop-up box by pressing Alt+F8.

Use VBA code to remove print margins in Excel

  • In the pop-up box, click on Run.

Use VBA code to remove print margins in Excel

  • The code will run and the margins from the Excel sheet will be removed.

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


Things to Remember

  • If you don’t have the Developer tab, just use the shortcut keys as described in the third method.
  • Make sure you have the latest version of Excel as some of the methods might not work in the older version.

Concluding Remarks

Thanks for making it this far. I hope you find this article useful. Now you know 3 quick tricks for removing print margins in Excel. Please let us know if you have any further queries and feel free to give us any recommendations in the comment section below.


Related Articles

Alif Bin Hussain

Alif Bin Hussain

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was Civil Engineering from Bangladesh University of Engineering & Technology (BUET). I am a fresh graduate with a great interest in research and development. I do my best to acquire new information and try to find out the most efficient solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo