How to Set Print Area in Google Sheets

You might want to only print part of your Google Sheets spreadsheet or the whole spreadsheet but align it in a certain way. Google Sheets gives you multiple ways to customize print areas. This guide shows you how.

If you want to print a specific worksheet, follow these steps:

  1. First, choose the worksheet you want to print from the sheets tab at the bottom of the workbook.

    Select Worksheet
    Choose the worksheet.
  2. From the File menu, click on the Print option. Alternatively, use the shortcut Cmd + P (on Mac) or Ctrl + P (on Windows).

    Print
    Click on the Print option.
  3. Under the Print dropdown, select the Current sheet option.

    Current Sheet
    Click on the Current sheet option.
  4. Click on Next in the top-right corner.

    Next
    Click on Next.

If you don’t want to print the whole sheet but want a specific range of cells to printed, follow these steps:

  1. First, select the cells you want to be printed.

    Select the cells
    Select the range you want to print.
  2. From the File menu, click on Print.

    Print
    Click on the Print option.
  3. Under the “Print” dropdown, choose the Selected cells option.

    Selected Cells
    Select the Selected cells option.
  4. Finally, click Next in the top-right corner to print the selected cells.

    Next
    Click on the Next option.

If your data is spread across multiple pages, you might want to keep the headers on each page. It makes the printed data more readable as you know what particular data refers to. To print data with headings on each page, do the following:

  1. Select the headers.

    Select the cells
    Select the headers or click on the first row.
  2. From the View menu, choose the Freeze option. From the sub-menu, select the 1 Row option. It will freeze the pane and keep the header intact throughout the sheet.

    Freeze
    Click on the Freeze option to freeze the first row.
  3. Next, from the File menu, click on Print.

    Print
    Click on the Print option.
  4. Under the Print dropdown, select Current sheet.

    Current Sheet
    Select the Current sheet option.
  5. Click on the Headers & footers section on the right. Then, under the “Row & column headers” sub-section, check the Repeat frozen rows option. You’ll notice that the header is now on each on each page.

    Repeat Frozen Rows
    Check the Repeat frozen rows option.
  6. Click on the Next button in the top-right corner.

    Next
    Click on the Next option.

To print an entire workbook containing multiple worksheets, do the following:

  1. From the File menu, click on Print.

    Print
    Click on the Print option.
  2. Under the “Print” dropdown, select the Workbook option.

    Workbook
    Select the Workbook option
  3. Click on the Next button in the top-right corner.

    Next
    Click on the Next button.

Was this article helpful?

Leave a Comment