How to Deselect Specific Cells in Microsoft Excel Without Losing Your Selection

Microsoft Excel is loaded with powerful productivity shortcuts, like the 14 Tips to Save Time in Microsoft Excel we've shared before. From single cells to entire ranges or worksheets, selecting data is straightforward.

But what if you accidentally select the wrong cell or range? Traditionally, there's no simple way to remove just that part without deselecting everything and starting over.

That's changed with Excel's new Deselect feature, designed specifically for this common frustration. As Excel experts with years of experience training professionals, we're excited to guide you through it. Note: This is currently available only to Office 365 subscribers.

How to Deselect Cells in Microsoft Excel

Over-selecting cells happens to everyone, wasting precious time. The Deselect tool fixes that in moments. Here's the simple three-step process:

1. Hold down the Ctrl key.
2. Click to deselect a single cell, or click and drag to deselect a range within your current selection.
3. To reselect those cells later, hold Ctrl again and click or drag as needed.

Protected worksheets block cell selection or content access. Standard selection methods remain unchanged:

For contiguous cells: Click the first cell, then drag to the last, or hold Shift and use arrow keys.

For non-contiguous cells: Select the first cell or range, then hold Ctrl while adding others.

With Deselect, fix mistakes on the fly—no more full resets. Update to the latest Office 365 today and streamline your workflow.