How to Deselect Cells in Excel & Google Sheets

deselect cells initial data

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.