How to easily configure and set margins in Excel

When we work with the Office Excel spreadsheet , we can configure all the inherent aspects of said sheet, and one of them is very important and refers to the margins, today there are still many users who do not know how to make this adjustment correctly. And so that this does not continue to be the case, we present the following tutorial that will explain the steps to follow to easily configure and establish margins in Excel. 

As you already know, when you create a new spreadsheet in Excel, the margins are automatically set, the right one at 1.9 cm and the left margin at 2.5 cm. And the header and footer at 1.2 cm, but these margins can be changed without any problem and only by following the guidelines that we will list below.

This is another perfectly configurable option that Microsoft Excel has and that we offer you in this tutorial, so that you can learn to do it. Just as we have been doing it all this time, and you can see that this option is as functional as giving styles or formatting to tables and cells in Excel.

How to easily configure and set margins in Excel

To start this tutorial you can go directly to the Excel application and create a new spreadsheet to configure the margins. But they can also open an existing file and also make this setting. Once you have the spreadsheet on the screen, the next step is to go to the top menu and select the File tab.

Then you are going to choose the Page setup option, this action will generate a new window on the screen with the name Page setup. With this option you will be able to make adjustments so that the current page shows the margins according to your preferences or specific requirements and in our case you will choose the Margins option.

This will then show a box with various preset margin options, containing a defined margin height width and height. Among those that are offered are, Normal, Narrow and Wide. But you can also find one more option that allows you to place the margin to your liking and this option is Custom margins.

How to modify custom margins in a worksheet in Excel

Selecting this option will display the Page Setup window and the Margins tab will be chosen, where you can set both the left margin, the right margin, the top and bottom margin. As well as the footer and the header, for this it has a series of buttons that when clicking on them will raise or lower the measure.

Also, if you want, you can erase this data that it shows you and enter the exact measure for the margins, headers and footer through the keyboard . Once you have made the adjustments, you can click on the Preview option, so that you have a vision of how your margins will look in the spreadsheet.

Although every time you make an adjustment of each margin in the center of the frame, you will appreciate the changes you are making in real time. Once you are satisfied and the margins have been set correctly, go to the Accept option and click there. Now you just have to close any window or box that has been left open.

You must bear in mind that if the margins that you have already adjusted do not convince you or you simply want to correct them. You can go back to the Page Settings, choose the option of margins and modify those that do not fit your preferences and are just in the printing area .

This is one of the most relevant characteristics of this tool that its settings are not static and can be modified at any time.

And so without anything else to do we have configured the margins in the already existing Excel spreadsheet. But remember that you can also do it before creating your sheet, so that your work fits them. And in this way ends this tutorial that I show you the steps to configure and establish the margins in Excel easily.

 

Leave a Comment