How to deselect in Excel
The best way to deselect cells in Excel without losing your current selection is using the Deselect Tool. The deselect tool is a new feature in Microsoft Excel that’s present only in Office 2019 or Office 365 subscription.
It’s very easy to use 👍
Let’s say you selected cells and realized you don’t need some of them.
You don’t need to select them again. You just need to know how to deselect the cells you don’t need. This is where the Deselect Tool comes in. You just need to press the Control Key (Ctrl) on your keyboard.
First, open an Excel file and select cells in your worksheet. You can do this by the common click-and-drag method.
You can also select multiple cells by holding down the Control key and dragging the mouse over a range of cells.
Now, to deselect cells, hold down the Control key (Ctrl) on your keyboard while you click on certain cells you don’t need.
You can deselect contiguous cells (cells that are next to each other vertically or horizontally) or non-contiguous cells (separate cells) or both in your worksheet 👇
To deselect contiguous cells, hold down the Ctrl key and drag the mouse.
To deselect non-contiguous cells, hold down the Ctrl key then click on each selected cell.
It’s easy, right? 😀
The same works if you selected columns or rows.
If you need to deselect columns, hold down “Ctrl” and click on the specific column headers (or drag the mouse if they’re contiguous).
If you need to deselect rows, hold down “Ctrl” and click on the specific row headers (or drag the mouse if they’re contiguous).
See? You can deselect cells in Excel without having to lose your current selection 😊
The Control key is the key 🔑