Print from Google Sheets

You can customise how you print a spreadsheet with margins, page breaks, headers, footers and more options.

Print a spreadsheet, single sheets or cells

1. On your computer, open a spreadsheet at sheets.google.com.
2. If you want to print part of a spreadsheet, select the cells or sheet.
3. At the top, click File Print.
4. Click Current sheet.
   • To print the full spreadsheet, click Workbook.
   • To print the cells that you chose in step two, click Selected cells.
   • To print the sheet thatyou chose in step two, click Current sheet.
5. Click Next.
   • If you’re using Chrome, click Print in the window that appears.
   • If you’re using Firefox or Safari, a PDF file will automatically download. In your PDF viewer, go to File  Print.

Insert page breaks

1. On your computer, open a spreadsheet at sheets.google.com.
2. At the top, click File Print.
3. Click Set custom page breaks.
4. Drag the lines to where the page should break. Each rectangle will print on its own page.
   • To remove a page break, point to a line and click Remove .
5. When you’ve finished, click Confirm breaks.

Format margins, headers, footers or page settings

Related articles

• Print or change page setup
• Edit and format a spreadsheet
• Edit rows, columns and cells in a spreadsheet