Print Certain Cells in Google Sheets

Ever needed to print only specific cells from a Google Sheet instead of the entire document? Printing only certain cells can save paper and time, especially when you're dealing with large datasets. Here's a step-by-step guide to help you achieve this efficiently.

Before we dive in, ensure you're working with Google Sheets, as the process may vary with other spreadsheet software. Let's start!

Selecting the Cells to Print

The first step is to identify and select the cells you want to print. Google Sheets allows you to select non-adjacent cells, making it easy to pick scattered cells across your sheet.

To select non-adjacent cells:

• Click on the first cell you want to select.
• Hold down the Ctrl key (or Command key on Mac).
• Click on each additional cell you want to select.

Using the 'Print Area' Feature

Once you've selected your cells, you can set a 'Print Area' to ensure only these cells are printed.

To set a 'Print Area':

1. Click on the first cell you've selected.
2. Click on the Data menu in your Google Sheets toolbar.
3. Hover over Create a print area and choose Set print area from the dropdown.

Adjusting Page Orientation and Scaling

You can also adjust the page orientation and scaling to fit your selected cells on the page better.

To adjust orientation and scaling:

• Click on the File menu, then Page setup.
• Choose your preferred Paper orientation (Portrait or Landscape).
• Adjust the Scale to fit your cells better on the page. You can also try the Fit to option to fit to a specific paper size.

Setting Up the Print Dialog

Now that you've prepared your cells for printing, let's set up the print dialog box.

To open the print dialog box:

• Click on the File menu, then Print.
• Or, you can use the keyboard shortcut Ctrl + P (or Command + P on Mac).

Reviewing and Adjusting Your Selection

In the print preview, review and ensure only your selected cells are visible. If not, adjust your 'Print Area' or selected cells and try again.

To adjust your selection:

• Click on Edit in the print preview toolbar.
• Choose Select custom cells and adjust your selection.

Previewing and Printing

Once satisfied with your preview, you can proceed to print your selected cells.

To print:

• Click on the Print button in the print preview toolbar.

And there you have it! You've successfully printed only the cells you needed from your Google Sheet. This efficient method can save you time and resources, especially when working with large datasets. Happy printing!