What Excel Shortcut Reveals Formulas: A Practical Guide (2026)
Master the Show Formulas shortcut in Excel on Windows and Mac, plus Ribbon alternatives and auditing tips. Learn how FORMULATEXT supports debugging, teaching, and efficient workbook reviews.
To reveal formulas in Excel, use the Show Formulas shortcut: Ctrl+` on Windows and Cmd+` on Mac. This toggles between showing the formula text (e.g., =SUM(A1:A5)) and the calculated result. You can also toggle via the Formulas tab's Show Formulas button.
The core concept: showing formulas in Excel
Auditing and understanding complex workbooks often requires seeing the actual formulas rather than only their results. The Show Formulas shortcut toggles the display between the text of a formula and the value it computes, improving transparency and teaching opportunities. On Windows, press Ctrl+ to toggle; on macOS, press Cmd+. If you prefer a GUI path, use the Ribbon: Formulas tab > Show Formulas. This small switch can dramatically speed up debugging in large spreadsheets.
Keyboard shortcuts: Windows vs Mac
Using the right keys for your platform ensures you stay productive. On Windows, Ctrl+ flips between formula text and results for the active range. On Mac, Cmd+ performs the same toggle. If you’re sharing a workbook with teammates on different platforms, keep the ribbon method in mind as a universal fallback. The key distinction is the grave accent key (the `) lives near the number row on most keyboards, but placement can vary by layout.
Using FORMULATEXT for auditing formulas
FORMULATEXT is a powerful companion to Show Formulas. It returns the textual representation of a formula from a referenced cell, letting you audit or document formulas in-place or in an adjacent column. This is especially helpful when teaching others or when you want to produce a report of the exact logic used in your workbook.
=FORMULATEXT(A1)=FORMULATEXT(B2)=FORMULATEXT(OFFSET(A1,0,1))Each line shows how a formula would appear as text in another cell, aiding traceability without altering the original calculations.
Practical workflows in large workbooks
When dealing with hundreds of formulas, a scalable approach is to build a small audit grid. In a helper column, apply FORMULATEXT to each cell in your target range and then use filters to surface unusual formulas or hard-coded literals. This method helps you spot inconsistent patterns, validate references across sheets, and prepare a concise audit report for stakeholders. For example, in a separate column, you can populate =FORMULATEXT(A1) and drag down to cover your target column, then filter for entries containing IF, SUM, INDIRECT, or other complex functions to prioritize reviews.
# Sample audit: column C shows formulas for column A
C1: =FORMULATEXT(A1)
C2: =FORMULATEXT(A2)# Filter strategy (pseudocode for logic):
# If C contains a parenthesis or function name, flag for reviewCommon mistakes and debugging tips
A frequent pitfall is assuming a correct result means a correct formula. Show Formulas reveals the pathway, but you still need to verify references, absolute vs relative addressing, and sheet scoping. When debugging, combine Show Formulas with FORMULATEXT in adjacent cells to document intent, and use named ranges to reduce ambiguity. Keep an eye on cross-sheet references and potential dependence on hidden rows or columns. If a formula spans multiple sheets, ensure that all references are valid in every affected tab.
# Quick check of a cross-sheet reference
E1: =FORMULATEXT(Sheet2!A1)# Verify absolute vs relative references
F1: =FORMULATEXT(A$1)Steps
Estimated time: 20-40 minutes
- 1
Identify target area
Select the range or worksheet that you want to audit for formulas. This helps focus your toggle and FORMULATEXT checks on a manageable subset.
Tip: Start with a small region (e.g., 10x5 cells) to validate behavior. - 2
Toggle formulas visually
Use Ctrl+` (Windows) or Cmd+` (Mac) to switch between showing formulas and results. Confirm that the toggle affects the intended area.
Tip: Try both a single cell and a multi-cell range to observe differences. - 3
Add FORMULATEXT for auditing
In adjacent columns, apply FORMULATEXT to display each formula as text for documentation and review.
Tip: This creates a stable audit trail that survives toggling. - 4
Filter and flag anomalies
Use filters or conditional formatting to identify formulas with unusual patterns or references.
Tip: Document flagged cells in a separate sheet for transparency. - 5
Document findings
Maintain a concise audit report with cells reviewed, issues found, and recommended changes.
Tip: Include dates and author notes for reproducibility. - 6
Share and review with teammates
Distribute the audit results and ensure stakeholders understand the reasoning behind changes.
Tip: Provide a quick guide on how to reproduce the audit steps.
Prerequisites
Required
- Required
- Required
- Basic keyboard proficiency (Ctrl/Cmd keys)Required
- Required
Optional
- Optional: Access to the Formulas tab for Ribbon usageOptional
Keyboard Shortcuts
| Action | Shortcut |
|---|---|
| Toggle Show Formulas (keyboard)Switch between formula text and results in the active worksheet | Ctrl+` |
| Open Show Formulas via RibbonAlternative to keyboard shortcut | — |
People Also Ask
What is the Show Formulas shortcut in Excel?
The Show Formulas shortcut toggles formula visibility in cells, switching between showing the formula text and the calculated result. On Windows, use Ctrl+`; on Mac, use Cmd+`.
Use Ctrl+grave accent on Windows or Command+grave accent on Mac to view formulas instead of results.
Does Show Formulas work on all Excel versions?
Show Formulas is available in modern Excel versions, including Office 365 and standalone Excel 2019+. Some older builds may require updates.
Yes, in recent Office versions, the feature is available; older builds may need an update.
Can I use macros to toggle formulas?
Yes. You can write a small macro to toggle the Show Formulas state, or create a custom shortcut that triggers the macro.
You can automate the toggle with a macro if you want a custom shortcut.
How can I print worksheets with formulas visible?
Printing will reflect the current view. If Show Formulas is on, sheets will print the formula text; otherwise, they will print results.
Printing follows what's on the screen; switch to Show Formulas before printing if you need formula text.
What is FORMULATEXT useful for?
FORMULATEXT returns the actual formula as text in another cell, helping you document and review logic without altering the original cells.
FORMULATEXT helps you show formulas in a separate column for audit trails.
The Essentials
- Show formulas quickly with Ctrl+
/ Cmd+ - FORMULATEXT helps auditing without toggling UI
- Ribbon method provides a GUI alternative
- Combine with filtering to audit large workbooks