You can customize how you print a spreadsheet with margins, page breaks, headers, footers, and more options.
Print a spreadsheet, single sheets, or cells
- On your computer, open a spreadsheet at sheets.google.com.
- If you want to print part of a spreadsheet, select the cells or sheet.
- At the top, click File
Print.
- Click Current sheet.
- To print the full spreadsheet, click Workbook.
- To print the cells you chose in step two, click Selected cells.
- To print the sheet you chose in step two, click Current sheet.
- 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
- On your computer, open a spreadsheet at sheets.google.com.
- At the top, click File
- Click Set custom page breaks.
- 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
.
- To remove a page break, point to a line and click Remove
- When you’re done, click Confirm breaks.
.Format margins, headers, footers, or page settings
Change margins
- On your computer, open a spreadsheet at sheets.google.com.
- At the top, click File
- Under "Margins," click Normal. Choose a margin type.
- To customize your margins, click Custom numbers. Enter new margin numbers.
Customize headers or footers
- On your computer, open a spreadsheet at sheets.google.com.
- At the top, click File
- Click Headers & footers.
- Choose what info you want to include.
- To change the format or location of the header or footer, click Edit custom fields. Make your changes and click Confirm​.
Repeat rows or columns across pages
You can repeat frozen rows or columns across a printed spreadsheet’s pages.
- On your computer, open a spreadsheet at sheets.google.com.
- If you haven’t already, freeze a row or column.
- At the top, click File
- Click Headers & footers.
- Choose Repeat frozen rows or Repeat frozen columns.
Change page orientation or paper size
- On your computer, open a spreadsheet at sheets.google.com.
- At the top, click File
- Under “Orientation,†choose Landscape or Portrait.
- Under “Paper size,†choose the size of paper you want to print on. To add a custom paper size, choose Custom size and enter a height and width.