The fastest way to change margins in Excel

Open your spreadsheet, then go to the Page Layout tab (or Layout on Mac). Click Margins in the ribbon — you'll see preset options like Normal, Wide, and Narrow. Click the one you want and you're done. If none of those fit what you need, click Custom Margins at the bottom of that menu to set your own measurements in inches or centimeters.

The margins you set only affect how the sheet prints. They don't change what you see on screen while you're working. If you want to see how your margins will look before you print, use Print Preview: go to File, then Print, and the preview pane on the right shows your actual page layout.

Key Takeaways

  • Margins in Excel are found under the Page Layout tab in the ribbon, in the Margins button.
  • Preset margin sizes (Normal, Wide, Narrow) cover most needs, but you can set custom measurements if you need something different.
  • Changing margins only affects printing — your spreadsheet on screen stays the same.
  • Print Preview shows you exactly how your margins will look on the printed page before you send it to the printer.

Using preset margins for common situations

Excel gives you three built-in margin sizes that work for most documents. Normal margins are 0.75 inches on all sides — the default for most business documents. Wide margins are 1 inch on all sides, useful when you want more white space or need to leave room for binding. Narrow margins are 0.5 inches on all sides, which lets you fit more content on each page.

To use one of these, click the Page Layout tab, then click Margins, then click the size you want. The change takes effect when ready. If you print or use Print Preview right after, you'll see the new margins applied.

Setting custom margins for specific measurements

If the preset sizes don't match what you need, you can set each margin individually. Click Page Layout, then Margins, then Custom Margins at the bottom of the menu. A dialog box opens with fields for Top, Bottom, Left, and Right.

Type the measurement you want in each field. You can use inches (type a number like 1.5) or centimeters (type a number followed by "cm"). When you're done, click OK. Your custom margins are now set for that sheet. If you want the same margins on other sheets in the same workbook, you'll need to set them separately on each sheet.

Changing margins for multiple sheets at once

If your workbook has several sheets and you want them all to have the same margins, you can set them together. Right-click on a sheet tab at the bottom of the screen and select Select All Sheets. Now when you change the margins using Page Layout > Margins, the change applies to every sheet in the workbook.

Be careful with this approach — if your sheets need different margins, you'll have to undo the change and set them one at a time. To deselect all sheets after you're done, right-click any sheet tab and click Deselect All Sheets.

Checking your margins before you print

Print Preview shows you exactly how your spreadsheet will look on paper with the margins you've set. Go to File, then click Print. The right side of the screen shows a preview of your page. Scroll through it to see how your data fits within the margins you chose.

If the margins don't look right, close the Print screen (press Escape or click the back arrow), adjust your margins, and check Print Preview again. This saves you from printing pages that don't look the way you want.

Margins for headers and footers

Headers and footers sit in the margin space at the top and bottom of each page. If you add a header or footer, Excel reserves space for it within your top and bottom margins. You can control how much space the header and footer take up in the Custom Margins dialog.

In the Custom Margins box, look for fields labeled Header and Footer. These show how far down from the top (or up from the bottom) the header and footer sit. If you want your header closer to the edge of the page, lower the Header number. If you want more space between your data and the footer, increase the Footer number.

Margins on Mac Excel

On Mac, the process is almost the same. Click the Layout tab in the ribbon (not Page Layout). Click Margins, then choose a preset size or click Custom Margins to set your own. The Custom Margins dialog works the same way as on Windows — type your measurements and click OK.

Print Preview on Mac is also found under File > Print. The preview pane shows your page layout the same way it does on Windows.

Frequently Asked Questions

Do margin changes affect how my spreadsheet looks on screen?

No. Margins only control how your spreadsheet prints on paper. While you're working in Excel, you see the full spreadsheet without any margin boundaries. The margins become visible only when you print or use Print Preview.

Can I set different margins for different sheets in the same workbook?

Yes. Set margins on one sheet, then click on the next sheet and set different margins there. Each sheet remembers its own margin settings. If you want the same margins on all sheets, select all sheets first, then change the margins once.

What happens to my margins if I save the file and open it later?

Your margin settings are saved with the file. When you open the spreadsheet again, it will use the same margins you set before. If you share the file with someone else, they'll see the same margins unless they change them.

Can I make the margins smaller than 0.5 inches?

Yes. In Custom Margins, you can type any measurement you want — 0.25 inches, 0.1 inches, or even smaller. Keep in mind that very small margins may cause some printers to cut off content, since most printers have a minimum unprintable area around the edges.

How do I reset margins back to the default?

Click Page Layout > Margins and select Normal. This sets all margins back to 0.75 inches on all sides. If you've set custom margins and want to go back to a preset size, this is the quickest way.