Print Area In Google Sheets

What Is The Print Area In Google Sheets?

Print Area in Google sheets, as the name suggests helps users assign or create an area to print a section (with a cell range or numerous cell ranges) in a spreadsheet. This option is effective as it enables users to print only a section instead of the whole spreadsheet.

For example, consider the below table showing marks obtained by students in columns A and B, respectively.

Print Area In Google Sheets Definition 1

Now, let us create print area in Google sheets for the given data.

The steps are:

Step 1: To start with, insert the data in the spreadsheet. In this example, the spreadsheet is in the cell range A1:B5.

Step 2: Next, click on File and select Print option, which is the last option in the tab.

Step 3: Now, we will be able to see a window named Print settings.

Step 4: Then, select the drop down under the Print option at the right end of the screen.

Step 5: We will be able to see an option as Selected cells (A1:B5).

Select the option and click on Print.

Print Area In Google Sheets Definition 1-1

We will be able to see the selected cell range will only be printed instead of the whole spreadsheet.

Similarly, we can select a particular area in Google sheets. This is called Print Area in Google sheets and is much easier when compared to that of Excel.

In this article, let us learn how to use Print area in Google sheets with detailed examples.

What Is The Print Area In Google Sheets?

Print Area in Google sheets helps users set an area to print a particular section in the spreadsheet.
We can print Google sheets in desktop applications as well as mobile apps.
Remember, to set a print area in Google sheets, we need to select the cell range.
Next, click on File > Print and in the Print settings window, select the Selected cells option under the Print option in the Google sheets.
We can also add custom margins while printing cell ranges in Google sheets.

How To Set Print Area In Google Sheets?

We can set print area in Google sheets that suits the requirements of the users using cell selection method.

The steps are:

Step 1: To start with, insert the data in the spreadsheet. Next, we need to select the cell range we want to print.
Step 2: Next, click on File and select Print option.
Step 3: Now, we will be able to see a window named Print settings.
Step 4: Then, select the drop down under the Print option at the right end of the screen.
Step 5: We will be able to see an option as Selected cells with the cell range reference in closed brackets.

Select the option and click on Print.

We will be able to see the selected cell range will only be printed instead of the whole spreadsheet.

Likewise, we can select a particular area in Google sheets.

Using Cell Selection Example

For example, consider the below table showing products and sales in columns A and B, respectively.

Now, let us create print area in Google sheets for the given data.

The steps are:

Step 1: To start with, insert the data in the spreadsheet. In this example, the spreadsheet is in the cell range A1:B5.

Step 2: Next, click on File and select Print option, which is the last option in the tab.

Step 3: Now, we will be able to see a window named Print settings.

Step 4: Then, select the drop down under the Print option at the right end of the screen.

Step 5: We will be able to see an option as Selected cells (A1:B5).

Select the option and click on Print.

We will be able to see the selected cell range will only be printed instead of the whole spreadsheet.

Similarly, we can select a particular area in Google sheets.

Examples

Example #1 – Change Print Margins In Google Sheets

Sometimes, we may have to change the margins in Google sheets while printing a specific, particular area in Google sheets. Let us learn how to change print margins in Google sheets with the following example.

Consider the below table showing sample products and units in columns A and B, respectively.

Now, let us change print margin in Google sheets for the given data.

The steps are:

Step 1: To start with, insert the data in the spreadsheet. In this example, the spreadsheet is in the cell range A1:B5.

Step 2: Next, click on File and select Print option, which is the last option in the tab.

Step 3: Now, we will be able to see a window named Print settings.

Step 4: Then, select the drop down under the Margins option at the right end of the screen.

Step 5: We will be able to see options such as Normal (selected by default), Narrow, and Wide.

We can use any of the given options to change print margins. In case, users want to include any specific margin, we need to select the Custom numbers option.

While using Custom numbers option, we need to specify the Top, Right, Left, and Bottom margin numbers.

Select the option and click on Print.

We will be able to see the printed sheet with the selected cell range with margins.

Likewise, we can change print margins in Google sheets.

Example #2 – Print Header Rows For Each Google Sheets Page

Users can have huge datasets in Google sheets. And while printing, we will be able to see the header in the first sheet but not the other sheets. In such cases, we need to print header rows for each Google sheets page.

Let us learn how to print sheets with header row in Google sheets. For example, consider the below table showing marks obtained by students in various subjects in columns A and B, respectively.

Now, let us print header rows for each Google sheets page for the given data.

The steps are:

Step 1: To start with, insert the data in the spreadsheet. In this example, the spreadsheet is in the cell range A1:B5.

Step 2: Next, select the data and click on View. Now, select Freeze option and select 1 row option if you want to freeze the 1^st row.

Step 3: The row is now converted into a header and it appears even if we scroll through the entire worksheet.

Next, select the data and click on File > Print. A window named Print settings appears.

Step 4: Then, select the drop down under the Print option at the right end of the screen.

Step 5: We will be able to see an option as Selected cells (A1:B5).

Select the option and click on Print.

We will be able to see the selected cell range will only be printed instead of the whole spreadsheet.

Similarly, we can select print header rows for each Google sheets page.

Example #3 – Print From Google Sheets Mobile App

We can print data from Google sheets mobile app also. To print,

Step 1: Simply open the app. Select the sheet we want to print.
Step 2: Now, we can see a menu. Here, click on the Print option.
Step 3: Here, click on Select a printer option.
Step 4: Press Print.

Likewise, we can print from Google sheets mobile app.

Example #4 – Use Named Ranges As Print Areas

Till now, we saw how to select and print area in Google sheets. But, if we have a huge data set which we cannot select, we can simply give a name to the cell range and then, set the print area.

For example, consider the below table showing data and price in columns A and B, respectively.

Now, let us create print area in Google sheets for the given data.

The steps are:

Step 1: To start with, insert the data in the spreadsheet. In this example, the spreadsheet is in the cell range A1:B5.

Step 2: Next, click on Data and select Named ranges option.

Step 3: Now, click on Add a range. The Named ranges window appears.

Step 4: Then, enter the cell range name and cell range reference and click on Done.

Step 5: Now, click on File and Print. In the Print settings window, select the named cell range and click on Next to print.

Similarly, we can use print named ranges as print areas in Google sheets.

Important Things To Note

Print area is assigning a particular area in to print in Google sheets.
We can print a specified cell range or a named range using the Print settings options available in Google sheets.
To open Print settings, we can either click on File > Print or click on Ctrl + P.

Frequently Asked Questions

1) Explain print area in Google sheets with an example.

For example, consider the below table showing marks obtained by students in columns A and B, respectively.

Now, let us create print area in Google sheets for the given data.

The steps are:
Step 1: To start with, insert the data in the spreadsheet. In this example, the spreadsheet is in the cell range A1:B5.
Step 2: Next, click on File and select Print option, which is the last option in the tab.
Step 3: Now, we will be able to see a window named Print settings.
Step 4: Then, select the drop down under the Print option at the right end of the screen.
Step 5: We will be able to see an option as Selected cells (A1:B5).

Select the option and click Print.

We will be able to see the selected cell range will only be printed instead of the whole spreadsheet.
Similarly, we can select a particular area in Google sheets.

2) What is the difference between print area in Excel and Google sheets?

In Excel, we can set print area using Layout method or selected cell range method. But, in Google sheets, we can only add print area using cell selection method only.

3) Can we add custom margins while printing in Google sheets?

Sometimes, we need to choose the custom margins in Google sheets for a particular sheet.
In such cases, click on custom numbers option and choose the margins in inches.

Print Area In Google Sheets