When you print in Google Spreadsheets, all data in the spreadsheet is used by default. If you only want to print a specific set of cells, there is a simple method to specify selected cells. This is how.
Start the Google Spreadsheets homepage in a browser and open an existing spreadsheet for which you want to print some data.
Then mark the cells that you want to print. You can click and drag cells or hold the Shift key while you click the cell range.
After you select the range of cells, click the printer icon in the toolbar to open the printer settings for Spreadsheets.
Alternatively you can use the keyboard shortcut Ctrl + P (Windows / Chrome OS) or Cmd + P (macOS) to get there.
RELATED: All the best shortcuts for Google Spreadsheets  As mentioned earlier, the standard option is to print everything on the current sheet, but we only want to print our specific cell selection. To do this, click on the drop-down list and choose "Selected cells" from the choices.
The example now only shows the selection of cells that you have created and nothing else.
Depending on the number of cells you have selected and the width of the selection, you may want the page to be place it on landscape so that it fits on one page. Click "Landscape" under the "Page Direction" section to turn the page on its side.
If you need the page orientation in Portrait, click the drop-down menu in the & # 39; Margins & # 39; and click on & # 39; Narrow & # 39; or & # 39; Custom numbers & # 39; to choose a predetermined margin or set your own custom size.
Now all cells fit comfortably on one page. After you have configured the page setup, click "Next" to continue.
Click "Print" in the next window to complete the job and send it to your printer.
That's it. Your printer now shoots out the page with only the specific selection of cells that you wanted to print.