In this tutorial, we will share a couple of methods to set the Print Area.
2 Ways to Set Print Area in Google Sheets
- Setting Selected Cells as Print Area
- Setting The Current Sheet or Workbook as Print Area
Method 1: Set Selected Cells as Print Area
Step 1: Open up your Google Sheets document.
Step 2: Select the cells you want to print.
Once your spreadsheet is ready, carefully select the portion of the spreadsheet you want to print. For this example, we are selecting the range J1:K7.
Note that if you want to print separate sections of your spreadsheet, you will need to repeat this method for each one of them.
Step 3: Click the Print button.
Click the Print button found at the top-left corner of your spreadsheet window.
This will direct you to the Print settings window.
Alternatively, you may click the File Menu and select Print. The Print option is placed at the bottom of the list.
Tip: You can always use a shortcut key to show the Print settings window.
Simply press CTRL+P on your keyboard.
Step 4: Print your document.
Once you’re on the Print settings window, click the Print drop-down list and select Selected Cells.
You will notice Google Sheets detects and shows you the range of the cells you selected.
For this example, it should show Selected Cells (J1:K7).
Click the Next button if you want to proceed. Otherwise, click the Cancel button to go back to your spreadsheet window.
Method 2: Set Current Sheet or Workbook as Print Area
Step 1: Open up your spreadsheet file.
Step 2: Click the Print button.
Click the Print button found in the Menu bar. The Print window will show up.
On the right part of the window, click the drop-down menu below the text Print. Select Current Sheet if you want to print the current sheet only.
Otherwise, select Workbook if you want to print the entire workbook.
Note that printing the whole workbook will only print cells with active values.
Note: The Workbook option will only be available to spreadsheets that have more than one sheet.
When choosing the Workbook option, we highly recommend that you revisit your sheets to double check active cells.
You can do this by pressing CTRL+A on your keyboard. This will highlight the active cells so you could adjust the table accordingly. This way, you can avoid too many blank rows or columns before printing.
Click the Next button found at the top-right corner once finished.
You will be directed to the Chrome print dialogue box.
This is the same dialogue box we encounter whenever we want to print something in Chrome.
Customizing your Print Area in Google Sheets
Google Sheets provides several ways to tweak print settings.
All these options are found in the right panel of the Print settings window.
These options allow you to preview the pages and configure how they should appear when printed.
We have listed below some of the many useful functions Google Sheets has to offer.
Use this when you want to specify the type of paper you are going to use or if you are using a custom-sized one.
Use this when you want to switch between landscape or portrait orientation.
Use this when you want to fine-tune how your print area appears on the page. This is most useful when you want to fit a certain portion of your sheet to the width or height of the page.
Use this when you want to specify the margins around your print area. You can specify unit measurements in this option, just like in Google Docs and MS Word.
Set Custom Page Breaks
Use this when you want to specify page breaks within your worksheets. This is most useful when you need to manually divide the whole spreadsheets into pages.
Use this when you want to show gridlines, notes as well as to specify the page order and print area alignment.
Headers & Footers
Use this when you want to add usual details found in headers and footers like the page numbers, date, time, title, etc.
We hope you found this article helpful!