Step 2: Click the Page Layout tab at the top of the window. Step 1: Open the Excel spreadsheet for which you want to adjust the margins. 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. It is important to note, however, that using margins that are too small may result in your printer being unable to print your spreadsheet. 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. 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.
#HOW TO CHANGE MARGINS ON ONE PAGE HOW TO#
How to Change the Margins in Excel 2010 (Guide with Pictures) Our tutorial continues below with additional information on changing margins in Excel 2010, including pictures of these steps.
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.Įxcel 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. But you can change your page margins in Microsoft Excel, too, if you discover that your printed spreadsheet requires adjustments.įitting a printed spreadsheet on the correct number of pages in Excel 2010 can be a bit of a balancing act. Many schools and organizations have strict document requirements, and document page margins are often a part of those requirements.
Now we need to specify our desired margins for the other pages of that chapter.Ģ1- Specify your desired margin for the first page.Ģ4- Repeat steps 10 to 24 for other chapters.Microsoft Office users often have experience with changing page margins in their documents, although that experience is likely with Microsoft Word rather than Microsoft Excel.