How to choose the print area on Google Sheets

Selecting a print area in Google Sheets will help you choose to print the content you want, instead of printing the entire data content.

By default, when printing a document on Google Sheets, all content displayed on the document will be printed. However, there are many cases where you only want to print an area of ​​that Google Sheets data sheet, not the entire contents of the file. Just like Excel prints an area, with Google Sheets we also have the option to print a range of data, printing only the content that the user has localized. Setting the print area selection on Google Sheets is also simple and is guided in the article below.

Instructions for selecting print areas on Google Sheets

Step 1:

Users open the Google Sheets data sheet they want to print and then select the data that they want to print . Then click the print icon as shown below.

How to choose the print area on Google Sheets Picture 1How to choose the print area on Google Sheets Picture 1

Step 2:

Display the page setup interface. In the Print user, click the drop-down arrow and select the data area that you previously localized . At this time, the preview interface on the side only displays the correct data area that we have chosen.

How to choose the print area on Google Sheets Picture 2How to choose the print area on Google Sheets Picture 2

Step 3:

Next to selecting the Portrait or Landscape orientation, depending on the area of ​​the data you want to print, the Margins also need to be adjusted or press Custom numbers to manually enter the size for the printed page margin.

How to choose the print area on Google Sheets Picture 3How to choose the print area on Google Sheets Picture 3

The printed page is then modeled as shown. We enter the margins directly into this interface to adjust accordingly to your intention.

How to choose the print area on Google Sheets Picture 4How to choose the print area on Google Sheets Picture 4

Step 4:

After adjusting the printed pages, click Next . Finally, click Print to complete the Google Sheets document.

How to choose the print area on Google Sheets Picture 5How to choose the print area on Google Sheets Picture 5

4 ★ | 2 Vote