How to Deselect Cells in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on November 29, 2022

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.

AI Formula Generator

Try for Free

See all How-To Articles