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.
Print Current Worksheet
If you want to print a specific worksheet, follow these steps:
- First, choose the worksheet you want to print from the sheets tab at the bottom of the workbook.
Choose the worksheet. - From the File menu, click on the Print option. Alternatively, use the shortcut Cmd + P (on Mac) or Ctrl + P (on Windows).
Click on the Print option. - Under the Print dropdown, select the Current sheet option.
Click on the Current sheet option. - Click on Next in the top-right corner.
Click on Next.
Print Selected Cells
If you don’t want to print the whole sheet but want a specific range of cells to printed, follow these steps:
- First, select the cells you want to be printed.
Select the range you want to print. - From the File menu, click on Print.
Click on the Print option. - Under the “Print” dropdown, choose the Selected cells option.
Select the Selected cells option. - Finally, click Next in the top-right corner to print the selected cells.
Click on the Next option.
Print Headers on Each Page
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:
- Select the headers.
Select the headers or click on the first row. - 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.
Click on the Freeze option to freeze the first row. - Next, from the File menu, click on Print.
Click on the Print option. - Under the Print dropdown, select Current sheet.
Select the Current sheet option. - 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.
Check the Repeat frozen rows option. - Click on the Next button in the top-right corner.
Click on the Next option.
Print Entire Workbook
To print an entire workbook containing multiple worksheets, do the following:
- From the File menu, click on Print.
Click on the Print option. - Under the “Print” dropdown, select the Workbook option.
Select the Workbook option - Click on the Next button in the top-right corner.
Click on the Next button.