Try the Excel Course for Free!

Set Margins in Excel – Instructions

/ / Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365

Set Margins in Excel: Video Lesson

            This video lesson, titled “Setting Margins,” shows how to set margins in Excel worksheets. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.”

Set Margins in Excel: Overview

            To set margins in Excel worksheets before printing, open the “Page Setup” dialog box. To open the “Page Setup” dialog box, click the “Page Layout” tab in the Ribbon. Then click the “Page Setup” dialog box button in the lower-right corner of the “Page Setup” button group. Then click the “Margins” tab within the “Page Setup” dialog box.

            You can set the margins in Excel for your worksheet on the “Margins” tab. Use the spinner arrows at the right of each margin’s text box to set the “Top,” “Right,” “Bottom,” and “Left” margins’ widths, in inches. You can also set how far in from the top or bottom edge the header and footer data prints. To do this, enter the desired value into the “Header:” and “Footer:” text boxes.

Set Margins in Excel - Instructions: A picture of the “Margins” tab within the “Page Setup” dialog box in Excel.
Set Margins in Excel – Instructions: A picture of the “Margins” tab within the “Page Setup” dialog box in Excel.

            You can also check the checkboxes under the “Center on page” section to center the worksheet data on the page. To center it horizontally, check the “Horizontally” checkbox. To center it vertically, check the “Vertically” checkbox. After you set margins in Excel and make the other changes you want to apply, click the “OK” button.

Set Margins in Excel: Instructions

  1. To set margins in Excel worksheets before printing, click the “Page Layout” tab in the Ribbon.
  2. Then click the “Page Setup” dialog box button in the lower-right corner of the “Page Setup” button group.
  3. Then click the “Margins” tab within the “Page Setup” dialog box.
  4. Use the spinner arrows at the right of each margin’s text box to set the “Top,” “Right,” “Bottom,” and “Left” margins’ widths, in inches.
  5. To set how far in from the top or bottom edge of the page the header and footer data prints, enter the desired value into the “Header:” and “Footer:” text boxes.
  6. To center the worksheet data on the printed page, check the “Horizontally” and/or “Vertically” checkboxes under the “Center on page” section.
  7. After you set margins in Excel and make the other changes you want to apply, click the “OK” button.
TOP