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.
Choose the desired page margins for your printed spreadsheet.Continue reading below to learn how to edit margins in excel 2010.Ĥ More Information on How to Change Page Margins in Excel 2010 How to Adjust Margins in Excel 2010 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. Click on the arrow and choose “This section”.In this method, you should create a section for each part which you want to have different margins.ġ- place the cursor at the end of the first line of the first page of your chapter.ĥ- Place the cursor at the end of that chapter.ġ0- Click on the first line of your desired chapter.ġ4- Specify your desired margin for the first page. How to Set Different Page Margins with Page Break.
for that you can follow one of these methods How to Set Different Page Marginsġ- Place the cursor on the page of your desired chapter.Ħ- In the Margin section modify the margins of your page.Ĩ- Place the cursor at the end of the first page.ġ2- Specify your desired margin for other pages of your chapter.ġ3- In the “Apply to” part click on the arrow.ġ5- Place the cursor at the beginning of the other chapters.ġ6- Repeat steps two to fourteen for each chapter. Sometimes you need to have different margins for your document, for instance, here we want to have a different margin for the first page of each chapter and, for other pages of each chapter define different margin.
0 kommentar(er)
