See all How-To Articles

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 2

 

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.

 

print only selected cells 1

 

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

 

print only selected cells 2

 

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

 

print only selected cells 3

 

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

 

print only selected cells 4

 

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

 

print only selected cells 5

 

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).

 

google sheets print only selected cells 1

 

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

 

google sheets print only selected cells 2

 

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

 

google sheets print only selected cells 3

 

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