How To Set Margins In Google Sheets

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


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.