In Excel 365 "ctrl click" on a selected cell will deselect it. When was this feature implmented?
Karen is a friend of mine whose Excel 365 has a neat "cell deselection" feature:
For instance, she can select [1:20] then delselect rows 5 10 by ctrl clicking on them. She is left with [1:4,6:9,11:20].
My version of 2016 and does not have this feature.
I always thought that Excel 365 was built on top of Excel 2016 so I was surprised by this difference.
One theory I have is that both versions are indeed identical, but that some registry entry enables the deselection on her computer but not on mine.
Can anybody point me to documentation about when this feature was first introduced?
rberke
P.S.
15 years ago I implemented an Excel 2003 Personal.xls program to support the feature. Since then I have migrated through Excel 2007, 2010 and 2013. None of them supported deselection unless I added personal.xls to XLSTART.
For instance, she can select [1:20] then delselect rows 5 10 by ctrl clicking on them. She is left with [1:4,6:9,11:20].
My version of 2016 and does not have this feature.
I always thought that Excel 365 was built on top of Excel 2016 so I was surprised by this difference.
One theory I have is that both versions are indeed identical, but that some registry entry enables the deselection on her computer but not on mine.
Can anybody point me to documentation about when this feature was first introduced?
rberke
P.S.
15 years ago I implemented an Excel 2003 Personal.xls program to support the feature. Since then I have migrated through Excel 2007, 2010 and 2013. None of them supported deselection unless I added personal.xls to XLSTART.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Karen Falandays
Hey there Bob, I still want to test on 2013, but it looks like it is, indeed, a new feature as stated in this Microsoft support link https://support.office.com/en-us/article/Deselect-a-selection-d1b56f30-7d63-4a64-8f0b-da4958204b52
ASKER
PeeterB: That is exactly what I wanted.
Karen: Thanks again for you help over the phone yesterday, and special thanks for pointing out the new feature.
Anybody else who is interested. I have created an Excel add in that adds the Deselect functionality to Excel 2003 through 2016. If enough people are interested I could write an EE article and post it.
Bob
Karen: Thanks again for you help over the phone yesterday, and special thanks for pointing out the new feature.
Anybody else who is interested. I have created an Excel add in that adds the Deselect functionality to Excel 2003 through 2016. If enough people are interested I could write an EE article and post it.
Bob