How to Set Margins in Excel

By eHow Computers Editor

Rate: (2 Ratings)

A margin refers to the amount of space between the content on your page and the edge of the page you print. Microsoft Excel automatically sets your top and bottom margins at 1 inch left and right at .75 inch and header and footer at .5 inch. You can change these margins by following the steps below to access the "Page Setup" dialog box.

Instructions

Difficulty: Easy

Things You’ll Need:

  • Microsoft Excel 2003

Step1
Start Microsoft Excel and open an existing spreadsheet on which you would like to set the margins.
Step2
Choose the "File" menu and click "Page Setup" to open the "Page Setup" dialog box. The "Page Setup" dialog box can be used to set up your page just how you would like it to appear.
Step3
Click on the "Margins" tab at the top of the "Page Setup" dialog box to show the margins for the spreadsheet that you currently have option.
Step4
Set the "Left," "Top," "Right," "Bottom," "Header" and "Footer" margins by clicking within the text box underneath each option to highlight the current margin setting.
Step5
Type a new measurement for whichever margins you would like to change or use the arrows to move up and down throughout the measurements you can select for each option.
Step6
Notice as you update each margin the preview in the center of the screen will change to reflect your new margin settings.
Step7
Use your mouse to click the "OK" button to close the "Page Setup" dialog box and set the margins you have chosen for your current Excel spreadsheet.

Post a Comment

POST A COMMENT

Request a New How-To Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article:  How to Set Margins in Excel

eHow Computers Editor

eHow Computers Editor

Category: Computers

Articles: See my other articles

Related Ads