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 configure and set margins in Excel easily.
As you already know, when you create a new spreadsheet in Excel, the margins are automatically set, the right margin 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 you have Microsoft Excel and that we offer you in this tutorial, so you can learn how 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 application of Excel and create a new spreadsheet to set 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 option Configure page, 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.
A box will then be displayed with various preset margin options, containing a defined margin height width and height. Among those that are offered to you 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.
You may also be interested in:
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 margins. As well as the footer and the header, for this it has a series of buttons that when clicked on them will raise or lower the measure.
Also, if you want, you can delete 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 be seen 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 agree and the margins have been set correctly, go to the OK 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. They can go back to the Page Settings, choose the margins option and modify those that do not suit your preferences and are just in the printing area.
This is one of the most relevant features of this tool that its settings are not static and can be changed at any time.
You may also be interested in:
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 set margins in Excel easily.
I'm sorry this content was not useful for you!
Let me improve this content!
Tell me, how can I improve this content?