The problem is, just how will deselect cells and also ranges without shedding your existing selection?

There space times as soon as you accidentally encompass one or more in her selection. It would certainly be a rubbish of time to have actually a do-over.

You are watching: How to select a cell without deselecting another in excel


In this article, we’ll present you the best method to deselect cells without shedding your present selection.


Kasper Langmann, Co-founder of tennis2007.org

*This tutorial is because that Excel 2019/Microsoft 365 (for Windows). Obtained a different version? No problem, you can still follow the precise same steps.


The deselect device is a new feature in Excel that’s current only in Office 2019 or Office 365 subscription.

And it’s an extremely easy to use, intuitive even.

*

Let’s to speak you selected a cell variety and establish you don’t need some that them.

First off, you choose the cells by holding under the ‘Ctrl’ key on her keyboard and also dragging the mouse all over the cells the you need.

To deselect the cells, simply click them again if holding down the ‘Ctrl’ key.


It’s important that you don’t let walk of the ‘Ctrl’ key while in this process. If you execute so, you’ll lose all her selection.


Kasper Langmann, Co-founder the tennis2007.org
*

The exact same works if girlfriend selected columns or rows.

If you have to deselect them, host down ‘Ctrl’ and click them (or drag the mouse if they’re contiguous).


*

The vital is manage (‘ctrl’). The important thing is no to let walk of ‘ctrl’ when deselecting. If you execute so, you’ll lose your an option and instead pick whatever you simply clicked.


With the deselect tool, yes no need for you to cancel your an option if you consisted of the not correct cells. But take note, you have to be utilizing Excel 2019 or have actually an Office 365 subscription to be able to use this feature.

See more: How Much Weight Can A Paver Driveway Hold, All Your Questions About Pavers, Answered


Kasper Langmann, Co-founder the tennis2007.org

tennis2007.org ApS

Address: rose oil Brandenburgs Vej 58, 3.tv, 2450 København SV, Denmark.

VAT-ID: DK-40428631

Zero come Hero: become an Excel-Superuser in 14 hours

VBA Masterclass: become a VBA-Pro in 20 hours

Power BI Essentials: learn Power BI in 12 hours

Team Solution: for Businesses and also Organizations


We’ve released +100 Excel-tutorials on ours blog. Right here are our top 3 picks:

1:The last overview to VLOOKUP you’ll ever need

2: just how to Delete blank Rows Easily

3: INDEX+MATCH through multiple criteria in 5 straightforward steps

Pssst… Make certain to examine out our totally free Excel training the adapts to your ability level too!