In this tutorial, you will learn how to set margins in Google Sheets.
When printing data from Google Sheets, it’s important to be able to control the margins so that the printed document has the intended look. Correct margin width can help documents appear more professional, and if you want to leave room for annotations in the margins, it’s helpful to use wider margin widths.
Fortunately, Google Sheets makes setting margins easy. Follow the instructions below to set your spreadsheet’s margins in just a few clicks
Using Margin Presets
Google Sheets comes with three preset margin widths: Normal, Wide and Narrow. Typically, one of these three options will be right for a given spreadsheet. Here’s how to use the presets:
Step 1
In the spreadsheet you want to print, click on the printer icon in the toolbar to open the print settings:
Step 2
The print settings will open, showing a view of your document with a settings panel beside it.
To change the margins, click on the margins dropdown and select the desired margin width
Step 3
You can try all three presets to see which looks best, then click the blue Next button in the upper right corner when you’re happy with your selection to continue through your browser’s printing process
Using Custom Margins
If none of the preset margin widths are right for your spreadsheet, you can set your own custom margins. Here’s how:
Step 1
Open the print settings and choose the Custom Numbers option from the Margins dropdown menu
Step 2
An overlay will appear on the document preview showing separate fields for each of the four margins
Step 3
Click on each margin that you want to edit and type in the new value. The document preview will immediately update to display the new margins
Step 4
When you’re happy with the margins, click the blue Next button
Summary
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to set margins in Google Sheets. Want more? Check out all the Google Sheets Tutorials.