How to Print Selected Cells in Google Sheets: A Step-by-Step Guide


Google Sheets is a powerful tool for managing and analyzing data, but it can be frustrating when you want to print only certain cells. Luckily, there is a solution! In this step-by-step guide, we will walk you through the process of printing selected cells in Google Sheets. This feature is essential for those who want to save time and effort by printing only the necessary data, making it easier to organize and present information effectively.

Key Takeaways

  • Being able to print selected cells in Google Sheets is important for efficient data management and analysis.
  • Access the print menu by clicking on the "File" tab and selecting "Print" or using the shortcut "Ctrl+P".
  • Select desired cells by clicking and dragging, holding down the "Ctrl" key for non-contiguous cells, or using the "Shift" key for multiple rows or columns.
  • Adjust print settings such as paper size, orientation, margins, scaling, and alignment within the print menu.
  • Preview the print layout and make necessary adjustments before clicking the "Print" button.
  • Choose the desired printer and adjust additional settings if needed, then click "Print" to start printing.
  • Utilizing the feature saves time and effort, while enhancing organization and presentation of information.
  • Readers are encouraged to explore more advanced print options in Google Sheets for an enhanced printing experience.

Accessing the Print Menu

Printing selected cells in Google Sheets is a simple process that can be achieved through the print menu. Here's how to access the print menu in Google Sheets:

Click on the "File" tab in the top left corner of the screen.

  • Locate the "File" tab at the top left corner of your Google Sheets dashboard.
  • Click on the "File" tab to open the drop-down menu.

From the drop-down menu, select "Print" or press "Ctrl+P" on your keyboard.

  • Once the drop-down menu appears, navigate to the "Print" option.
  • Click on "Print" to open the print menu or simply press the "Ctrl+P" keyboard shortcut.

By following these steps, you will be able to access the print menu in Google Sheets, which is the first step towards printing your selected cells.

Selecting Cells to Print

When it comes to printing specific cells in Google Sheets, it is important to know how to properly select the desired cells. By following these step-by-step instructions, you can easily select and print only the cells you need.

1. Click and drag the cursor over the cells you want to print.

To select a range of contiguous cells, simply click on the first cell you want to print and then drag the cursor to the last cell in the desired range. As you drag, you will notice that the selected cells are highlighted. This method is ideal for printing a rectangular block of cells in your spreadsheet.

2. Hold down the "Ctrl" key while clicking on individual cells to select non-contiguous cells.

If you need to select individual cells that are not in a continuous range, you can use the "Ctrl" key on your keyboard. Simply hold down the "Ctrl" key and click on each cell you want to include in your selection. Each clicked cell will be highlighted, allowing you to print only those specific cells without selecting any unwanted cells.

3. Use the "Shift" key in combination with click and drag to select multiple rows or columns.

In some cases, you may want to print multiple entire rows or columns in your spreadsheet. To do this, you can use the "Shift" key along with the click and drag method. Start by clicking on the first row or column you want to print, then hold down the "Shift" key and click on the last row or column in the desired range. The selected rows or columns will be highlighted, enabling you to print them in their entirety.

By following these simple steps, you can easily select specific cells or ranges of cells in Google Sheets to print. This allows you to customize your printouts and only include the data that is relevant to your needs.

Adjusting Print Settings

When printing selected cells in Google Sheets, it's important to adjust the print settings to optimize the output. By making a few adjustments, you can ensure that the printed document looks exactly as you intend it to. Here's a step-by-step guide on adjusting print settings in Google Sheets:

Step 1: Access the Print Menu

To begin adjusting print settings, start by accessing the print menu in Google Sheets. You can do this by clicking on the "File" tab in the top left corner of the screen and then selecting the "Print" option from the dropdown menu.

Step 2: Click on "Print settings"

Within the print menu, you will see a button labeled "Print settings." Click on this button to open up the print settings dialog box.

Step 3: Set Paper Size, Orientation, and Margins

Once the print settings dialog box appears, you can begin customizing the paper size, orientation, and margins for your printed document. Choose the paper size that best matches your needs, such as A4 or Letter. Additionally, select the orientation of the paper (portrait or landscape) and set the desired margins.

Step 4: Customize Scaling and Alignment

