Home

Unable to deselect in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-204851%22%20slang%3D%22en-US%22%3EUnable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-204851%22%20slang%3D%22en-US%22%3EYesterday%20when%20I%20selected%20multiple%20cells%20in%20a%20Microsoft%20Excel%202016%20worksheet%2C%20I%20could%20hold%20CTRL%20key%20and%20deselect%20the%20cells%20I%20wanted%20removed.%20But%20for%20some%20reason%20TODAY%20when%20I%20hold%20down%20Ctrl%20and%20then%20click%20cells%20in%20order%20to%20remove%20them%20from%20the%20selection%2C%20the%20cell%20shading%20becomes%20darker%2C%20and%20the%20cells%20are%20not%20unselected.%20Additionally%2C%20the%20cell%20shading%20continues%20to%20darken%20if%20you%20repeatedly%20click%20the%20cells.%20I%E2%80%99ve%20been%20using%20the%20ctrl%20key%20to%20deselect%20cells%20easily%20hundreds%20of%20times%20a%20day%20over%20the%20last%202%20months%2C%20it%E2%80%99s%20fundamental%20to%20my%20use%20of%20excel.%20I%20have%20no%20idea%20why%20all%20of%20the%20sudden%20I%20am%20unable%20to%20deselect%20using%20ctrl%2C%20but%20I%20could%20really%20use%20some%20help.%20I%E2%80%99ve%20spent%20a%20majority%20of%20my%20day%20trying%20to%20solve%20this%2C%20and%20I%20can%E2%80%99t%20find%20any%20solutions.%20In%20fact%20the%20Microsoft%20support%20website%20says%20%E2%80%9Cthe%20behavior%20is%20by%20design%2C%E2%80%9D%20and%20their%20solution%20is%20to%20just%20redo%20your%20selection!%20Ugghhh!%3CBR%20%2F%3EHow%20can%20I%20go%20from%20deselecting%20perfectly%20yesterday%20to%20double%20selecting%20today!%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-204851%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-652247%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-652247%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89%22%20target%3D%22_blank%22%3E%40Olaf%20Hubel%3C%2FA%3E%26nbsp%3BI%20have%20to%20say%20...%20brilliant%20answer.%20Just%26nbsp%3Bexquisite.%3C%2FP%3E%3CP%3EA%20bug%20that%20uncovered%20a%20feature.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENext%20time%20some%20will%20tell%20us%20that%20a%20computer%20could%20run%20twice%20as%20fast%20if%20we%20installed%20windows%2010%20pro%20instead%20of%20home.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-363008%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363008%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%20for%20all%20the%20confusion%20around%20this.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20Deselect%20feature%20is%20an%20Office%20365%20(Home%2C%20Business%2C%20%E2%80%A6.)%20and%20Office%202019%20feature.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20means%20it%20does%20not%20work%20in%20Office%202016.%20We%20had%20a%20bug%20where%20it%20was%20turned%20on%20for%20a%20very%20short%20time%20by%20mistake%20in%20Office%202016.%20We%20have%20fixed%20this%20bug%2C%20this%20happend%20at%20the%20same%20time%20we%20also%20had%20to%20disable%20the%20feature%20for%20a%20month%20in%20Office%20365.%20After%20we%20fixed%20all%20open%20issues%20we%20turned%20it%20back%20on%20for%20Office%20365.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20deselect%20feature%20never%20existed%20in%20Office%202016%20(or%20any%20other%20older%20version).%20We%20created%20this%20feature%20in%20late%202017.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20hope%20this%20answers%20your%20question.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOlaf%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-362986%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-362986%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20is%20this%20going%20to%20be%20resolved%20for%20Office%202016%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20downloaded%20the%20last%20update%20a%20minute%20ago%20and%20I%20am%20still%20not%20able%20to%20deselect%20in%20Excel.%20Unacceptable!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20generally%20like%20Excel%2C%20but%20to%20have%20a%20basic%20function%20disappear%20overnight%20and%20still%20not%20be%20restored%20months%20later....%20no.%20Plus%2C%20now%20I'm%20in%20fear%20of%20ever%20updating%20again%2C%20because...%20who%20knows%20what%20the%20next%20update%20will%20break%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20*thisclose*%20to%20switching%20to%20LibreOffice%20and%20never%20buying%20any%20version%20of%20MS%20Office%20again%2C%20and%20that%20option%20is%20looking%20better%20and%20better%20all%20the%20time...%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-330574%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-330574%22%20slang%3D%22en-US%22%3E%3CP%3EWould%20appreciate%20if%20you%20can%20comment%2Fanalyze%20my%20same%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-315383%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-315383%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%20to%20hear%20your%20having%20problems%20with%20this%20feature.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20is%20fully%20enabled%20for%20all%20subscription%20users%20and%20Office%202019%20perpetual.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOffice%20Pro%20Plus%20is%20part%20of%20Office%20365%2C%20this%20is%20why%20your%20able%20to%20be%20on%20the%20monthly%20channel.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYour%20build%20should%20have%20this%20feature%20enabled.%20Can%20you%20DM%20me%20a%20screenshot%20of%20the%20account%20settings%20page%20in%20Excel%3F%20This%20will%20help%20me%20try%20and%20troubleshoot%20what%20is%20possible%20going%20on.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%3C%2FP%3E%0A%3CP%3EOlaf%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-315175%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-315175%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20recently%20installed%20the%20latest%20updates...%3C%2FP%3E%3CP%3EStill%20no%20deselection%20feature%20available.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVersion%201812%20Build%2011126.20266%20Click%26amp%3BRun%2C%20monthly%20channel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anybody%20who%20can%20use%20the%20feature%20successfully%3F%3C%2FP%3E%3CP%3EWhen%20will%20it%20be%20available%20to%20Excel%202016%20users%20again%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20no%20Office%20360%20but%20Professional%20Plus...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304568%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304568%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20there%20users%20with%20the%20latest%20updates%20for%20whom%20the%20deselect%20works%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-283588%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-283588%22%20slang%3D%22en-US%22%3EAre%20you%20logged%20into%20Office%20with%20an%20Office%20365%20account%20on%20both%20devices%3F%20If%20so%20can%20you%20please%20sent%20a%20frown%20(click%20on%20file%2C%20feedback%2C%20I%20don't%20like%20something).%20Please%20mention%20my%20name%20in%20the%20text%20(so%20I%20can%20search%20for%20it).%20This%20will%20help%20us%20troubleshoot%20any%20possible%20issues.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-283429%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-283429%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20currently%20having%20this%20issue.%20I%20have%20the%20same%20version%20of%20Excel%20on%20two%20different%20laptops.%20On%20one%20the%20deselect%20option%20works%2C%20the%20other%20laptop%20however%20does%20not%20work%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-282746%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-282746%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20chance%20that%20it%20will%20get%20fixed%3F%3C%2FP%3E%3CP%3EWhy%20do%20big%20companies%20keep%20trying%20to%20fix%20what%20it%20is%20not%20broken%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-264380%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-264380%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20in%20the%20same%20boat%2C%20this%20feature%20worked%20last%20week%20and%20not%20this%20week%3F%26nbsp%3B%20I'm%20confused%20how%20different%20users%20have%20this%20problem%20starting%20at%20different%20times%20(for%20some%20people%20this%20started%20much%20earlier%20than%20September)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-252756%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-252756%22%20slang%3D%22en-US%22%3E%3CP%3EDoesnt%20work%20for%20me%20too%20on%20my%20computer%20at%20work.%20It%20was%20working%20last%20week.%20Really%20disturbing...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251325%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251325%22%20slang%3D%22en-US%22%3E%3CP%3ESo%2C%20why%20isn't%20this%20fixed%20yet.%26nbsp%3B%20I%20was%20able%20to%20use%20it%20Friday%2C%20but%20today%20I%20am%20not.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20ran%20an%20update%26nbsp%3Band%20still%20nothing.%26nbsp%3B%20Please.......%20I%20need%20this%20feature.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-236998%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-236998%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20had%20a%20user%20mention%20this%20bug%20today%20--%20but%20we%20have%20Office%20Professional%202016%20(VLSC%20version)%20and%20not%20the%20O365%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20fix%20coming%20out%20in%20September's%20Patch%20Tuesday%20releases%3F%20%26nbsp%3BOr%20was%20this%20supposed%20to%20be%20in%20the%20August%20updates%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-216767%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216767%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89%22%20target%3D%22_blank%22%3E%40Olaf%20Hubel%3C%2FA%3EI%20have%20an%20O365%20Enterprise%20subscription%20currently%20running%20Version%201805%20(Monthly%20Channel)%20and%26nbsp%3BI'm%20anxiously%20awaiting%20this%20fix.%20Should%20I%20expect%20to%20notice%20when%20this%20fix%20has%20taken%20effect%3F%20For%20example%2C%20will%20it%20be%20part%20of%20an%20update%20that%20I%20have%20to%20install%20or%20perhaps%20a%20less%20obvious%20method%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-215128%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-215128%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20fix%20is%20rolling%20out%20and%20many%20of%20you%20should%20already%20have%20the%20fix.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20takes%20some%20time%20to%20roll%20out%20to%20everybody.%20But%20if%20it%20is%20not%20working%20for%20you%20now%20it%20should%20soon.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-210332%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-210332%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89%22%20target%3D%22_blank%22%3E%40Olaf%20Hubel%3C%2FA%3Eany%20ETA%20on%20the%20fix%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205776%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205776%22%20slang%3D%22en-US%22%3ECorrect%2C%20we%20already%20pushed%20the%20fix%20there%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205772%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205772%22%20slang%3D%22en-US%22%3E%3CP%3EExcept%20Insider%20Fast%20i%20guess%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205770%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205770%22%20slang%3D%22en-US%22%3E%3CP%3EShould%20be%20back%20in%20couple%20of%20weeks.%20It%20is%20not%20related%20to%20your%20update%2C%20we%20turned%20it%20off%20for%20all%20build%20numbers.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205768%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205768%22%20slang%3D%22en-US%22%3EOlaf%2C%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20is%20this%20functionality%20returning%3F%20I%20am%20currently%20on%20version%201805.%20Prior%20to%20update%20deselect%20was%20working%20properly.%20Any%20insight%20into%20when%20this%20may%20return%20it%20is%20very%20detrimental%20to%20our%20work%20practices%20and%20efficiency.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205420%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205420%22%20slang%3D%22en-US%22%3EThanks%2C%20we%20love%20it%20too.%20It%20will%20come%20back%20very%20shortly.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205389%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205389%22%20slang%3D%22en-US%22%3E%3CP%3EOlaf%2C%3C%2FP%3E%3CP%3EPlease%20don't%20abandon%20this%20add%20in%2C%20as%20it%20really%20saves%20me%20time.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205375%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205375%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20found%20an%20issue%20with%20the%20deselect%20feature%20and%20decided%20to%20temporarily%20disable%20it.%20As%20soon%20as%20the%20fix%20has%20been%20pushed%20out%20to%20all%20users%20we%20will%20enable%20the%20feature%20again.%20This%20should%20be%20in%20the%20next%20couple%20of%20weeks.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%3C%2FP%3E%0A%3CP%3EOlaf%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205192%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205192%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20I'm%20correct%20about%20the%20bug%20that's%20only%20to%20wait%20another%20build%20with%20the%20fix.%20Shift%2BF8%20also%20doesn't%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205186%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205186%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20resolve%20it%3F%20Can%20procedure%20available%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205148%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205148%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20looks%20like%20a%20bug%3C%2FP%3E%0A%3CP%3E-%20doesn't%20work%20on%20the%20build%201806.10228.20062%3C%2FP%3E%0A%3CP%3E-%20no%20problems%20on%201807.10308.20006%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-204940%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-204940%22%20slang%3D%22en-US%22%3E%3CP%3EPerhaps%20that's%20related%20to%20the%20bug%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89%22%20target%3D%22_blank%22%3E%40Olaf%20Hubel%3C%2FA%3E%26nbsp%3Bmentioned%20more%20close%20to%20the%20bottom%20of%20discussion%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel-Blog%2FHow-to-deselect-cells-from-selected-ranges-in-Excel%2Fbc-p%2F204840%23M223%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel-Blog%2FHow-to-deselect-cells-from-selected-ranges-in-Excel%2Fbc-p%2F204840%23M223%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBy%20the%20way%2C%20I%20checked%20and%20have%20same%20behaviour%20as%20you%20are%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-657908%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-657908%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89%22%20target%3D%22_blank%22%3E%40Olaf%20Hubel%3C%2FA%3E%26nbsp%3BI'm%20an%20Office365%20Proplus%20subscriber%20-%20I%20will%20cannot%20deselect.%20Why%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-721580%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-721580%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89%22%20target%3D%22_blank%22%3E%40Olaf%20Hubel%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20Office%20Professional%20Plus%202016%20and%20have%20been%20using%20that%20feature%20for%20several%20months%20now.%26nbsp%3B%20Yesterday%20when%20I%20tried%20to%20use%20it%2C%20it%20did%20not%20work.%3CBR%20%2F%3E%3CBR%20%2F%3EWhether%20it%20is%20intentionally%20added%20to%20Office%202016%2C%20why%20would%20you%20disable%20it%3F%26nbsp%3B%20This%20looks%20like%20just%20another%20in%20a%20long%20line%20of%20examples%20in%20which%20the%20people%20working%20for%20Microsoft%20don't%20give%20a%20crap%20about%20the%20people%20who%20buy%20their%20products.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-723195%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-723195%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89%22%20target%3D%22_blank%22%3E%40Olaf%20Hubel%3C%2FA%3E%26nbsp%3BAny%20further%20word%20on%20this%3F%20The%20feature%20is%20still%20disabled%20for%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-724803%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20deselect%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724803%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351834%22%20target%3D%22_blank%22%3E%40NickADD%3C%2FA%3E%26amp%3B%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89%22%20target%3D%22_blank%22%3E%40Olaf%20Hubel%3C%2FA%3E%20I%20am%20still%20disable%20too%20nothing%20new.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETrying%20to%20find%20work%20arounds%20for%20times%20when%20I%20used%20to%20use%20it%20but%20that%20is%20not%20the%20best%20solution...%20right%20now%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20going%20to%20try%20to%20reach%20out%20to%20my%20IT%20Person%20to%20see%20if%20I%20could%20just%20uninstall%20and%20reinstall%20the%20program%20while%20I%20am%20on%20PTO%20so%20my%20work%20is%20not%20delayed%3C%2FP%3E%3C%2FLINGO-BODY%3E
null null
Occasional Visitor
Yesterday when I selected multiple cells in a Microsoft Excel 2016 worksheet, I could hold CTRL key and deselect the cells I wanted removed. But for some reason TODAY when I hold down Ctrl and then click cells in order to remove them from the selection, the cell shading becomes darker, and the cells are not unselected. Additionally, the cell shading continues to darken if you repeatedly click the cells. I’ve been using the ctrl key to deselect cells easily hundreds of times a day over the last 2 months, it’s fundamental to my use of excel. I have no idea why all of the sudden I am unable to deselect using ctrl, but I could really use some help. I’ve spent a majority of my day trying to solve this, and I can’t find any solutions. In fact the Microsoft support website says “the behavior is by design,” and their solution is to just redo your selection! Ugghhh!
How can I go from deselecting perfectly yesterday to double selecting today!?
32 Replies

