When you’re working in Excel, you may find yourself wanting to print out your spreadsheets. This means that you might want to adjust how your content is positioned relative to the edge of the printed page. Fortunately, this is easy to do. Let’s learn how to change margins in Microsoft Excel.
How to Change Margins in Excel
Margins control how close printed data comes to the edge of a page. By changing margins, you can easily change up the look and feel of an Excel printout. Excel operates with a default set of margins: 0.75 inches on the top and bottom, and 0.7 inches on the left and right. However, you can easily adjust these to any value that you want.
To change margins in Excel, find the Page Layout tab on Excel’s ribbon. Click on it, and you’ll see an array of new options appear on the menu bar. On the left side, you’ll see the Margins dropdown menu. Click on it, and you’ll see the margin control menu open up.
You have multiple options here. Excel has a trio of presets to choose from. The first, Normal, contains the default margin settings mentioned above. Wide offers 1-inch spacing on all four sides. Narrow preserves 0.75-inch top and bottom margins, but measures 0.25-inches on the left and right sides.
If you need more precise control, click on Custom Margins. The Page Setup menu will appear.
This gives you the option to customize and specify exact margin measurements on all four sides. Make adjustments as desired, then click OK.
Excel will apply the new margin settings to your spreadsheet. When you print it out, your content will be arranged on the page accordingly. As you can see, Microsoft Excel makes it easy to change margins. This gives you greater control over your printed spreadsheets.