Excel 2019 every so often will not let me select; Enter key

%3CLINGO-SUB%20id%3D%22lingo-sub-1564316%22%20slang%3D%22en-US%22%3EExcel%202019%20every%20so%20often%20will%20not%20let%20me%20select%3B%20Enter%20key%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564316%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%202019%20every%20so%20often%20will%20not%20let%20me%20select%3B%20today%20it%20was%20two%20adjacent%20cells%2C%20one%20with%20text%2C%20one%20with%20a%20number.%26nbsp%3B%20I%20could%20click%20on%20one%20but%20Shift-Arrow%20would%20not%20extend%20the%20selection.%26nbsp%3B%20I%20was%20able%20to%20get%20it%20working%20again%20by%20selecting%20Sheet%202%20(empty)%20and%20then%20back%20to%20Sheet%201.%26nbsp%3B%20Can%20anyone%20explain%20what%20is%20going%20on%3F%26nbsp%3B%20Help%20says%20that%20F8%20can%20be%20used%20to%20turn%20on%2Foff%20Extend%2C%20but%20I%20don't%20use%20F8.%20And%20using%20F8%20turns%20on%20a%20label%20Extend%20Selection%20but%20it%20seems%20to%20work%20the%20same%20with%20it%20or%20without.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20could%20be%20related%20to%20another%20problem%2C%20the%20Enter%20key%20often%20causes%20a%20jump%20to%20another%20open%20spreadsheet.%26nbsp%3B%20It%20should%20be%20selectable%20whether%20to%20move%20down%20or%20move%20right%2C%20and%20for%20now%20I%20have%20it%20do%20nothing.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1564316%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Excel 2019 every so often will not let me select; today it was two adjacent cells, one with text, one with a number.  I could click on one but Shift-Arrow would not extend the selection.  I was able to get it working again by selecting Sheet 2 (empty) and then back to Sheet 1.  Can anyone explain what is going on?  Help says that F8 can be used to turn on/off Extend, but I don't use F8. And using F8 turns on a label Extend Selection but it seems to work the same with it or without. 

 

This could be related to another problem, the Enter key often causes a jump to another open spreadsheet.  It should be selectable whether to move down or move right, and for now I have it do nothing. 

0 Replies