Home

Help! - Control -Alt- arrow keys not working to select multiple cells

%3CLINGO-SUB%20id%3D%22lingo-sub-738531%22%20slang%3D%22en-US%22%3EHelp!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738531%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20on%20a%20surface%20pro%20and%20the%20control%20alt%20arrow%20key%20combination%20has%20randomly%20stopped%20working%20to%20select%20multiple%20rows%20and%20columns-%3CBR%20%2F%3EDoes%20anyone%20know%20the%20fix%20for%20this%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-738531%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738549%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738549%22%20slang%3D%22en-US%22%3EWhat%20I%20know%20is%20that%20it%20should%20be%3A%3CBR%20%2F%3ECtrl%2BShift%2BArrowKey%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738574%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738574%22%20slang%3D%22en-US%22%3EThat%20doesn%E2%80%99t%20work%20either.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738575%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738575%22%20slang%3D%22en-US%22%3EThat%20doesn%E2%80%99t%20work%20either.%20I%E2%80%99ve%20tried%20that%20to%20select%20all%20data%20right%20of%20A1%20and%20down%20to%20the%20bottom%20of%20the%20csv%20file%20but%20it%20stops%20after%20selecting%20all%20populated%20cells%20to%20the%20right%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738588%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738588%22%20slang%3D%22en-US%22%3EYou%20have%20to%20open%20your%20file%20in%20Excel%2C%20whereafter%20you%20execute%20the%20key%20combination.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738589%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738589%22%20slang%3D%22en-US%22%3EDoes%20it%20work%20if%20you%20disable%20your%20add-ins%20one-by-one%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738593%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738593%22%20slang%3D%22en-US%22%3EI%E2%80%99ll%20try%20that%20and%20let%20you%20know%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738594%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738594%22%20slang%3D%22en-US%22%3EI%20don%E2%80%99t%20think%20I%E2%80%99m%20understanding%20you.%20Keep%20in%20mind%20I%E2%80%99ve%20done%20this%20function%20thousands%20of%20time%20before%20and%20now%20the%20keys%20are%20simply%20not%20working.%3CBR%20%2F%3EI%20do%20have%20the%20Excel%20file%20open%20-%20And%20I%20am%20executing%20these%20key%20functions%20after%20the%20file%20is%20open%20and%20I%E2%80%99m%20clicked%20on%20a%20cell.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738609%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738609%22%20slang%3D%22en-US%22%3EI%20see.%20Perhaps%2C%20the%20culprit%20is%20one%20of%20the%20add-ins%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%20is%20referring%20to%20in%20his%20suggestion.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-739354%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-739354%22%20slang%3D%22en-US%22%3EUnfortunately%20that%20didn%E2%80%99t%20work%20either%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-739375%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-739375%22%20slang%3D%22en-US%22%3EWhat%20about%20COM%20add-ins%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-739411%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-739411%22%20slang%3D%22en-US%22%3EUnfortunately%20for%20whatever%20reason%20I%E2%80%99m%20not%20getting%20any%20option%20to%20disable%20those%20add-ons.%20It%20will%20show%20me%20what%20is%20disabled%20and%20what%E2%80%99s%20not%20but%20there%20is%20not%20an%20option%20to%20disable.%20I%20even%20had%20a%20friend%20who%20does%20IT%20look%20at%20that%20screenshot%20as%20I%20can%E2%80%99t%20post%20it%20here%20and%20they%20were%20puzzled%20by%20why%20I%20didn%E2%80%99t%20have%20an%20option%20to%20disable%20any%20ad%20ins.%20My%20guess%20is%20that%E2%80%99s%20going%20to%20be%20an%20administrative%20setting%20issue.%20Our%20company%20IT%20team%20is%20on%20vacation%20so%20at%20some%20point%20hopefully%20I%E2%80%99ll%20be%20able%20to%20get%20them%20to%20take%20a%20look%20at%20it.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-740215%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740215%22%20slang%3D%22en-US%22%3EI'm%20talking%20about%20the%20dialog%20that%20comes%20up%20when%20you%20click%3A%3CBR%20%2F%3E-%20File%2C%20Options%2C%20Add-ins%20tab%3CBR%20%2F%3E-%20Click%20Drop-down%20near%20bottom%2C%20select%20COM%20add-ins%3CBR%20%2F%3E-%20CLick%20Go...%20button.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-740920%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740920%22%20slang%3D%22en-US%22%3EOk%20tried%20that-%20I%20disabled%20one%20by%20one%20and%20still%20no%20luck.%3CBR%20%2F%3EI%E2%80%99m%20wondering%20if%20a%20system%20restore%20might%20work%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-741960%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-741960%22%20slang%3D%22en-US%22%3EDoes%20it%20work%20if%20you%20start%20Excel%20in%20safe%20mode%20(hold%20donw%20control%20key%20while%20Excel%20starts)%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-742929%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-742929%22%20slang%3D%22en-US%22%3EOk%20I%20figured%20it%20out-%20below%20is%20the%20fix%20%3A%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20Options%3CBR%20%2F%3E2.%20Advanced%3CBR%20%2F%3E3.%20Scroll%20all%20the%20way%20down%3CBR%20%2F%3E4.%20Look%20for%20lotus%20compatibility%3CBR%20%2F%3E5.%20Uncheck%20all%20boxes%3CBR%20%2F%3E%3CBR%20%2F%3ESomehow%20one%20of%20my%20downloads%20decided%20to%20check%20these%20boxes%20which%20would%20not%20allow%20me%20to%20use%20shortcuts%20keys.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20for%20all%20the%20help%20here%20everyone%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-742931%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20-%20Control%20-Alt-%20arrow%20keys%20not%20working%20to%20select%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-742931%22%20slang%3D%22en-US%22%3EOk%20I%20figured%20it%20out-%20below%20is%20the%20fix%20%3A%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20Options%3CBR%20%2F%3E2.%20Advanced%3CBR%20%2F%3E3.%20Scroll%20all%20the%20way%20down%3CBR%20%2F%3E4.%20Look%20for%20lotus%20compatibility%3CBR%20%2F%3E5.%20Uncheck%20all%20boxes%3CBR%20%2F%3E%3CBR%20%2F%3ESomehow%20one%20of%20my%20downloads%20decided%20to%20check%20these%20boxes%20which%20messed%20up%20my%20shortcut%20keys%3C%2FLINGO-BODY%3E
amontanaro
Occasional Contributor
I’m on a surface pro and the control alt arrow key combination has randomly stopped working to select multiple rows and columns-
Does anyone know the fix for this?
16 Replies
What I know is that it should be:
Ctrl+Shift+ArrowKey
That doesn’t work either.
That doesn’t work either. I’ve tried that to select all data right of A1 and down to the bottom of the csv file but it stops after selecting all populated cells to the right
You have to open your file in Excel, whereafter you execute the key combination.
Does it work if you disable your add-ins one-by-one?
I’ll try that and let you know
I don’t think I’m understanding you. Keep in mind I’ve done this function thousands of time before and now the keys are simply not working.
I do have the Excel file open - And I am executing these key functions after the file is open and I’m clicked on a cell.
I see. Perhaps, the culprit is one of the add-ins @Jan Karel Pieterse is referring to in his suggestion.
Unfortunately that didn’t work either
Unfortunately for whatever reason I’m not getting any option to disable those add-ons. It will show me what is disabled and what’s not but there is not an option to disable. I even had a friend who does IT look at that screenshot as I can’t post it here and they were puzzled by why I didn’t have an option to disable any ad ins. My guess is that’s going to be an administrative setting issue. Our company IT team is on vacation so at some point hopefully I’ll be able to get them to take a look at it.
I'm talking about the dialog that comes up when you click:
- File, Options, Add-ins tab
- Click Drop-down near bottom, select COM add-ins
- CLick Go... button.
Ok tried that- I disabled one by one and still no luck.
I’m wondering if a system restore might work
Does it work if you start Excel in safe mode (hold donw control key while Excel starts)?
Ok I figured it out- below is the fix :

1. Options
2. Advanced
3. Scroll all the way down
4. Look for lotus compatibility
5. Uncheck all boxes

Somehow one of my downloads decided to check these boxes which would not allow me to use shortcuts keys.

Thanks for all the help here everyone
Ok I figured it out- below is the fix :

1. Options
2. Advanced
3. Scroll all the way down
4. Look for lotus compatibility
5. Uncheck all boxes

Somehow one of my downloads decided to check these boxes which messed up my shortcut keys