by Allen Wyatt
(last updated January 10, 2019)
Eric prefers to use the keyboard for most of his work in Excel but has found that the keyboard language seems to randomly switch to French causing the wrong characters to appear. He traced the problem to unintentionally pressing Shift+Ctrl, which switches the language. With using the Ctrl key for macro shortcuts, the Shift+Ctrl language switch happens all the time. Eric wonders if there is a way to disable the Shift+Ctrl language switch.
The shortcut key that changes the keyboard language is controlled by Windows, not by Excel. That being said, it can be frustrating to have languages change as you are typing away, just because you inadvertently hit the shortcut key. Fortunately, there is a way to change it.
First, get out of Excel. (Like I said, this is a Windows issue, not an Excel issue.) If you are using a system with Windows 8, then follow these steps:
Figure 1. The Advanced Key Settings tab of the Text Services and Input Languages dialog box.
Figure 2. The Change Key Sequence dialog box.
Note that there are actually two shortcut keys that you can change in the Change Key Sequence dialog box. While you can change just one, if you want, there really isn't much difference between Ctrl+Shift and Left Alt+Shift—they are both very easy to mistakenly press. Thus, it is a good idea to change them both if you are having problems with one of them. (Not Assigned is a good choice. It disables the keyboard shortcuts altogether.)
If you are using Windows 7 you can accomplish the same task in this manner:
If you are using a version of Windows other than 7 or 8, the steps to make the shortcut key change will obviously differ from those presented above. However, there should be enough clues in this tip to help you get to the right place on your system. (The key is to figure out how to get to that Change Key Sequence dialog box. How you get there is what differs from version to version.)
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12977) applies to Microsoft Excel 2007, 2010, and 2013.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
When you right-click a cell, does it seem that the Context menu is missing an item or two? Here's how to get those items ...Discover More
You can use some of the tools in Excel to convert cell references in formulas into names. Converting back (from names ...Discover More
Excel, by default, periodically writes information to AutoRecover files that can help protect your data in case Excel is ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.