'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Ctrl+[ Shortcut Not Working in Microsoft 365
Question details
The user needs to restore the functionality of the Ctrl+[ (Trace Precedents) shortcut in Microsoft 365.
- Product
- Microsoft Excel
- Device & OS
- Windows 10, Windows 11
- Scenario
- Tracing formula precedents using keyboard shortcuts after upgrading to a newer version of Office.
- Observed behavior
- The Ctrl+[ shortcut works in Office 2007 but fails in Microsoft 365 when certain non-English application languages, such as Slovak, are applied.
Verify that your physical keyboard layout matches your system language, as non-English layouts can sometimes remap or disable specific shortcut keys in Excel.
Change Excel Display Language to English
Some Excel shortcuts, including Ctrl+[, may not function correctly in certain localized interfaces (such as Slovak). Switching the display language to English resolves this issue.
Microsoft 365 sometimes alters or drops shortcut key bindings depending on the selected display language to accommodate different regional keyboards. Reverting the application language to English restores the default shortcut behaviors.
Launch Microsoft Excel. Click on 'File' in the top-left corner of the ribbon, then select 'Options' at the bottom of the left-hand menu.
In the Excel Options dialog box, click on 'Language' in the left-hand pane.
Under the 'Office display language' section, click on 'English', then click the 'Set as Preferred' button.
Click 'OK' to save your changes, then completely close and restart Excel for the language changes to take effect. Test the Ctrl+[ shortcut again.
Use the Ribbon Key Sequence (Alt, M, P)
If you cannot change your display language, you can use the built-in Ribbon shortcut sequence to trace precedents without using Ctrl+[.
Try WPS Office for Seamless Spreadsheet Management
If you frequently encounter shortcut and language compatibility issues in Microsoft 365, WPS Office offers a free, lightweight, and highly compatible alternative. Enjoy familiar spreadsheet functions without the hassle of broken shortcuts.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package.
- 2. Open WPS Spreadsheets: Launch the WPS Spreadsheets application from the installed suite.
- 3. Edit Your Workbooks: Open your existing .xlsx files and immediately use standard shortcuts like Ctrl+[ without language-related errors.
Frequently Asked Questions
Why do Excel shortcuts change or stop working with different display languages?
Excel's regional and language settings can remap keys to accommodate different alphabets and localized keyboard layouts. This localization process can sometimes inadvertently break standard English shortcuts like Ctrl+[.
What exactly does the Ctrl+[ shortcut do in Excel?
The Ctrl+[ shortcut is used to 'Trace Precedents'. It instantly selects the direct precedent cells referenced by a formula, helping you quickly audit your spreadsheet and see where a formula is pulling its data from.
Can I manually remap the Ctrl+[ shortcut in Microsoft 365?
Unlike Microsoft Word, Excel does not have a built-in feature to fully remap default keyboard shortcuts. You can only customize shortcuts by adding commands to the Quick Access Toolbar (QAT) or by using VBA macros.
