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


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.

See all How-To Articles