How to Deselect in Excel

To deselect a single cell or range from a larger selection, hold Ctrl (Windows) or Cmd (Mac) and click or drag over the cells you want to remove. To clear the entire selection at once, press Esc or click any single cell elsewhere on the sheet.

If you are new to Excel or you haven’t used it extensively, the concept of deselecting might be a bit confusing. Deselecting in Microsoft Excel is a fundamental action that allows you to remove a selection, range or highlight from a sheet without affecting any other element. Deselecting is a crucial skill to have when working with large data sets, especially when you don’t want to start over if you accidentally select something you didn’t mean to. In this blog post, we will show you different ways to deselect in Excel, so you can easily and confidently navigate your spreadsheets.

Selecting and Deselecting in Excel

When working with data in Excel, selecting and deselecting are two fundamental operations that you need to master. Selecting is the process of highlighting or choosing a range of cells, columns, or rows, while deselecting is the process of removing or clearing that selection. If you need a refresher on building selections first, see our guides to selecting cells and selecting data in Excel.

How to Deselect a Range of Cells in Excel

The easiest way to deselect a range of cells in Excel is to click on any cell outside the range. For example, if you selected cells A1:A10, you can deselect them by clicking on any cell outside that range. This will clear the range and allow you to select a different range without affecting the previous one.

Step by Step:

1. Select a range of cells you want to deselect.
2. Click on any cell outside that range.
3. The previous selection is now deselected, and you can proceed with another selection.

Using the Escape Key

Another way to deselect a range of cells in Excel is to use the Escape key on your keyboard.

Step by Step:

1. Select the range of cells you want to deselect.
2. Press the Esc key on your keyboard.
3. The previous selection is now deselected, and you can proceed with another selection.

Pressing Esc clears the whole selection but leaves the active cell where it was, so it is the fastest way to start fresh without touching your mouse. For more keyboard-first ways to move and select, see the best Excel keyboard shortcuts.

Deselecting Specific Cells Within a Range

What if you want to deselect only some cells within a range? In Excel 2016, Excel 2019, and Microsoft 365 you can remove individual cells from an existing selection with the Ctrl key without losing the rest. (Older versions, such as Excel 2013 and earlier, do not support deselecting individual cells this way, so confirm your version if the step below does nothing.) This is the answer to the common question of how to remove a cell from a selection without starting over.

Step by Step:

1. Select the range of cells you want to work with.
2. Hold down the Ctrl key on your keyboard.
3. Click on the cells you want to deselect within the range.
4. Release the Ctrl key.
5. The previously selected cells are now deselected, and you can proceed with another selection.

The same trick works for removing a non-adjacent block: with Ctrl held down, click and drag across a group of already-selected cells to peel just that block out of the selection. This pairs naturally with the way you build multiple-cell selections in the first place.

Deselecting by Clicking and Dragging

You can also use the click-and-drag technique to deselect cells in Excel.

Step by Step:

1. Select the range of cells you want to work with.
2. Hold down the Ctrl key, then click on any of the selected cells and hold down the mouse button.
3. Drag the mouse cursor across the cells you want to remove from the selection.
4. Release the mouse button, then release Ctrl.
5. The selected cells are now deselected, and you can proceed with another selection.

Deselecting in Excel is a simple yet essential operation that can save you time and effort when working with data. By following these simple steps and techniques, you can easily and quickly deselect ranges of cells, individual cells, or parts of a range, allowing you to work more efficiently and productively.

Deselecting Entire Rows or Columns From a Selection

The Ctrl method is not limited to single cells. If you have several rows or columns selected and want to drop one from the group, hold Ctrl and click its row number or column letter in the header. Excel removes just that row or column and keeps the rest of the selection intact. The same applies when you have used Ctrl to build a multiple-column selection or selected an entire column and then decide one of them does not belong. If you Ctrl+click a column header that overlaps a partial range, Excel may keep the highlighted cells while clearing the header highlight, so watch the cell count in the status bar as you go. The cell you last click becomes the active cell in the remaining selection.

When to use Deselecting in Excel

Deselecting in Excel is an effective way of removing unwanted selections, ranges, or highlights. It enables you to avoid the mistake of starting from scratch when you accidentally select more than you intended. As you work with large data sets, you might need to manipulate different selections at different times. Making use of the deselecting feature can help you save time and carry out efficient tasks.

Final thoughts

Deselecting in Excel is a crucial skill that will save you time and effort, and if you are new to Excel, it is a basic but an important concept that you must master. In conclusion, Excel provides multiple ways to deselect a range of cells, individual cells, or parts of a range.

With this knowledge, the next time you make a mistake while selecting data, you don’t have to start from scratch. Instead, you can use these simple and effective methods to remove any unwanted highlight or range, and quickly move on to your next task.

We hope this article has been helpful to you in your Excel journey! Happy deselecting!

Frequently Asked Questions

Here are answers to some frequently asked questions about deselecting in Excel.

How do I deselect a single cell in Excel without starting over?

Hold down the Ctrl key (or Cmd on a Mac) and click the cell you want to remove. Excel keeps the rest of your selection intact and only drops the cell you clicked. This feature is available in Excel 2016, Excel 2019, and Microsoft 365.

How do I deselect everything at once?

Press the Esc key, or simply click any single cell elsewhere on the worksheet. Both methods clear the entire selection so you can start a new one.

Is there a shortcut key to deselect cells in Excel?

There is no dedicated “deselect” hotkey, but the Esc key clears the active selection instantly. To remove individual cells while keeping the rest, hold Ctrl (or Cmd on Mac) and click those cells.

Is deselecting cells different on Mac and Windows?

The technique is the same, but the modifier key differs. On Windows you hold Ctrl to add or remove cells from a selection; on a Mac you hold Cmd (⌘) instead. The Esc key and clicking elsewhere to clear a selection work identically on both platforms.

Can I undo a selection in Excel?

Yes. Press Ctrl + Z to undo your last action, which can include a selection change. Alternatively, in newer versions of Excel you can use the undo button in the ribbon.

Can I deselect multiple ranges of cells at once in Excel?

You deselect within one active selection at a time, but you can remove several separate cells or blocks from that selection in a single pass: hold Ctrl and click or drag across each part you want to drop before releasing the key.

What should I do if I accidentally delete some data while deselecting in Excel?

If you accidentally delete data while deselecting in Excel, use the Undo function (Ctrl + Z) to restore your previous state and bring back the deleted data. You can use the redo function (Ctrl + Y) to reapply a change. Always save your work regularly so you can recover it if something goes wrong.