Sometimes when you have a spreadsheet that you need to print in Office 365, it might seem like the margins surrounding your data are much too large. This reduces the amount of information that you can fit on the page, and often results in creating printed documents that are much longer than they need to be.
One way to fix this issue and fit more rows and columns on the page is to use the narrow margins option in Excel instead. Our tutorial below will show you where to find that setting so that you can try it out and see if that provides more appealing margin sizes for your spreadsheet.
How to Make Margins Smaller in Excel for Office 365
The steps in this article were performed on the Excel version that comes with the Office 365 subscription. However, these steps are very similar in most of the modern versions of Excel, such as Excel 2010 and Excel 2013.
Step 1: Open your file in Excel for Office 365.
Step 2: Click the Page Layout tab at the top of the window.
Step 3: Click the Margins button.
Step 4: Choose the Narrow option to switch your spreadsheet’s layout to the margin sizes shown for that option.
Note that if you find these margins to be either too big or too small you can elect to use the Custom Margins option at the bottom of the menu instead, where you can manually specify the size of your margins.
If you’re having trouble printing your spreadsheet, then this article may be helpful. It describes how to automatically adjust the print scale so that all of your columns fit on the page when you go to print.