How To Set The Print Area In Google Sheets

To do that, you’ll have to first learn how to set the print area in Google Sheets.

Set the Print Area to Only Print Select Cells

If you have your data only in specific cells in your worksheet, you can configure an option so that Google Sheets only prints those select cells.

Set the Print Area to Print the Entire Sheet

If your workbook has multiple worksheets, and you’d like to print a specific worksheet, you can get Google Sheets to do that.

Set the Print Area to Print the Entire Workbook

Sometimes, you may want to print your entire Google Sheets workbook, which could include multiple worksheets. Google Sheets has an option to do that, too. When you print an entire workbook, make sure your printer has enough ink to print your data. Also, feed enough paper into your printer’s paper tray to ensure there’s no interruption when you print your workbook.

Set the Print Area to Print Headers on Each Page

If your Google Sheets data is spread across multiple pages, you may want to include the headers on each page that you print. This makes reading the data easier as you know exactly what column is for what data on each page. To print column headers on each page, you’ll first freeze the header row:

Customize the Print Area With Custom Page Breaks

You can add custom page breaks to your Google Sheets worksheets to let your printer know where to stop printing a page and start a new page. To add a page break in your worksheet:

It’s Easy to Customize and Set the Print Area in Google Sheets

Google Sheets offers you the flexibility to print whatever part of your workbook you want. This way, you can focus on the main data that you’d like to print while leaving everything else out. We hope this guide helps you out.