Hold Ctrl and click any selected cell to remove it from the selection. To remove a block, hold Ctrl and drag across the selected cells you no longer want; the rest of the selection stays in place.
To drop a whole column or row from the selection, hold Ctrl and click its column letter or row number. On a Mac, hold Command instead of Ctrl.
Ctrl-click deselecting works in Microsoft 365 and Excel 2021 or later. In Excel 2016 and earlier, Ctrl + click on a selected cell selects it a second time instead of removing it, so you have to redo the selection, holding Ctrl while you pick only the ranges you want.
To clear the whole selection, click any single cell or press an arrow key. Selection changes are not recorded in the undo list, so Ctrl + Z will not bring back a cell you deselected by mistake; hold Ctrl and click it again to add it back.
Deselecting leaves the selection in several separate pieces. Formatting, Delete and typing with Ctrl + Enter all work on it, but copying usually fails with the message “This action won’t work on multiple selections” unless the pieces share the same rows or columns. If you need to copy the result, filter out the unwanted rows and copy the visible cells instead.
For a long time, Excel had no option to deselect cells or a range from a selected range of cells. So, if you selected a cell by mistake, you had to start the whole selection again.
But now Excel has introduced the feature to deselect the cells or a range of selected cells from your current selection. Today, this feature is available in Excel for Microsoft 365, Excel 2024 and Excel 2021, on both Windows and Mac.
Below are quick and easy steps to deselect and select cells in Excel.
Deselect Cells in Excel
After adding the deselecting cells feature in Excel, it becomes easy to deselect the cells you do not require within your current selection.
- First, press and hold the “Control” key on the keyboard (Command on a Mac).
- After that, click the cells within your current selection that you want to deselect, or click and drag across a range to deselect all of it.

In the above example image, we have held the Control key and clicked on the cells B1, B3, and B7 to deselect those cells from the current selection (A1-I15). You can see that those cells are no longer selected.
Deselect the Entire Columns in Excel
- First, press and hold the “Control” key on the keyboard (Command on a Mac).
- After that, click the column header and drag down the entire column to deselect that column from your current selection.

In the above example image, we have held the Control key and clicked on the column header (Category), and dragged down the column to D15, and we did the same for the column header (Area) to deselect those two entire columns (D & F) from the current selection (A1-I15).
Select Cells or Ranges in Excel
There is no change in selecting the cells or range of cells in Excel. The process of selecting the cells is the same and is shown below:
- For contiguous cells, select the cell from where you want to start your selection.
- After that, press and hold the “Shift” key and then click the cell up to which you want to create the selection.
- Or select the cell from where you want to start your selection and then drag up to the cell where you want it to end.

In the above example image, we have first clicked on cell A1 and held the Shift key, and then directly clicked on cell I15 to create a selection (A1-I15).
- For non-contiguous cells, press and hold the Control key and then select the cells or ranges you want as your selection.

In the above example image, we have held the Control key and selected the non-contiguous cell ranges.
Reselect a Deselected Cell
If you deselect a cell by mistake, keep holding the Control key (Command on a Mac) and click the same cell again. It goes back into the selection. And to clear the whole selection at once, just click any single cell or press an arrow key.
Add to the Selection without Holding Control
When you need to pick a lot of separate cells, press Shift + F8 to turn on Add to Selection mode. The status bar shows “Add to Selection”, and every cell or range you click is added to the selection without holding any key. Press Shift + F8 again (or Esc) to turn it off.
Frequently Asked Questions
Why can’t I deselect cells in my Excel?
Deselecting with Control is only in Excel for Microsoft 365, Excel 2021 and Excel 2024. In older versions like Excel 2016, Control + click only adds cells, so you need to start the selection again.
How do I deselect cells on a Mac?
Hold the Command key instead of Control, and click or drag across the cells you want to remove from the selection.
Does deselecting cells change the data?
No. It only changes which cells are selected, so the next action you take (like formatting or deleting) applies only to the cells that are still selected.