We enter the margins directly into this interface to adjust accordingly to your intention.Īfter adjusting the printed pages, click Next. The printed page is then modeled as shown. 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. At this time, the preview interface on the side only displays the correct data area that we have chosen. In the Print user, click the drop-down arrow and select the data area that you previously localized. Then click the print icon as shown below.ĭisplay the page setup interface.
Users open the Google Sheets data sheet they want to print and then select the data that they want to print. Instructions for selecting print areas on Google Sheets Setting the print area selection on Google Sheets is also simple and is guided in the article below. the header and the data below the header) ONE part of the outline doesn't appear.
However, when I print preview the selected cells (i.e. When I print preview the entire sheet, the outline appears normally. While editing, the outline appears as normal. 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. I have a black border outline surrounding my header (3 rows tall). 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. By default, when printing a document on Google Sheets, all content displayed on the document will be printed.