Settings & conflicts
When a shortcut does nothing, the answer is almost always here: a master toggle is off, focus is somewhere the hook stands down, or the chord resolved to a different command. This page covers the one setting that turns shortcuts off, the layout rule behind the chosen chords, and exactly when a shortcut is ignored.
The Smart Formatting shortcut master toggle
Smart Formatting’s nine shortcuts — Ctrl+Shift+J, Ctrl+Shift+Q, Ctrl+Shift+X, and Alt+Shift+N/P/D/F/R/H — can be turned off as a group. Open Settings from the Format group and clear “Enable Smart Formatting keyboard shortcuts”. The change applies immediately (no restart) and persists per user across Excel sessions.
- What it turns off: only those nine combos. With the toggle off, the add‑in doesn’t even register them, so the keystrokes pass straight to Excel.
- What it does not affect: precedent navigation (
Alt+Shift+1–9,0,[) and the feature‑launch chords (Ctrl+Shift+R/I/Y/W/S/M/E/G) are part of always‑on providers and stay active.
Why the toggle exists
Some third‑party Excel add‑ins bind their own Ctrl+Shift or Alt+Shift combos. If one of them collides with a Smart Formatting shortcut you rely on elsewhere, turn the master toggle off and use the ribbon buttons or keytips for formatting instead — the rest of ModelXcel Pro’s shortcuts keep working.
Why Ctrl+Alt is avoided (AltGr)
No ModelXcel Pro shortcut uses Ctrl+Alt. On many European keyboard layouts Ctrl+Alt is the AltGr modifier used to type @, €, #, and similar characters. A command bound there would hijack normal typing. The add‑in uses Ctrl+Shift and Alt+Shift instead, which have no default Excel binding and behave identically on every layout. And remember: plain Alt triggers Excel’s ribbon keytips, which is a separate mechanism — see Ribbon keytips.
When a global shortcut is ignored
The global hook deliberately stands down in a few situations, so the keystroke reaches Excel (or the focused control) unchanged. A global shortcut is ignored when:
| Situation | What happens instead |
|---|---|
| A modal dialog is open | The keystroke goes to the dialog. Close the dialog and try again. |
| Focus is in an editable control (a text box, combo box, or spinner) — for example a search field or a settings input | The keystroke types / edits normally. Click back into the grid first. |
Excel is not idle — you’re editing a cell, or a long operation is running (Application.Ready is false) | The keystroke goes to Excel (e.g. it stays part of your cell edit). Press Enter or Esc to leave cell‑edit mode, then use the shortcut. |
| No provider claims the chord | It passes through to Excel. This is how, for example, Ctrl+Shift+F reaches a focused TrustLens window instead of being swallowed globally. |
The hook also de‑duplicates: a 250 ms debounce and key‑repeat suppression stop a toggle from flipping twice on one press or repeating while held.
Context & focus, in one rule
Global shortcuts work from the grid; contextual shortcuts work only while their pane / form / editor is focused. The same chord can therefore mean different things in different windows with no conflict, because only the focused surface receives it. If a contextual shortcut does nothing, the surface probably doesn’t have focus — click into it first. See Panes & editors.
Shortcuts that change the workbook or clear undo
A few shortcuts do more than navigate. Knowing which ones write — and which bypass Excel’s native undo — avoids surprises.
| Shortcut(s) | Effect | How to reverse it |
|---|---|---|
Ctrl+Shift+J / Q, Alt+Shift+N/P/D/F/R/H | Write named styles to cells. | Use Undo Format — not Ctrl+Z. |
Ctrl+Enter (Formula Editor), F2 then apply (CalcScope) | Write a formula to the cell and clear Excel’s native undo stack. | The prior formula is shown read‑only in the editor as your reference; re‑enter it if needed. |
| Flatten / Apply Names (keytips) | Rewrite formula text. | Use Restore — the add‑in’s writes don’t feed Ctrl+Z. See Restore. |
Alt+W (CalcScope what‑if) | Nothing — a pure in‑memory sandbox. | Press Reset in CalcScope to return to baseline. |
Troubleshooting
| Symptom | Why | What to do |
|---|---|---|
A Smart Formatting shortcut (Ctrl+Shift+J/Q/X, Alt+Shift+N/P/D/F/R/H) does nothing. | The master toggle is off, the license is inactive, or focus is in a text box / cell‑edit mode. | Re‑enable the toggle in Settings, check the license, and click into the grid first. |
Ctrl+Shift+E exported the map instead of explaining a formula. | No Formula Explorer pane had focus, so it fell through to Export Map. | Click into the Formula Explorer pane, then press Ctrl+Shift+E (or use Alt+U). |
Ctrl+Shift+E / M / G do nothing. | For Export / Analyze / navigate, a Worksheet Map pane must be open and visible; for Explain, a Formula Explorer pane must be focused. | Open the Worksheet Map (or focus Formula Explorer) first. |
| A precedent jump says “no formula” or “named constant”. | The active cell has no formula, or the target precedent is a named constant or a cross‑workbook reference (reported, not navigated). | Select a formula cell; for constants, open Name Manager to inspect the value. |
Ctrl+Z didn’t undo a Smart Format or a formula edit. | The add‑in’s writes don’t feed Excel’s native undo stack. | Use Undo Format (formatting) or Restore (Name Conversion); re‑enter a committed formula edit. |
In CalcScope, Esc didn’t close Find or cancel the edit. | Excel’s host consumes Esc before the CalcScope window sees it. | Use the find bar’s X or the Cancel button. |
A keytip like Alt, X, A, T opened the wrong command. | Auto Fit and Audit Trail both declare the keytip AT. | Click the button, or use a global shortcut where one exists. See Ribbon keytips. |
In an exported Map workbook, Ctrl+Shift+G won’t go to the source. | The source workbook isn’t open, or the Worksheet Map pane isn’t visible in that window. | Open the source workbook and show the Worksheet Map pane, then retry. See Global shortcuts. |
Related
- Global shortcuts — what each chord does and its conditions.
- Panes & editors — the contextual shortcuts.
- Formatting Settings — where the Smart Formatting shortcut toggle lives.