Office Settings & Configuration

How to Fix Excel Trace Precedents Shortcut on Swiss German Keyboards

Phi Hung VoPhi Hung Vo Nov 3, 2026 870 views

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.

How to Fix Excel Trace Precedents Shortcut on Swiss German Keyboards
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the formula cell

Click on the cell containing the formula you want to audit.

2
Apply localized shortcuts

Press Alt + $, Alt + %, or Ctrl + ü on your keyboard. The exact combination depends on your specific Excel version and regional Windows settings.

3
Verify tracer arrows

Observe the worksheet to see if blue tracer arrows appear, pointing from the precedent cells to your selected formula cell.

Use Localized Excel Shortcuts for Swiss German Layouts
Temporary Layout Switch: If you frequently rely on standard US shortcuts, you can temporarily switch your Windows keyboard layout to US English (using Windows Key + Space) to use the standard Ctrl+[ shortcut.
Efficient Formula Auditing in WPS Office

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. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet document.
  2. 2. Select the formula cell: Click on the cell that contains the formula you want to audit.
  3. 3. Access the Formulas tab: Navigate to the 'Formulas' tab located on the top ribbon.
  4. 4. Click Trace Precedents: Click on the 'Trace Precedents' button to instantly display the auditing arrows on your worksheet.
Fully compatible with Microsoft Excel (.xlsx, .xls) files and formulas.Intuitive Formula Auditing ribbon tools accessible with a single click.Free and lightweight office suite for Windows, Mac, and Linux.
microsoft office alternative - wps office

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.