Fix Excel Ctrl+[ Shortcut Not Working on AZERTY Keyboard
Question details
The user is unable to use the Ctrl+[ or Ctrl+Shift+[ shortcuts to trace precedent and dependent cells in Excel because of their AZERTY keyboard layout.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to quickly trace precedent and dependent cells using keyboard shortcuts while auditing formulas.
- Observed behavior
- The default shortcuts fail to execute the trace command because the AZERTY layout requires different key combinations (such as AltGr) to output bracket characters, which Excel does not recognize as Ctrl+[.
Ensure the Developer tab is enabled in your Excel ribbon, as you will need to create a simple VBA macro to bypass the hardcoded shortcut limitations of your keyboard layout.
Create a VBA Macro and Assign a Custom Shortcut
Bypass the AZERTY layout limitation by writing a VBA script that mimics the trace behavior, then binding it to a custom key combination that works easily on your keyboard.
Because AZERTY keyboards require additional modifier keys to type brackets, Excel fails to recognize the standard Ctrl+[ combination. Assigning a custom keyboard shortcut to a VBA macro is the most reliable workaround to restore this functionality.
Press Alt + F11 on your keyboard to open the Microsoft Visual Basic for Applications window.
Click on 'Insert' in the top menu and select 'Module'. In the blank window that appears, write a short macro using 'Selection.DirectPrecedents.Select' to trace precedents.
Close the VBA editor and return to your Excel workbook. Press Alt + F8 to open the Macro dialog box, select your newly created macro, and click 'Options'.
In the Shortcut key box, assign a new letter that doesn't conflict with your AZERTY layout (for example, Ctrl + m). Click OK to save.

Use Ribbon Commands to Trace Precedents and Dependents
If you prefer not to use macros, you can use the built-in Formula Auditing commands found directly on the Excel Ribbon.
Trace Precedents Easily with WPS Spreadsheet
WPS Office offers highly intuitive formula auditing tools that help you trace precedents and dependents without struggling with regional keyboard shortcut conflicts.
- 1. Open your Document: Launch WPS Office and open your spreadsheet file.
- 2. Select the Target Cell: Click on the cell containing the formula you want to audit.
- 3. Go to the Formulas Tab: Navigate to the 'Formulas' tab located on the top ribbon.
- 4. Trace Relationships: Click 'Trace Precedents' or 'Trace Dependents' to instantly visualize formula relationships with tracer arrows.

Frequently Asked Questions
Why doesn't Ctrl+[ work on European keyboards?
On AZERTY and many other European layouts, typing a bracket '[' requires pressing 'AltGr' or other modifier keys. Excel's hardcoded shortcuts do not recognize these modified keystrokes as the standard 'Ctrl+[' input.
Can I change default Excel shortcuts without using VBA?
Unlike Microsoft Word, Excel does not have a native 'customize keyboard shortcuts' menu for redefining default core shortcuts. To change hardcoded shortcuts like 'Ctrl+[', you typically need to use VBA macros or third-party keyboard mapping software.
How do I remove the tracer arrows after finding the precedents?
To remove the blue arrows, go to the Formulas tab on the ribbon and click the 'Remove Arrows' button in the Formula Auditing group. You can also click the dropdown to choose between removing precedent or dependent arrows specifically.




