Frankfor Excel
An add-in for Windows Excel

See what’s behind
the numbers.

Trace formulas, spot possible issues and compare changes — without leaving Excel.

Windows64-bit Excel 2016 or laterWorks offline

Your workbook stays on your computer.

Select a formula cell, then press the default shortcut Ctrl + Shift + [ or choose Frank → Precedents on the Excel ribbon. Click a listed cell or use the Up and Down arrows to highlight it in Excel. In this example, a total of 100 uses a price of 5 and a quantity of 20. Both windows stay in view as each input is highlighted.

Follow the formula. Keep Excel in view. View larger

For analysts, model reviewers and students. Work with the spreadsheet already in front of you. Frank helps you follow its formulas and decide what needs a closer look.

Start with the question you have

Follow a calculation, review a possible issue or see what changed.

Trace formulas

See what a number depends on

Precedents shows which cells feed into a formula. Dependents shows which formulas use the selected cell.

Precedents showing a price-times-quantity formula, with the price input selected.

Optional: the formula in words. Turn on formula explanations to read labels like “Price × Quantity” alongside the cell references.

In this example, a price of 5 and a quantity of 20 give a total of 100. Select an input to inspect it, then choose Go to cell to continue in Excel.

Review possible issues

Find the cells worth checking

Run Health check on a selection, sheet or workbook. Find unusual formula patterns, numbers written inside formulas and error cells in one review list.

Select a result to preview its cell. Choose Go to cell to work there, or Export to new sheet to share the list.

Watch the scan’s progress or stop and keep the results so far. Scan report explains which checks finished and any gaps. A result is not automatically a mistake.

Frank Health check showing possible issues and their cell locations in an example workbook.

A number worth checking. The 9 in =C8*9 is typed directly into the formula. Check whether it should come from an input cell.

All screenshots use fictional example data; select an image to see the original full size.

Compare changes

See what is different, cell by cell

Compare yesterday’s price list with today’s. See the original and compared values side by side, filter by the kind of change, and open either cell in Excel.

Use equally sized blocks: cells are matched by position, not their business labels. Formatting is not compared.

Frank comparison results showing changed values and two formula panels, with buttons to open either cell.
Select a change to inspect both versions. Click either cell address to preview it beside Frank, or press Enter / Shift+Enter to continue in Excel. Reopen your results from Frank › Compare › Return to last comparison.
Want to compare before and after your own edits?

Choose Save before-edit copy before making changes. It remembers formulas and current values until Excel closes; it does not save a file. Then select the edited range to compare it with that copy.

Get your bearings

Open a workbook. Know where to start.

Workbook map shows what each sheet contains: inputs, formulas, links and errors. Select a sheet to inspect its external references and errors. The More menu also offers a combined list from all sheets.

In this example, Summary contains a link to another file and a formula returning #DIV/0!. Select either entry to inspect it. An external reference is not necessarily an error. Hidden sheets stay hidden while you browse; choose Unhide and go to open an ordinary hidden sheet.

Frank Workbook map with Summary selected, showing an external reference to Budget.xlsx and a #DIV/0! error in the sheet's details.
A sheet-by-sheet overview, with individual links and errors available to inspect.

More tools, when you need them

Formatting shortcuts, input review and workbook navigation are included too.

Explore the full toolkit

Open tools from the Frank tab in Excel. Each includes a short How to use this tool guide.

Explore

  • Precedents and dependents as a tree
  • Trace to inputs — find the upstream input cells behind an output
  • Optional formula explanations inside Explorer
  • Copy the formula in words to the clipboard
  • Formula map: see the whole sheet’s formulas at once

Audit

  • Health check: review possible issues and see what was checked
  • Consistency: spot formulas that differ from their neighbours, then check whether the difference is intentional
  • Hardcoded numbers typed inside formulas
  • Checks dashboard, read from your own OK / CHECK table
  • Circular reference tracer
  • Input values: review entered prices, quantities and rates together; optionally check which formulas use them. Text and dates are available too.
  • Change journal: recent cell-change events, not a complete edit history
  • Export review results to a worksheet with cell links where available

Compare

  • Compare ranges: pick two equally sized ranges inside Frank
  • Compare values or formula patterns; optionally save a before-edit copy until Excel closes
  • Compare sheets: choose another sheet to compare with the current one
  • Compare workbooks: choose another open workbook to compare
  • Compare file: choose a saved workbook to compare with the current one
  • Review changes side by side, preview either cell without closing Frank, and reopen your last comparison during the same Excel session
  • Update sheet list / Update workbook list: refresh the choices after opening or renaming items, without recalculating or reloading workbook data

Navigate

  • Go to sheet, go to a defined name
  • Jump to the first cell a formula reads from
  • Jump back to where you came from
  • Recent cells, as a list
  • Next and previous typed-in number on the sheet
  • Workbook map: a summary of each sheet’s inputs, formulas and links, rather than a list of possible issues

Format

  • Cycle font colour, fill, number format, date format
  • Units / thousands / millions on a range
  • More and fewer decimals
  • AutoColor a selection, a sheet, or every sheet
  • Frank Undo for supported formatting changes, up to 20 steps

Make it yours

  • Every command’s key can be reassigned
  • Search settings and adjust text size and list spacing
  • Your own colours in the font and fill cycles
  • Your own number and date formats in the cycles
  • Export and import your key bindings
  • Optional side-by-side layout: Frank on the right, selected cell visible on the left
  • Help beside the tools, with examples when you need them
  • Settings are plain-text files you can read
  • Add-ins page lists recognised add-ins and shortcut information
Prefer the keyboard? See the default shortcuts
Precedents: cells this formula usesCtrl+Shift+[
Dependents: formulas using this cellCtrl+Shift+]
Trace to inputsCtrl+Alt+I
Model health checkCtrl+Alt+C
Consistency check on the selectionCtrl+Shift+Q
Hardcoded numbersCtrl+Shift+H
Cycle font colourCtrl+Shift+C
Units / thousands / millionsCtrl+Alt+M
Frank UndoCtrl+Shift+Z
Jump back to where you wereCtrl+Backspace
Go to a defined nameCtrl+Alt+N
Every tool, with its keyCtrl+Alt+H opens the Frank window

Excel shortcuts and QAT remain available. If Frank registers the same key combination, it runs Frank instead; another add-in or macro can later take it over. Reassign or unbind Frank’s keys in Settings › Shortcuts. Ribbon commands remain available.

Your workbook stays yours

Built for working locally in Excel. Clear security notes help your IT team assess Frank before you install it.

No workbook uploads

The add-in works offline, without telemetry or automatic update checks. Paid access uses a local licence file, with no account sign-in.

A straightforward install

Frank installs in your Windows user folder without admin rights. Your organisation’s software policy still applies. Check the setup requirements.

You decide what changes

Reviewing and comparing do not change cell values or formulas. Navigation may reveal hidden cells; exporting adds a sheet. See the security and IT notes for the full details.

Pricing

The full toolkit, whichever plan you choose. Try it free for 14 days — no card required.

Founding licence · first 100
S$45 / year
  • Rate fixed for three years
  • For one person
  • Work and personal use
  • Your work and home PCs
Email for a founding licence
Individual
S$99 / year
  • 12-month licence
  • For one person
  • Work and personal use
  • Your work and home PCs
Email to buy a licence
Firms
Ask · per seat
  • Five or more people
  • One invoice for your team
  • Security notes for IT
  • Help with initial setup
Talk about a firm licence
University clubs and societies
Ask · for your group
  • Discuss access for your members
  • Arrange a group walkthrough
  • Explore a club trial
Discuss club access

Included in every plan: all Frank tools, updates during your licence and email support. Each licence is for one named person.

Prices in Singapore dollars. Annual licences are renewed manually — no automatic charges. 30-day refund policy.

How buying and activation work

Email support@frankforexcel.com to confirm the price, payment method and delivery time before paying. PayNow is currently available for Singapore customers. Outside Singapore? Contact us first to check whether we can support your payment.

In Frank 1.0.36 or later, open Settings › Help / licence › Activate paid access on this PC and choose Draft activation email. Your email app opens a draft with the PC’s activation code included. Add your order details, review it and send. After payment is confirmed, you receive a licence file for that PC. Choose Install licence file on the same page. Frank does not send the email for you. No account or ongoing internet connection is needed.

No email app configured? Paste the copied draft into webmail, or use Copy activation code. Using another personal PC? Request a separate file from that PC under your named-person licence. There is no fixed PC-count limit for the same person; licences cannot be shared with other people. Contact us for a replacement after changing PCs or reinstalling Windows. Existing licences keep working after an update.

Questions

Compatibility, installation and how Frank handles your workbook.

Why does Windows say “Windows protected your PC” when I run the installer?

The installer is not yet code-signed, so Windows may warn or block it. Download only from frankforexcel.com and follow your organisation’s software policy. See the installation instructions, or email support@frankforexcel.com if you are unsure.

How do I follow a formula back to its inputs?

Select a formula and press Ctrl+Shift+[. Explorer shows its direct inputs; nested functions and ranges can be expanded. By default, referenced cells do not expand into their own formulas. Turn off Stop at referenced cells in Settings › Tracing to explore further, or use Trace to inputs to find upstream inputs. Optional formula explanations appear inside Explorer. Select an entry to inspect its cells in Excel.

How do I find hardcoded numbers in an Excel model?

Run Hardcoded numbers for a focused list, or Health check for a broader review. Choose the workbook, sheet or selection to inspect. Common unit constants are excluded by default. A number inside a formula may be intentional — for example, a text-position argument — so a result is not automatically a mistake. Health check also looks for unusual formula patterns, error cells and broken names. When enough references can be checked, it can identify formulas that might not be used elsewhere. Read any scan limitations before drawing conclusions, and export the results to share them.

Can checks take longer on large workbooks?

Yes. Scans show progress and let you stop while keeping the results found so far. Percentages describe the current step or sheet, not time remaining. Some preparation steps use a moving bar instead. Use Run again for a fresh scan. If Health check finishes with gaps, open Scan report to see which checks could not finish and what to do next. An individual Excel operation, such as opening a comparison file, may need to finish before the scan can stop.

Can I change the window layout or learn what each tool does?

Yes. Open Settings and use Find a setting. General lets you turn side-by-side viewing on or off, enlarge text and adjust list spacing. Tracing lets you look for dependents on this sheet, in this workbook or across open workbooks. To learn a tool, expand How to use this tool in its window. Keyboard reference is under Help / licence, and section resets are under Troubleshooting.

Does Frank use AI or upload my workbook?

No. Frank reads formulas and cell values locally through Excel. Its explanations and checks use programmed rules, not an AI model. It does not upload your workbook. Findings are prompts for review, not a guarantee that a model is correct.

Does it work with Capital IQ, Macabacus or other add-ins installed?

You can keep using Excel shortcuts and the Quick Access Toolbar (QAT). When Frank registers an overlapping shortcut, that key combination runs Frank instead of Excel’s usual command. Another add-in or macro can later take over the same combination. Reassign or unbind Frank’s keys in Settings › Shortcuts; Frank’s ribbon commands remain available. Compatibility with other add-ins can vary.

Does it change my workbook?

Explorer, audit scans and comparison inspect your workbook without changing cell values or formulas. Navigation can reveal an ordinary hidden sheet and the target’s rows or columns on an unprotected sheet. These visibility changes may trigger a save prompt. Colour, number format, scaling and AutoColor commands save Frank Undo before applying changes, with a limit of 20,000 cells per command. Formula map adds highlighting rules you can remove with Clear formula map. Exporting results adds a worksheet. Change journal’s Put back command changes a cell only when you explicitly choose it.

What happens when the trial ends?

The tools stop running. Your keys, colours and settings stay exactly as they were. Install a licence file from Settings › Help / licence and everything comes back.

Does Frank work on Mac Excel?

Not currently. Frank requires Windows and 64-bit desktop Excel 2016 or later, including Microsoft 365. It does not run on Mac, in Excel for the web or in 32-bit Excel.

Can I request a feature that Frank or Excel doesn’t have?

Yes. Email support@frankforexcel.com with the Excel task you want to make easier, even if it needs a new tool or function. A small example using made-up data helps. I read every suggestion, though I can’t promise to build them all.

Why "Frank"?

It’s a name and a play on being frank: clear, direct and honest. That’s the idea behind the tool — helping you see what a formula is doing and which parts of a model need a closer look.

About Frank for Excel

I’m Averyl Seah, based in Singapore. I work on the buyside, with experience in investment banking and private equity. I built Frank for the model review and formatting tasks I kept doing in Excel.

During university, I interned at Lazard, Temasek’s GenZero, Novo Holdings, UOB Investment Banking and PwC Deals Advisory. Frank grew out of that hands-on experience: tracing someone else’s formulas, checking a model and making sense of what changed.

Frank for Excel is my independent project, not a product of or endorsed by any of these firms or my current employer. This is its official website. If something is wrong or missing, tell me — I read every email.

Connect on LinkedIn