How to Set Print Area in Google Sheets(Quick & Easy Guide)

In this tutorial you will learn How to Set Print Area in Google Sheets.

To Set print area in Google Sheets Select the data in your Google Sheets then click on the Print icon in the quick tool bar or use Ctrl+P to open the Print Settings.Now Change the default “Current Sheet” option under Print section to “Selected Cells”.Then Click on the Next Button and Print the data-

How to Set Print Area in Google Sheets : Step by Step Guide

Here’s how to Set Print Area in Google Sheets :

Step 1

Open Google Sheet

Step 2

  • Choose the data in your Google Spreasheet that you want to print .
  • Select any cell within the data set and press CTRL+A to select the entire dataset.
How to Set Print Area in Google Sheets

Step 3

Click on the Print icon available on quick tool bar to open the print settings as shown below .

You can also use tke Keyboard Shortut Ctrl+P or Click on File menu ->Print

Step 4 :

Once you click on the print option it will open the Print Settings Panel on the right hand side along with a view of your data that you want to print .

To specify the print range of your data ,click on the down arrow beside “Current Sheet” under “Print” section and Choose “Selected Cells

Step 5

Perform further adjustment as per your requirement such as changing the Page Orientation,Scale and Margins and then Click on the Next button .

Step 6 :

As a Last Step click on the Print button.

How to Set Print Area in Google Sheets(Conclusion)

In the above tutorial we have provided you a Step by Step Guide using which you can set Print area in Google Sheets.

We hope this tutorial on How to Set Print Area in Google Sheets was helpful.

Related articles :

How to Insert Spin Button in Google Sheets ( Easy Guide )

How to Freeze Rows in Google Sheets

How to Calculate Square Root and Cube Root in Google Sheets(Quick & Easy Guide)

How to use SUMSQ Function in Google Sheets(Quick & Easy Guide )