Feature
Move through any workbook without losing your place
Navigating a 40-tab workbook by clicking sheet tabs is slow and disorienting, especially when many sheets are hidden.
What Formula Audit XL does
Ctrl+Shift+N opens a single panel to jump between sheets, search formulas, and hide or show sheets, all without touching the sheet tabs.
The problem with doing this in native Excel
- Excel has no keyboard-driven sheet switcher; you must right-click the tab strip or use Ctrl+Page Up/Down one tab at a time
- Finding a specific formula across sheets requires manual search or complex Find & Replace settings
- Showing and hiding individual sheets requires repeated right-click interactions on the tab strip
How Formula Audit XL does it
- 1 Press Ctrl+Shift+N. Open the Quick Navigation panel from any sheet in the workbook.
- 2 Jump to any sheet or cell. Type to filter the sheet list, select a sheet, and navigate to it instantly. Search for formula text to find matching cells across the workbook.
- 3 Manage sheet visibility. Hide or show individual sheets from the panel without using the right-click sheet tab menu.
Who needs this most
- Analysts working in large multi-tab models
- Reviewers moving between input and output sheets repeatedly
- Finance teams managing models with many hidden support sheets
- Anyone who needs faster workbook navigation on Windows
Quick Navigation (Ctrl+Shift+N) is a keyboard-first panel for moving around large workbooks. Filter and jump to any sheet by name, search for formulas by content, and manage sheet visibility, all from one place without reaching for the mouse.
In models with dozens of tabs, it is particularly useful during reviews where you need to move repeatedly between input, calculation, and output sheets.
Frequently asked questions
Can I search formula text from Quick Navigation?
Yes. Type a formula fragment into the search box and the panel lists every matching cell across all sheets, ready to navigate to.
Does it show hidden sheets?
Yes. Hidden and very hidden sheets appear in the list with a visibility indicator, and you can show them directly from the panel.
Is there a keyboard-only workflow?
Yes. After pressing Ctrl+Shift+N, you can filter, select, and navigate entirely with the keyboard.
Does Quick Navigation work across all workbooks or just the active one?
It operates on the active workbook.
Stop eyeballing models. Start auditing them.
For Microsoft Excel on Windows: 2016, 2019, 2021 & 365 · No data leaves your machine