How to Manually Change the Margins in Excel 2010


In Microsoft Excel 2010 the margins are not as clear as they are in other applications such as Microsoft Word. This is because Microsoft Excel presents information in a spreadsheet view, which is inherently more suited for on-screen viewing than for printing. Excel spreadsheets can be printed, however. Excel will automatically adjust the print layout, depending on your page sizes, margins and content. If you want more control over your final printed sheet, you can change the margins manually.

  • Open "Microsoft Excel 2010."

  • Press "Ctrl" plus the letter "O." Locate and open an Excel spreadsheet that you want to print.

  • Click "Page Layout" at the top.

  • Click the "Margins" icon and click "Custom Margins" at the bottom of the menu. Set custom margin sizes depending on your requirements. Click "OK."

  • Press "Ctrl" and the letter "P" to open the Print window, which will also show a print preview. If you want to adjust the margins on the page visually, click the "Show Margins" icon, which is the left-most of two small icons in the bottom-right corner of the Print window. Click and drag the margins on the page to change the page layout. Click "Print."


Promoted By Zergnet


You May Also Like

Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!