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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies