Changing Margins in Excel 13

In Page Layout view, we can check out the Margins of our Spreadsheet in order to see where the page starts and where it ends. We can also use the Excel Backstage View and the Print Preview on the right side of the Print pane in order to check out the Margins. What happens though when we want to adjust and change the Margins of our Spreadsheet? All we have to do is to follow the steps described below.

First, we must select the Page Layout tab and then from the area of the ribbon named Page Setup we select the Margins command as shown in the image below. Once the Margins command is selected, the drop down menu appears with all the default Margins that we can use. The default Margins that we can use followed by the measurements are the following:

  • Normal
  • Wide
  • Narrow

All we have to do in order to use one of the default Margins, is to just click on one of the above and the Margins of our spreadsheet will change according to the measurements of the selected Margins.

Page Layout - Margins

If we do not want to use one of the default Margins, but to create a Custom Margin, we just select the command Custom Margins from the drop down menu as shown above, and straight away the Page Setup dialog box appears with the Margins tab activated as shown in the image below.

In this dialog box we can create our Custom Margins, just by selecting the Up and Bottom arrows next to the Top, Bottom, Left and Right commands, to the measurements that we want. In this dialog box we can also adjust the measurements that we want for the Header and Footer we need for our Spreadsheet.

Margins

On the Page Setup dialog box and on the Margins tab, and under the area named Center on Page, we can also adjust how our data will be displayed on our Spreadsheet when we print it. We can Center on Page our data Horizontally and Vertically just by activating the appropriated check boxes next to the commands.  All the adjustments will  be visible only in Backsgtage View or on the printout version.

Center On Page

Whatever changes we do, we have to press the OK button at the end in order for all the adjustments to take place.

Below you can check out the video describing how to change the Margins of our Spreadsheet in Excel 13.

Changing Margins in Excel 13

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on April 22, 2015, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Changing Margins in Excel 13.

Comments are closed.