How to Fix Excel Trace Precedents Shortcut on Swiss German Keyboards
Question details
The user is trying to find the correct keyboard shortcut for tracing precedent cells in Excel while using a Swiss German keyboard layout.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Auditing formulas and tracing precedent cells to understand data relationships.
- Observed behavior
- The standard Ctrl+[ shortcut fails to trace precedents because the Swiss German keyboard mapping differs from standard US and UK layouts.
Ensure that your system's keyboard language is actively set to Swiss German and that you are selecting a cell that contains a valid formula with cell references.
Use Localized Excel Shortcuts for Swiss German Layouts
Apply the specific key combinations designed for German and Swiss German keyboard mappings to successfully trace precedents.
Excel adapts its keyboard shortcuts based on the active display language and keyboard layout of your operating system. Because the bracket keys are placed differently on a Swiss German layout, the standard shortcut is reassigned.
Click on the cell containing the formula you want to audit.
Press Alt + $, Alt + %, or Ctrl + ü on your keyboard. The exact combination depends on your specific Excel version and regional Windows settings.
Observe the worksheet to see if blue tracer arrows appear, pointing from the precedent cells to your selected formula cell.

Trace Precedents Using the Excel Ribbon
If keyboard shortcuts remain unresponsive, you can use the built-in ribbon tool for formula auditing as a reliable alternative.
Trace Precedents Easily with WPS Spreadsheet
WPS Office offers a highly compatible and intuitive Spreadsheet application that makes auditing formulas effortless, regardless of your regional keyboard layout.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet document.
- 2. Select the formula cell: Click on the cell that contains the formula you want to audit.
- 3. Access the Formulas tab: Navigate to the 'Formulas' tab located on the top ribbon.
- 4. Click Trace Precedents: Click on the 'Trace Precedents' button to instantly display the auditing arrows on your worksheet.

Frequently Asked Questions
How do I remove the trace precedent arrows in Excel?
Go to the Formulas tab on the ribbon and click on 'Remove Arrows' in the Formula Auditing group to clear all tracer lines from your active worksheet.
Why does Ctrl+[ work on my colleague's computer but not mine?
Your colleague may be using a different keyboard layout, such as US or UK English, where the bracket keys are mapped differently. Excel relies on the operating system's active keyboard language for its shortcut execution.
Is there a shortcut to trace dependents on a Swiss German keyboard?
While the US shortcut to trace dependents is Ctrl+], Swiss German users often need to use localized combinations such as Alt+&, or rely on the 'Trace Dependents' button in the Formulas ribbon.




