Home

Keyboard Freezing in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-672413%22%20slang%3D%22en-US%22%3EKeyboard%20Freezing%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-672413%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20a%20problem%20with%20my%20keyboard%20freezing%20in%20Microsoft%20Excel.%20When%20opening%20excel%2C%20the%20keyboard%20works%20normal%20and%20i%20am%20able%20to%20use%20the%20arrow%20keys%20to%20move%20cells%20within%20the%20workbook.%20However%2C%20when%20I%20access%20the%20ribbon%20and%20perform%20a%20function%2C%20the%20keyboard%20will%20freeze%3F%20The%20only%20way%20to%20resolve%20the%20issue%20is%20to%20use%20the%20mouse%20to%20click%20on%20a%20cell%2C%20at%20which%20time%20the%20entire%20keyboard%20become%20functional%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20if%20i%20use%20Alt%2BH%2BH%20to%20fill%20color%20of%20a%20cell%2C%20as%20soon%20as%20i%20select%20a%20color%20the%20keyboard%20will%20freeze.%20I%20am%20not%20able%20to%20arrow%20out%20of%20the%20cell%20or%20type%20anything%20in%20the%20cell%20until%20I%20use%20the%20mouse%20to%20click%20the%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20out%3F%20I%20have%20tried%20using%20the%20ScrollLock%20function%20but%20that%20does%20not%20appear%20to%20be%20helping.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%20I%20am%20running%20Macabacus%20(modeling%20enhancement%20tool)%20but%20the%20issue%20occurs%20when%20using%20basic%20ribbon%20shortcuts%2C%20so%20I%20do%20not%20think%20it%20is%20Macabacus%20related.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ETHank%20you%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-672413%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-675948%22%20slang%3D%22en-US%22%3ERe%3A%20Keyboard%20Freezing%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-675948%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F355448%22%20target%3D%22_blank%22%3E%40Logan775%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20the%20only%20thing%20that%20works%20for%20me%26nbsp%3B-%20other%20than%20exiting%20the%20program%20entirely.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESimply%20open%20another%20worksheet%20tab.%20%26nbsp%3BYou%20should%20be%20able%20to%20type%20into%20the%20new%20worksheet.%20%26nbsp%3BThen%20go%20back%20to%20the%20original%20one.%20%26nbsp%3BYou%20should%20be%20able%20to%20now%20type%20in%20that%20one%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EDon't%20know%20why%20it%20works%2C%20but%20it%20does.%20%26nbsp%3BIt's%20a%20darn%20nuisance%20and%20a%20bug%20that's%20been%20in%20Excel%20for%20some%20time.%26nbsp%3B%20Strange%20Isn%60%20it%20!%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3ERegards%2C%3C%2FP%3E%3CP%20class%3D%22%22%3EAkshay%20%7C%20Tech%20support%20%7C%20O365CloudExperts%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-675949%22%20slang%3D%22en-US%22%3ERe%3A%20Keyboard%20Freezing%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-675949%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F355448%22%20target%3D%22_blank%22%3E%40Logan775%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20the%20only%20thing%20that%20works%20for%20me%26nbsp%3B-%20other%20than%20exiting%20the%20program%20entirely.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESimply%20open%20another%20worksheet%20tab.%20%26nbsp%3BYou%20should%20be%20able%20to%20type%20into%20the%20new%20worksheet.%20%26nbsp%3BThen%20go%20back%20to%20the%20original%20one.%20%26nbsp%3BYou%20should%20be%20able%20to%20now%20type%20in%20that%20one%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDon't%20know%20why%20it%20works%2C%20but%20it%20does.%20%26nbsp%3BIt's%20a%20darn%20nuisance%20and%20a%20bug%20that's%20been%20in%20Excel%20for%20some%20time.%26nbsp%3B%20Strange%20Isn%60%20it%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EAkshay%20%7C%20Tech%20support%20%7C%20O365CloudExperts%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-676293%22%20slang%3D%22en-US%22%3ERe%3A%20Keyboard%20Freezing%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-676293%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F355448%22%20target%3D%22_blank%22%3E%40Logan775%3C%2FA%3E%26nbsp%3B%2C%20it%20looks%20like%20a%20bug%20in%20one%20of%20the%20builds%2C%20quite%20many%20people%20report%20about%20this%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1182910%22%20slang%3D%22en-US%22%3ERe%3A%20Keyboard%20Freezing%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1182910%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%3EThis%20is%20an%20old%20problem%20and%20it%20still%20isn't%20fixed.%20I've%20searched%20and%20seen%20complaints%20going%20back%20at%20least%20to%202014%2C%20in%20Excel%202013.%3C%2FP%3E%3CP%3EIn%20my%20case%20I%20had%20no%20trouble%20with%20Excel%202010%2C%20but%20it%20was%20declared%20obsolete%20so%20I%20joined%20Office%20365%20and%20presumably%20have%20the%20very%20latest%20build.%20The%20build%20is%20well%20hidden%20but%20I%20think%20the%20build%20is%20Version%202001%20build%2012430.20184.%20I%20am%20using%20Windows%2010%20Pro%20on%20a%20ThinkPad%20E495%20(AMD%20Ryzen%203500)%20with%20an%20external%20keyboard%20and%20screen%2C%20if%20any%20of%20this%20helps.%3C%2FP%3E%3CP%3EI%20usually%20have%20a%20bunch%20of%20spreadsheets%20open.%20In%20Excel%202010%2C%20it%20was%20one%20window%20and%20I%20had%20to%20switch%20between%20seeing%20one%20at%20a%20time.%20(Microsoft%20explained%20that%20policy%20by%20giving%20it%20a%20name%2C%20but%20I%20don't%20recall%20what%20it%20was.)%20In%20this%20later%20version%20of%20Excel%20365%2C%20I%20have%20multiple%20Excel%20windows%20open%20and%20can%20copy%20from%20one%20to%20another%2C%20which%20is%20nice...%20BUT%20the%20keyboard%20routinely%20fails.%20I%20have%20to%20type%20into%20another%20window%20to%20get%20it%20back.%20Also%2C%20the%20cursor%20fails%20sometimes%20even%20when%20the%20keybaord%20works%2C%20so%20I%20can't%20see%20where%20I%20am.%3C%2FP%3E%3CP%3EI%20turned%20off%20Filter%20Keys%2C%20which%20a%20previous%20note%20said%20might%20help.%20So%20nothing%20right%20now%20seems%20to%20help.%20Can%20someone%20at%20Microsoft%20please%20look%20into%20it%3F%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Logan775
New Contributor

Hello,

 

I am having a problem with my keyboard freezing in Microsoft Excel. When opening excel, the keyboard works normal and i am able to use the arrow keys to move cells within the workbook. However, when I access the ribbon and perform a function, the keyboard will freeze? The only way to resolve the issue is to use the mouse to click on a cell, at which time the entire keyboard become functional again.

 

For example, if i use Alt+H+H to fill color of a cell, as soon as i select a color the keyboard will freeze. I am not able to arrow out of the cell or type anything in the cell until I use the mouse to click the cell.

 

Can someone help me out? I have tried using the ScrollLock function but that does not appear to be helping.

 

Note: I am running Macabacus (modeling enhancement tool) but the issue occurs when using basic ribbon shortcuts, so I do not think it is Macabacus related.


THank you 

4 Replies
Highlighted

@Logan775 

 

Here's the only thing that works for me - other than exiting the program entirely.  

 

Simply open another worksheet tab.  You should be able to type into the new worksheet.  Then go back to the original one.  You should be able to now type in that one as well.

 

Don't know why it works, but it does.  It's a darn nuisance and a bug that's been in Excel for some time.  Strange Isn` it !

 

Regards,

Akshay | Tech support | O365CloudExperts

Highlighted

@Logan775 

 

Here's the only thing that works for me - other than exiting the program entirely.  

 

Simply open another worksheet tab.  You should be able to type into the new worksheet.  Then go back to the original one.  You should be able to now type in that one as well.

 

Don't know why it works, but it does.  It's a darn nuisance and a bug that's been in Excel for some time.  Strange Isn` it !

 

Regards,

Akshay | Tech support | O365CloudExperts

Highlighted

@Logan775 , it looks like a bug in one of the builds, quite many people report about this issue.

Highlighted

@Sergei BaklanThis is an old problem and it still isn't fixed. I've searched and seen complaints going back at least to 2014, in Excel 2013.

In my case I had no trouble with Excel 2010, but it was declared obsolete so I joined Office 365 and presumably have the very latest build. The build is well hidden but I think the build is Version 2001 build 12430.20184. I am using Windows 10 Pro on a ThinkPad E495 (AMD Ryzen 3500) with an external keyboard and screen, if any of this helps.

I usually have a bunch of spreadsheets open. In Excel 2010, it was one window and I had to switch between seeing one at a time. (Microsoft explained that policy by giving it a name, but I don't recall what it was.) In this later version of Excel 365, I have multiple Excel windows open and can copy from one to another, which is nice... BUT the keyboard routinely fails. I have to type into another window to get it back. Also, the cursor fails sometimes even when the keybaord works, so I can't see where I am.

I turned off Filter Keys, which a previous note said might help. So nothing right now seems to help. Can someone at Microsoft please look into it? Thanks!

Related Conversations
Formula to calculate between "Closing Balances"
calof1 in Excel on
2 Replies
Userform-Transferred Data must not be editable
Mr_Buttons in Excel on
0 Replies
need urgent help for excel
talikne610 in Excel on
2 Replies
Excel no longer capable of Relative links
GoodallS in Excel on
0 Replies
Grouping by dates in Excel?
MMH11 in Excel on
0 Replies
Creating Pie charts.......
dougler2020 in Excel on
4 Replies