See all How-To Articles

How to Deselect Cells in Excel & Google Sheets

In this tutorial, you will learn how to deselect cells in Excel and Google Sheets.

 

deselect cells initial data

 

Deselect Cells

Say you have an Excel sheet with the range A2:D10 selected, as shown below.

 

deselect cells initial data

 

To deselect cells from Column B (range B2:B10), press and hold CTRL on the keyboard, and drag through the cells you want to deselect.

As a result, the cells in Column B are deselected, while ranges A2:A10 and C2:D10 are still selected.

 

deselect cells final data

 

Note: You can also use VBA code to deselect cells.

Deselect Cells in Google Sheets

Deselecting cells in Google Sheets works in exactly the same way.