Another important aspect of adjusting print settings is customizing the scaling and alignment options. These settings allow you to fit the selected cells neatly on the printed page. In the print settings dialog box, look for the scaling and alignment options and make any necessary adjustments. You may need to experiment with different settings to achieve the desired result.

By following these steps and making adjustments to the print settings in Google Sheets, you can ensure that your selected cells are printed exactly as you want them to appear.

Previewing and Making Further Adjustments

Before printing your selected cells in Google Sheets, it's important to preview the print layout and make any necessary adjustments to ensure that the printed version meets your requirements. Follow these steps to preview and make further adjustments:

1. Click on the "Preview" button within the print menu

Once you have selected the cells you want to print and accessed the print menu, locate the "Preview" button and click on it. This will generate a preview of the print layout, allowing you to assess how the content will appear on paper.

2. Review the previewed print layout and check for any errors or undesirable formatting

Take a careful look at the previewed print layout. Pay attention to the placement of the selected cells, the overall formatting, and the alignment of the content. Look for any errors, such as cut-off text or overlapping elements, as well as any formatting issues that may affect readability.

3. Go back to the main print menu to make further adjustments if needed

If you notice any errors or undesirable formatting in the previewed print layout, navigate back to the main print menu by clicking on the appropriate button or tab. From there, you can access various settings and options to make further adjustments and refinements.

For example, you might need to adjust the page layout settings, such as the paper size or orientation, to ensure that the content fits neatly within the printable area. Additionally, you can modify the margins and scaling options to optimize the appearance of the printed cells.

Furthermore, if you want to include additional elements in the printout, such as headers, footers, or gridlines, you can do so by exploring the available options within the print menu.

Once you have made the necessary adjustments, you can repeat the previewing step to ensure that the changes have been applied successfully and that the print layout now meets your desired specifications.

Printing the Selected Cells

Printing selected cells in Google Sheets allows you to create hard copies of specific data within your spreadsheet. Whether you need to present the information in a meeting or keep a physical record, printing selected cells is a straightforward process. Follow these simple steps to print your desired cells:

Step 1: Select the Cells

To begin, you must first select the cells you want to print. Click and drag your cursor over the cells to highlight the desired range. You can select multiple cells by holding down the Ctrl or Command key while clicking on additional cells. Make sure all the necessary cells are selected before proceeding to the next step.

Step 2: Open the Print Menu

After selecting the desired cells, click on the "File" tab located at the top left corner of your Google Sheets window. In the dropdown menu, select "Print" to open the print settings.

Step 3: Preview and Adjust Settings

Once the print menu appears, a preview of your selected cells will be displayed. Take a moment to review the preview and ensure it is accurate. If necessary, you can adjust the page size, orientation, and margins from the options provided. Additionally, you can choose to include headers and footers, as well as adjust the scale of the printout.

Step 4: Select Printer and Additional Settings

With your desired settings in place, it's time to choose the printer. From the printer options menu, select the printer you wish to use for the printout. If you have multiple printers connected to your device, ensure you select the correct one. Additionally, if there are any specific print settings you need to adjust, such as color or quality, you can do so from this menu.

Step 5: Start Printing

Once you are satisfied with the preview and have selected the appropriate printer and settings, it's time to start printing. Click on the "Print" button within the print menu to initiate the printing process. Your selected cells will be sent to the printer, and a hard copy of the data will be produced.

By following these easy steps, you can print selected cells in Google Sheets with confidence. Whether you need a physical copy for reference or to share with others, printing selected cells allows you to efficiently utilize the data within your spreadsheet.


In this step-by-step guide, we have explored how to print selected cells in Google Sheets. To recap, the key steps are:

  1. Select the cells you want to print by clicking and dragging over them.
  2. Click on "File" in the menu and select "Print" from the drop-down menu.
  3. In the print settings, choose the desired print options and adjust the settings accordingly.
  4. Click on "Print" to print the selected cells.

By using this feature, you can save time and stay organized by only printing the specific information you need. Instead of printing entire sheets, you can focus on essentials, reducing paper waste and clutter.

As you become more comfortable with printing selected cells, don't hesitate to explore more advanced print options in Google Sheets. With the ability to customize headers, footers, and page breaks, you can further enhance your printing experience and create professional-looking documents.

Excel Dashboard

ONLY $99

    Immediate Download

    MAC & PC Compatible

    Free Email Support

Related aticles