SOLVED
Home

issue in Selecting cells using Shift + downward arrow

%3CLINGO-SUB%20id%3D%22lingo-sub-479195%22%20slang%3D%22en-US%22%3Eissue%20in%20Selecting%20cells%20using%20Shift%20%2B%20downward%20arrow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-479195%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20earlier%20I%20used%20to%20select%20the%20cells%20having%20values%20using%20Shift%20%2B%20downward%20arrow%20%2F%20side%20ward%20arrows.%20If%20i%20need%20to%20select%20100%20cells%20which%20is%20having%20values%20in%20one%20click%20(vertical)%2C%20i%20used%20to%20click%201st%20cell%20and%20then%20press%20Shift%20%2B%20Downward%20arrow%20so%20that%20complete%20100%20cells%20will%20be%20selected.%20But%20recently%20this%20function%20is%20not%20working.%20If%20I%20press%20Shift%20%2B%20down%20arrow%20%2F%20side%20arrows%20it%20is%20not%20selecting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help%20on%20this%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-479195%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-479391%22%20slang%3D%22en-US%22%3ERe%3A%20issue%20in%20Selecting%20cells%20using%20Shift%20%2B%20downward%20arrow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-479391%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F324788%22%20target%3D%22_blank%22%3E%40KMadhan1983%3C%2FA%3E%26nbsp%3B%2C%20to%20select%20entire%20range%20till%20first%20blank%20cell%20that's%20Ctrl%2BShift%2BArrowDown.%26nbsp%3B%20Select%20current%20and%20next%20cell%20that's%26nbsp%3BShift%2BArrowDown.%20IMHO%2C%20that%20was%20all%20the%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-479439%22%20slang%3D%22en-US%22%3ERe%3A%20issue%20in%20Selecting%20cells%20using%20Shift%20%2B%20downward%20arrow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-479439%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThanks%20for%20your%20reply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20really%20sorry%20that%20instead%20of%20mentioning%20Shift%2BCtrl%2BArrow%20Down%20I%20have%20written%20Shift%2BArrow%20Down.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShift%2BCtrl%2BArrow%20Down%20to%20select%20the%20entire%20range%20is%20not%20working%20for%20me.%20Is%20there%20anything%20in%20settings%20I%20need%20to%20do%20changes%3F%20Please%20suggest.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-479492%22%20slang%3D%22en-US%22%3ERe%3A%20issue%20in%20Selecting%20cells%20using%20Shift%20%2B%20downward%20arrow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-479492%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F324788%22%20target%3D%22_blank%22%3E%40KMadhan1983%3C%2FA%3E%26nbsp%3B%2C%20the%20only%20setting%20I%20know%20-%20this%20one%20shall%20be%20unchecked%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20405px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F109793i2A54E5597716EDCE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-479751%22%20slang%3D%22en-US%22%3ERe%3A%20issue%20in%20Selecting%20cells%20using%20Shift%20%2B%20downward%20arrow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-479751%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%3C%2FP%3E%3CP%3EIt's%20working%20properly%20now.%3C%2FP%3E%3CP%3E%26nbsp%3BThank%20you%20once%20again%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-480146%22%20slang%3D%22en-US%22%3ERe%3A%20issue%20in%20Selecting%20cells%20using%20Shift%20%2B%20downward%20arrow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-480146%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F324788%22%20target%3D%22_blank%22%3E%40KMadhan1983%3C%2FA%3E%26nbsp%3B%2C%20good%2C%20glad%20to%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
KMadhan1983
New Contributor

Hi, earlier I used to select the cells having values using Shift + downward arrow / side ward arrows. If i need to select 100 cells which is having values in one click (vertical), i used to click 1st cell and then press Shift + Downward arrow so that complete 100 cells will be selected. But recently this function is not working. If I press Shift + down arrow / side arrows it is not selecting.

 

Can someone help on this issue?

 

Thanks 

5 Replies

@KMadhan1983 , to select entire range till first blank cell that's Ctrl+Shift+ArrowDown.  Select current and next cell that's Shift+ArrowDown. IMHO, that was all the time.

@Sergei Baklan Thanks for your reply.

 

And really sorry that instead of mentioning Shift+Ctrl+Arrow Down I have written Shift+Arrow Down.

 

Shift+Ctrl+Arrow Down to select the entire range is not working for me. Is there anything in settings I need to do changes? Please suggest.

Thanks

 

Solution

@KMadhan1983 , the only setting I know - this one shall be unchecked

image.png

 

Thank you so much @Sergei Baklan

It's working properly now.

 Thank you once again

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies