Auto Format
Format as you build. Auto Format is a toggle that turns on live Smart Formatting — while it’s on, the add-in watches your edits and applies the same styles as Format Selection a beat after you stop typing, so new entries pick up the house style without you running a pass by hand. The toggle itself writes nothing; it just attaches the live watcher, and it always starts off each time Excel launches.
The scenario
You’re actively building a model and you’d rather new numbers pick up the house style as you type than format the sheet in batches afterward. Turn on Auto Format and every edit you make gets classified and styled automatically — inputs as inputs, calculations as calculations — the same way Format Selection would.
Where to find it
ModelXcel Pro tab → Format group → the Auto Format toggle button (keytip AF, Ctrl+Shift+X). The button stays pressed while the mode is active.
What “format as you type” actually means
Turning the toggle on attaches a live watcher to Excel’s worksheet-change event. The behavior is deliberately debounced, not instantaneous:
- You edit one or more cells.
- Each changed address is queued, and a roughly one-second timer restarts. Formatting only runs once you pause.
- When the timer fires, the add-in runs the same Format pass on just the changed cells — it does not reformat the whole sheet on every keystroke.
- Large pastes are handled progressively: the work is chunked across several timer ticks rather than applied all at once.
It styles the edited cells, not the whole sheet
Each live pass is confined to the cells you just changed (expanded along a detected row-span where that helps). This is why rapid typing and pastes are batched and formatted together a moment after you stop, rather than fighting your cursor.
What it writes
Exactly what a manual Format Selectionwrites: the named Mx* cell styles on the edited cells, with the input/calculated split, plus — if you’ve enabled the riders — text-case recasing, empty-reference highlighting, and column auto-fit on the affected columns. The toggle itself changes nothing in the workbook; it only attaches or detaches the watcher. Each automatic pass captures its own Undo Format snapshot before writing.
It always starts off — and does not persist
Auto Format is session-only by design
Auto Format is the one Format toggle that is not remembered across restarts. It is forced off every time Excel launches, is never saved with the workbook or your preferences, and has no entry in the settings file — so it can never re-enable itself on its own. You opt in fresh each session. (Contrast Auto-Fit “while typing”, which does persist — it’s easy to confuse the two.)
The Enable Auto Smart Formatting checkbox in Settings is the same flag — it too is session-only and resets on the next launch.
How to turn it on and off
- On: click the toggle (or press Ctrl+Shift+X). It stays pressed.
- Off: click it again (or Ctrl+Shift+X). Existing formatting stays as-is; only future edits stop being auto-formatted.
Auto Format and live Auto-Fit share a single edit watcher. If you turn Auto Format off while “Auto-Fit while typing” is still on, the watcher stays attached to keep resizing columns — only when both are off does the add-in detach it.
When to disable it
- Pasting large blocks — let the paste land first, then run Format Sheet once.
- Throwaway or scratch work — you don’t want every scratch cell styled.
- When you want full manual control over which cells get styled.
Where it won’t act
Auto Format silently skips edits made in:
- Protected sheets,
- Excel Tables (ListObjects), and
- PivotTables.
These are no-ops with only a log entry — there’s no on-screen notice, so don’t be surprised when typing inside a Table isn’t formatted.
Undo & safety
- Each automatic pass is reversible via Undo Format — one pass per click, walking back while snapshots remain (up to 20, current session only).
- Not a clean Ctrl+Z. The add-in applies the formatting with Excel’s events suppressed, as a separate operation from your edit, so a single Ctrl+Z may not cleanly reverse both your typing and the auto-applied formatting. Use Undo Format to back out the formatting.
- Turning the toggle off does not retroactively undo changes already made — it only stops future ones.
Related
- Format Selection & Sheet — the one-shot version of the same pass.
- Auto Fit — the “while typing” column resize that shares the same watcher (and does persist).
- Formatting Settings — the same toggle, plus the rider options a live pass obeys.
- Undo Format — the recovery path for an automatic pass.