Office Settings & Configuration

How to Fix Excel Ctrl+[ Shortcut Not Working on German Keyboards

Algirdas JasaitisAlgirdas Jasaitis Nov 2, 2026 869 views

Question details

The user is unable to use the Ctrl+[ shortcut in Excel to navigate to linked cells while using a German keyboard layout.

How to Fix Excel Ctrl+[ Shortcut Not Working on German Keyboards
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.
Before you start

Verify your current active keyboard language settings in your operating system to ensure you know exactly which layout is currently mapping your keystrokes.

Solution 1Recommended

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.

1
Select the formula cell

Click on the cell containing the link or formula you want to trace.

2
Open Go To Special

Press F5 or Ctrl+G to open the 'Go To' dialog box, then click the 'Special...' button in the bottom left corner.

3
Select Precedents

Choose the 'Precedents' radio button. You can choose either 'Direct only' or 'All levels', then click 'OK'. Excel will automatically highlight the linked cells.

Use the 'Go To Special' Feature
Guaranteed Compatibility: This method works on all keyboard layouts and operating systems without requiring any system changes.
Efficient Formula Auditing with WPS

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. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the workbook containing your formulas.
  2. 2. Select the formula cell: Click on the specific cell that references other linked data.
  3. 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.
Visual formula auditing tools accessible directly from the main interface100% compatible with Microsoft Excel formats (.xlsx, .xls) and functionsFree, lightweight, and user-friendly Office suite with no learning curve
microsoft office alternative - wps office

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.