Default Print Margins in Excel: Complete Guide

1. INTRODUCTION TO THE DEFAULT PRINTING TRIPLE IN Excel

Today TipsMake will guide you a very interesting trick that is the default alignment when printing in Excel . This trick if you search on google you can hardly find. This article will be attached to the video (https://www. YouTube. com/watch? v=befmtkhuo2s) so you should watch the video to make the steps simpler.

Unlike the default alignment algorithm in Word - which is quite easy, in Excel the method is a bit more complicated.

First I will demo for you that do not know about the alignment feature when printing in Excel.

For example, I open an Excel file as you can see, "normal" in "margins", in "page layout" tab is the default margin when printing in Excel:

Now suppose you may need to adjust the left margin before printing wider

For example, to 2 cm, not 0.75 cm as the default anymore to make the page look more beautiful. For example, in the custom margins section you selected is 2cm, do you see the change?

Now the problem is, that setting will always change. So want to change to the default you follow these steps:

2. DEFAULT BACKGROUND STEPS IN Excel

B1: Create a new Excel file

B2: Reinstall top, bottom, left and right margins in page layout- margins - custom margins, for example, I set the left margin to 2.

B2: Ok - you press f12 -> in the save as type section select Excel template (* xltx) - then you need to select the saved folder in the "xlstart" folder. because in each machine it may be in a different location so I encourage you to use the search feature of Windows to find.

B3: After determining the location of that directory, you copy the link and put in the save as:

-> As here is his: c: program files (x86) microsoft officeoffice14xlstart

Note that when you press save may present a message about administrative rights, in this case you should save to the desktop and then copy to the path containing the following xlstart

B4: Ok after the movie, you go back to Excel try it out.