Perhaps that's related to the bug @Olaf Hubel mentioned more close to the bottom of discussion here https://techcommunity.microsoft.com/t5/Excel-Blog/How-to-deselect-cells-from-selected-ranges-in-Exce...

 

By the way, I checked and have same behaviour as you are

Yes, looks like a bug

- doesn't work on the build 1806.10228.20062

- no problems on 1807.10308.20006

How to resolve it? Can procedure available?

If I'm correct about the bug that's only to wait another build with the fix. Shift+F8 also doesn't work.

We have found an issue with the deselect feature and decided to temporarily disable it. As soon as the fix has been pushed out to all users we will enable the feature again. This should be in the next couple of weeks. 

 

Thanks

Olaf

Olaf,

Please don't abandon this add in, as it really saves me time. 

Thanks, we love it too. It will come back very shortly.
Olaf,

When is this functionality returning? I am currently on version 1805. Prior to update deselect was working properly. Any insight into when this may return it is very detrimental to our work practices and efficiency.

Should be back in couple of weeks. It is not related to your update, we turned it off for all build numbers. 

Except Insider Fast i guess

Correct, we already pushed the fix there

@Olaf Hubelany ETA on the fix?

The fix is rolling out and many of you should already have the fix. 

It takes some time to roll out to everybody. But if it is not working for you now it should soon. 

