Home
Microsoft

How to deselect cells from selected ranges in Excel

We are excited to announce that Excel now lets you deselect cells or a range from your current selection. This was one of the top request we got from our community and we are happy to announce we have rolled it out for PC and Mac subscription users of Office 365.  

 

How to unselect a cell from a selection

To unselect a selected cell hold down the CTRL (or Command on mac) key and click on the cells you want to deselect. To unselect a range of selected cells hold down the CTRL (or Command for Mac) key and drag the range you want to deselect, starting from within a selected range.

 

Smile3.gifDeselect a selected cell in Excel

How to multi select cells or ranges

This has not changed, you can still use the CTRL (or Command on Mac) key to click on an unselected cell to select it. To select an additional range simple use the CTRL (or Command on mac), starting on a unselected cells and drag the mouse to select the range.

 

select.gifSelect multiple cells or ranges in Excel

 

15 Comments
Occasional Visitor

What about Office 2016? Will it have this?

Microsoft

These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates.

Occasional Visitor

Hello @Olaf Hubel,

 

Serious question, how'd you guys **bleep** this up? I cannot select ranges within my original selection as subgroups without **bleep**ing everything up. You took a community request to deselect cells and **bleep**ed up the already working multi-select.

 

Here is what happens when I use your new multi-select function as it is changed because of how you chose to implement your "deselect"

 

https://imgur.com/a/G9t6l

Microsoft

Hi @Phillip Perin,

Can you give me some more background why you wanted to select a range within a range. I understand what you expected to happen based on your image. But like to learn more about what you where trying to do. 

 

Thanks,

Olaf

Occasional Visitor

Dear Mr. Hubel,

It will be appriciated if you let me know that is there any plan to update this feature (deselect) to Excel 2013.

Microsoft

Hi, @JC Kim, sorry this is a 2016 subscription or later feature. 

 

These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates.

 

Occasional Visitor

@Olaf Hubel We all know they're available for Office 365, dumbass! You don't have to repeat that every single time.

Occasional Visitor

@Olaf Hubel

 

Basically anything, the current unselect changes how the entire re-select works. But specifically when I am highlighting cells to apply borders to them - just as is seen in the image set I provided.

Occasional Visitor

Dear Mr. Hubel,

I'm using Office 2016 ver 1801 build 9001.2138 and updated everything (I think)

And still cannot use deselect. Is there anything to join?

Microsoft

@Phillip Perin Yes when making multi range selections to quickly set borders, you now need to do those as separate steps. In your image this would mean a extra click. We tried to avoid impacts like this as much as we would but in some edge cases you might need to make extra clicks. 

 

@JC Kim I am not 100% sure why it is not showing for you yet, based on the build number it should, unless your an enterprise release channel. We roll this out in stages and this might take some time. Make sure that your version says "Office 365 Pro Plus" and not just "Office ProPlus". If all is good it should not take to long before it will start working. Nothing you will need to do from your side. 

 

Naturally you can always join insiders to get features even sooner, but in this case that is not needed as we have rolled out to production. 

 

Thanks,

Olaf

Occasional Contributor

Should this be available in Excel on line at this time for Enterprise tenants?  I tried to deselect a few cells but it did not work for me.

Microsoft

Hi @Charles Shaw,

 

No not yet.

 

It is on the backlog

Occasional Visitor

@Olaf Hubel,

 

I like the functionality, have been waiting for this for (literally) decades.

I do have a question though: Prior to this change, selecting / clicking the same cell multiple times made the background color of that cell keep getting darker, which I got used to during this last decades, for instance to quickly count occurrences of values. Is there any way to use this multiple-select-of-a-cell-makes-the-background-darker functionality as well?

 

Kind regards,

Arnoud

Microsoft

Hi @Arnoud van Bokkem

Sorry we did not add a second shortcut to be able to double select single cells. 

Occasional Visitor

Hello,

 

I am sad to hear that the possibillity of double selecting cels has dissapeared.

I often use that for calculating Sums or Averages in Situations as you see below.

I first select the cels B2:E6, F2:I6, B7:E11, F7:I11 and then over that selection I select B2:J12.

Then I use the Sum (or Average) button and in all the empty cells the Sum Or Average is calculate in the correct way.

This is now impossible. Now I have to do this in steps, as the latest selection B2:J12 deselects the previous selections.

It would be great if it would stil be possible to double select cells.

I must say that in certain situations the new way is handy. But I really miss the old possibillity certainly in sheets that are bigger than this example.

 

 JanuariFebruariMaartKwartaal 1AprilMeiJuniKwartaal 2Totaal
Marieke100 010  
Chris023 006  
Lucas222 001  
Kathy000 000  
Afdeling 1    017  
Rick020 102  
Joost000 000  
Fred100 110  
Paula000 210  
Afdeling 2120 422  
Totaal