How to Change Margins in Excel 2010

Fitting a printed spreadsheet on the correct number of pages in Excel 2010 can be a bit of a balancing act. There are several adjustments that you can make to accomplish it, but perhaps one of the most useful and effective is to adjust the size of the margins on the page. Excel 2010 offers a number of simple margin adjustments, but there is also a Custom Margin option where you have complete control over the size of the margins on your page. Continue reading below to learn how to edit margins in excel 2010.

 

How to Adjust Page Margins in Excel 2010

We are going to set up custom margins for the purpose of this tutorial, but we will be passing by the preset margin options in the process of doing so. These options are helpful if you just need to make a slight adjustment to your margins, but some people prefer to have complete control over the elements of their printed page. It is important to note, however, that using margins that are too small may result in your printer being unable to print your spreadsheet. If you get a warning or error message after you attempt to print a spreadsheet with very small margins, you may need to increase them until your printer is able to print them.

 

Step 1: Open the Excel spreadsheet for which you want to adjust the margins.

 

Step 2: Click the Page Layout tab at the top of the window.

click the page layout tab

 

 

Step 3: Click the Margins button in the ribbon at the top of the window, which will expand a drop-down menu.

how to change page margins in excel 2010

 

 

Step 4: Click the Custom Margins option at the bottom of the menu. You will notice that there are several presets on this menu, including the Narrow option, which can be helpful if you are trying to decrease the size of your margins.

click custom margins at the bottom of the menu

 

 

Step 4: Click inside each of the fields in this window for which you want to adjust the margins. Note that I have changed my side margins to .2, and my top and bottom margins to .25. My printer will print pages with margins that small without issue, and it adds a good amount of additional page space over the Narrow option.

enter the desired margin sizes

 

 

Step 5: Click the OK button at the bottom of the window, or click the Print Preview button to see how your page will print with your adjusted margins.

 

 

Read this article to learn how to fit an Excel spreadsheet on one page.

You can also configure a spreadsheet so that it is centered horizontally and vertically when you print it. Read here to learn how.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.