@Olaf HubelI have an O365 Enterprise subscription currently running Version 1805 (Monthly Channel) and I'm anxiously awaiting this fix. Should I expect to notice when this fix has taken effect? For example, will it be part of an update that I have to install or perhaps a less obvious method?

Hi!

 

We had a user mention this bug today -- but we have Office Professional 2016 (VLSC version) and not the O365 version.

 

Is this fix coming out in September's Patch Tuesday releases?  Or was this supposed to be in the August updates?

 

Thanks!

So, why isn't this fixed yet.  I was able to use it Friday, but today I am not. 

I just ran an update and still nothing.  Please....... I need this feature. 

Doesnt work for me too on my computer at work. It was working last week. Really disturbing...

I am in the same boat, this feature worked last week and not this week?  I'm confused how different users have this problem starting at different times (for some people this started much earlier than September)

Hello,

 

Any chance that it will get fixed?

Why do big companies keep trying to fix what it is not broken?

I am currently having this issue. I have the same version of Excel on two different laptops. On one the deselect option works, the other laptop however does not work

Are you logged into Office with an Office 365 account on both devices? If so can you please sent a frown (click on file, feedback, I don't like something). Please mention my name in the text (so I can search for it). This will help us troubleshoot any possible issues.

Hello,

 

Are there users with the latest updates for whom the deselect works?

 

Thank you.

Hi,

I recently installed the latest updates...

Still no deselection feature available.

 

Version 1812 Build 11126.20266 Click&Run, monthly channel

 

Is there anybody who can use the feature successfully?

When will it be available to Excel 2016 users again?

 

 

I have no Office 360 but Professional Plus...

Sorry to hear your having problems with this feature. 

It is fully enabled for all subscription users and Office 2019 perpetual. 

 

Office Pro Plus is part of Office 365, this is why your able to be on the monthly channel. 

 

Your build should have this feature enabled. Can you DM me a screenshot of the account settings page in Excel? This will help me try and troubleshoot what is possible going on. 

 

Thanks,

Olaf

Would appreciate if you can comment/analyze my same issue.

When is this going to be resolved for Office 2016? 

 

I just downloaded the last update a minute ago and I am still not able to deselect in Excel. Unacceptable!  

 

I generally like Excel, but to have a basic function disappear overnight and still not be restored months later.... no. Plus, now I'm in fear of ever updating again, because... who knows what the next update will break? 

 

I'm *thisclose* to switching to LibreOffice and never buying any version of MS Office again, and that option is looking better and better all the time... 

Sorry for all the confusion around this. 

 

The Deselect feature is an Office 365 (Home, Business, ….) and Office 2019 feature. 

This means it does not work in Office 2016. We had a bug where it was turned on for a very short time by mistake in Office 2016. We have fixed this bug, this happend at the same time we also had to disable the feature for a month in Office 365. After we fixed all open issues we turned it back on for Office 365. 

 

The deselect feature never existed in Office 2016 (or any other older version). We created this feature in late 2017.

 

I hope this answers your question. 

 

Olaf

@Olaf Hubel I have to say ... brilliant answer. Just exquisite.

A bug that uncovered a feature.

 

Next time some will tell us that a computer could run twice as fast if we installed windows 10 pro instead of home.

@Olaf Hubel I'm an Office365 Proplus subscriber - I will cannot deselect. Why?

@Olaf Hubel

 

I have Office Professional Plus 2016 and have been using that feature for several months now.  Yesterday when I tried to use it, it did not work.

Whether it is intentionally added to Office 2016, why would you disable it?  This looks like just another in a long line of examples in which the people working for Microsoft don't give a crap about the people who buy their products.

@Olaf Hubel Any further word on this? The feature is still disabled for me.

@NickADD& @Olaf Hubel I am still disable too nothing new.

 

Trying to find work arounds for times when I used to use it but that is not the best solution... right now

 

I am going to try to reach out to my IT Person to see if I could just uninstall and reinstall the program while I am on PTO so my work is not delayed