قالب وردپرس درنا توس
Home / Tips and Tricks / Print a specific selection of cells in Google Spreadsheets

Print a specific selection of cells in Google Spreadsheets



  The Google Spreadsheets logo.

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.

 Mark the cells that you want to print. "Width =" 650 "height =" 282

After you select the range of cells, click the printer icon in the toolbar to open the printer settings for Spreadsheets.

 Click the Printer icon. "width =" 495 "height =" 340

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 [19659003] 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.

 Click on the drop-down list and click on "Selected cells" from the choices below. "Width =" 650 "height =" 276

The example now only shows the selection of cells that you have created and nothing else.

 Only the selected cells now appear in the print preview. "Width =" 649 "height =" 609

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.

 Click on "Landscape" to change the page orientation. "Width =" 371 "height =" 340

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.

 Change the margins of the cells to "Narrow" or "Custom numbers" so that they all fit nicely on one page. "Width =" 366 "height =" 436

Now all cells fit comfortably on one page. After you have configured the page setup, click "Next" to continue.

 Click on "Next" to continue. "Width =" 650 "height =" 283

Click "Print" in the next window to complete the job and send it to your printer.

 Finally, click "Print" to send the job to your printer. "width =" 484 "height =" 376

That's it. Your printer now shoots out the page with only the specific selection of cells that you wanted to print.


Source link