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

 

Deselect Cells in Google Sheets

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

 

select cells gs

 

See Select Multiple (or All) Sheets in Excel & Google Sheets for how to deselect tabs.