Display or hide formulas

To display or hide formulas in Excel, you can use one of the following methods:

✅ Show or Hide Formulas in All Cells

Method 1: Keyboard Shortcut

• Press Ctrl + ~ (the tilde key, usually next to 1 on your keyboard).
  • Pressing it again will toggle back to normal view.
  • This shows formulas instead of results in all cells.

Method 2: Ribbon Option

1. Go to the Formulas tab.
2. Click Show Formulas in the Formula Auditing group.
   • Click again to hide formulas.

🔍 Example

When formulas are hidden, you’ll see just the result (e.g., 15), not =A1+B1.

📝 Note:

This affects the entire worksheet. You can’t show a formula in just one cell while keeping the others normal (unless you manually enter the formula as text using an apostrophe, like '=A1+B1).