Smart Formatting

When to use it: you format models the same way every day — headers, borders, RAG fills, number formats — and want one keystroke to step through your own lists instead of opening Format Cells.

Smart Formatting is an Excel feature. You define up to six personal cyclers. Each cycler holds an ordered list of named format variants. Press its shortcut to apply the next variant on the current selection (then wrap to the start).

Visual walkthrough coming soon — open Excel Navifia → Configure → Smart formatting.

Default cyclers

Cycler	Default shortcut	Ships with
Number Format	Ctrl+Shift+N	One digit · No digit · Percentage · Percentage points · Multiple · Dollar
Text Style	Ctrl+Shift+Q	Title · Main text · Note
Border	Ctrl+Shift+S	Top · Top and Bottom · Bottom · No Border
Fill Color	Ctrl+Shift+R	No Fill · Green · Red · Blue
Font Color	Ctrl+Shift+D	Blue · Red · Green · Black
Custom	Ctrl+Shift+B	Empty — build your own list

Shortcuts are rebindable from Keyboard shortcuts. Each cycler can hold up to eight variants.

How to configure

In Excel, open the Navifia tab → Configure → Smart formatting.
Pick a cycler. Rename the shortcut label if you want.
Add, remove, or reorder variants. For each variant you can set font, size, bold/italic, font color, fill color, borders, and number format.
Click Save. The lists apply immediately — no restart.

Share with your team

Smart Formatting lists travel in Excel’s Export setup / Import setup bundle (alongside shortcuts and Fit to Slide widths). A team lead can configure once and hand everyone a single .navifia.json file. PowerPoint has a parallel setup export for layouts, elements, and indicators — see Rebrand to your template.

Use case

Your headers always cycle the same three looks. Configure Text Style once, then press Ctrl+Shift+Q on each row until it lands on the right level — no Format Cells dialog, no mouse.