CRX id
mpmhigblgggpkgiddiccjnkmcgnceglh
mpmhigblgggpkgiddiccjnkmcgnceglh
Description from extension meta
Inspect Google Sheets formula structures in user-friendly pop-up windows. Enhance your workflow with precision.
Image from store
Description from store
Easily understand any formula in Google Sheets with Formula Explorer’s intuitive pop-up tools.
Press Ctrl+Q to open the Calculation Steps view, where formulas are broken down step-by-step, showing the full calculation process with corresponding values.
In Formula Explorer, Calculation Steps helps you explore even the most complex Google Sheets formulas. Logical functions like IF, IFS, and CHOOSE highlight active branches, while functions like VLOOKUP, OFFSET, INDEX, and INDIRECT clearly show their target locations.
Need to trace precedents? Press Ctrl+Shift+Q to launch the Precedents Explorer, which helps you visualise all referenced cells and recursively analyse the formulas they depend on—all within the same window. Select any row to instantly jump to the precedent cell in the spreadsheet, or click a range within the formula directly to jump to its location within the precedents tree.
New! Customise your keyboard shortcuts by clicking the Formula Explorer icon in the top-right corner of Google Sheets.
➤ Trace Precedents – Key Features
• Instantly view all cells referenced by your formula in a single, organised window
• Navigate through precedent cells quickly using just the Up and Down arrow keys
• Edit your spreadsheet freely — no need to close the Trace Precedents window
• Explore deeper layers by expanding precedents of precedents using the Right and Left arrow keys
• Click inside the formula to navigate instantly to specific range
• Close the window instantly with the "Esc" key — no mouse required
• Designed with a workflow similar to powerful Excel add-ons
➤ Calculation Steps – Key Features
• Step-by-step formula breakdown – see how formulas are calculated with live intermediate values
• Now with support for the LET function – break down assigned variables step-by-step, understand and evaluate complex, reusable logic with clarity
• Jump to referenced cells instantly using just Up and Down arrow keys or click to navigate quickly
• Navigate formula layers intuitively – use Left and Right arrow keys to drill deeper into nested functions
• Click inside the formula for insights – instantly highlight and analyse specific elements
• No mouse required – open, explore, and navigate entirely via keyboard for peak productivity
• Seamless Google Sheets integration – UI blends naturally with Google Sheets native design
• Familiar experience for Excel users – if you've used Excel's formula auditing tools, Formula Explorer will feel instantly comfortable
Formula Explorer supports formula analysis in all major locales. Detection of special functions is now available in English, French, German, Spanish, Italian, and Russian.
After installation, log in with your Google Account to activate your free license. Formula Explorer only requests access to your Google Sheets when evaluating formulas or analysing precedents.
We never access, store, or share your sheet data.
For more details, see our Security Policy at https://www.cognisheets.com/legal/security and Privacy Policy at https://cognisheets.com/legal/privacy.html.
Formula Explorer is currently in BETA and free to use.
Boost your Google Sheets efficiency with Formula Explorer!