How to Fix Excel Ctrl+[ Shortcut Not Working on German Keyboards
Question details
The user is unable to use the Ctrl+[ shortcut in Excel to navigate to linked cells while using a German keyboard layout.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Attempting to navigate to precedent/linked cells using the standard keyboard shortcut on a non-US keyboard layout.
- Observed behavior
- The standard Ctrl+[ shortcut fails to execute the navigation action because the required bracket key combination differs and is often unrecognized on international keyboard layouts.
Verify your current active keyboard language settings in your operating system to ensure you know exactly which layout is currently mapping your keystrokes.
Use the 'Go To Special' Feature
Bypass the shortcut entirely by using Excel's built-in Go To Special menu to locate and select precedent cells.
Since keyboard layouts can interfere with specific shortcut combinations, using the built-in ribbon features or standard navigation dialogs is the most reliable way to find linked cells without relying on system-dependent shortcuts.
Click on the cell containing the link or formula you want to trace.
Press F5 or Ctrl+G to open the 'Go To' dialog box, then click the 'Special...' button in the bottom left corner.
Choose the 'Precedents' radio button. You can choose either 'Direct only' or 'All levels', then click 'OK'. Excel will automatically highlight the linked cells.

Switch to a US Keyboard Layout Temporarily
Temporarily change your system layout to US English to force the physical keys to match the standard Excel shortcut keys.
Use the Trace Precedents Ribbon Button
Use the visual auditing tools in the Excel ribbon to draw arrows to linked cells instead of just selecting them.
Trace Formula Precedents Easily in WPS Spreadsheet
WPS Office provides a highly compatible and intuitive Spreadsheet tool. You can easily navigate to linked cells using visual trace precedents buttons without worrying about keyboard layout conflicts.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the workbook containing your formulas.
- 2. Select the formula cell: Click on the specific cell that references other linked data.
- 3. Use Trace Precedents: Navigate to the 'Formulas' tab on the top ribbon and click 'Trace Precedents'. WPS will instantly map out the cell references with clear visual arrows.

Frequently Asked Questions
Why does the Ctrl+[ shortcut work on US keyboards but not on German layouts?
Excel shortcuts were originally designed with the standard US keyboard layout in mind. On international keyboards like the German layout, typing a bracket character often requires pressing additional modifier keys (like AltGr). Excel frequently fails to register these complex combinations when paired with the Ctrl key.
Can I remap or change default keyboard shortcuts in Excel?
Microsoft Excel does not offer a native, built-in feature to directly remap default keyboard shortcuts. If you wish to change a shortcut, you typically have to rely on third-party macro software or by adding specific commands to the Quick Access Toolbar and using Alt-key triggers.
What is the exact function of the Ctrl+[ shortcut in Excel?
The Ctrl+[ shortcut is designed to select the direct precedent cells of a formula. When triggered, it instantly moves your cursor and highlights the exact cell or range of cells that provide data to the formula in your currently selected cell.
Is there a shortcut to go back to the original formula cell?
Yes. Once you have navigated to the precedent cell using a shortcut or the 'Go To' dialog, you can typically return to your original formula cell by pressing F5 (or Ctrl+G) and pressing Enter, as Excel remembers your previous location.




