Sunday, August 14, 2011

How to Set Margins in Excel


1. Start Microsoft Excel and open an existing spreadsheet on which you would like to set the margins.
2. 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.
3. 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.
4. 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.
5. 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.
6. Notice as you update each margin the preview in the center of the screen will change to reflect your new margin settings.
7. 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.

Blogger news