How to Print Only Selected Cells in Excel & Google Sheets

This tutorial demonstrates how to print only selected cells in Excel and Google Sheets.

 

 

Print Only Selected Cells

When you choose to print your Excel document, the default printing settings will print all data in the worksheets. However, you can change this, and print only selected cells. Say you have the following data set with sales data, and you want to print only range B1:F7.

 

 

1. Select the range you want to print (e.g., B1:F7).

 

 

2. In the Ribbon, go to File > Print (or use the keyboard shortcut CTRL + P).

 

 

3. In Print Settings, click on the drop down and choose Print Selection.

 

 

As a result, in the print preview, you can see that only selected cells will be printed.

 

 

Print Only Selected Cells in Google Sheets

In Google Sheets, you can achieve the same thing following these steps:

1. Select the range you want to print (e.g., B1:F7).

 

 

2. In the Menu, go to File > Print (or use the keyboard shortcut CTRL + P).

 

 

3. In the Print drop down on the right side, choose Selected cells (B1:F7).

 

 

As you can see in the picture above, only the selected range will be printed.