ThisCalculator

Everyday

Unhide Formula Bar in Excel: Step-by-Step Guide

Updated · Standard formula, shown below

Unhide Formula Bar in Excel: Step-by-Step Guide

If the formula bar has disappeared from your Excel window, it is usually just a display setting that got toggled off. This guide shows you how to bring it back in a few clicks, whether you are on Windows, Mac, or using Excel online.

What You’ll Need

  • A copy of Microsoft Excel (desktop for Windows or Mac, or Excel for the web)
  • An open workbook (any file works)

Step-by-Step

  1. Open Excel and your workbook. If the formula bar is missing, you will see the grid starting right below the ribbon (or below the name box on older layouts).
  2. Go to the View tab. In the ribbon at the top of the window, click View. This tab contains display options for the worksheet.
  3. Look for the Show group. On the View tab, find the section labeled Show (on Windows) or Show/Hide (on Mac). It typically contains checkboxes for Ruler, Gridlines, Headings, and Formula Bar.
  4. Check the Formula Bar box. Click the checkbox next to Formula Bar. When it is checked, the formula bar reappears just below the ribbon. If it was already checked but the bar is still hidden, uncheck and recheck it to refresh the display.
  5. For Excel for the web: Click View on the ribbon, then select Formula Bar from the Show group. The bar appears immediately.
  6. If the bar is still missing, check for full-screen mode. Press Ctrl + F1 (Windows) or Cmd + Ctrl + F (Mac) to toggle the ribbon. In full-screen mode, the formula bar may be hidden even if the setting is on.

Common Mistakes

  • Looking in the wrong tab: The formula bar option is under View, not Home or File. A quick search in the ribbon (Alt+W) can help.
  • Confusing the formula bar with the name box: The name box (showing cell references like A1) is always visible; the formula bar is the long input area to its right. If you see the name box but not the input area, the formula bar is hidden.
  • Not checking for a collapsed ribbon: If the ribbon is minimized, the formula bar may be hidden behind it. Restore the ribbon by double-clicking any tab or pressing Ctrl+F1.

Tips

  • Keyboard shortcut: There is no direct shortcut for the formula bar, but you can press Alt + W + V + F (Windows) to toggle it quickly. On Mac, use Option + W + V + F.
  • Expand the formula bar: Once visible, you can drag the bottom edge of the bar upward to make it taller, or press Ctrl + Shift + U to expand/collapse it.
  • Use the formula bar for long formulas: Even if you prefer editing in-cell, the formula bar is handy for viewing and editing complex formulas without covering your data.
  • Check Excel options: In rare cases, the setting may be disabled in Excel Options. Go to File > Options > Advanced and under Display, ensure “Show formula bar” is checked.

Troubleshooting

If the formula bar still doesn’t appear after following the steps:

  • Restart Excel: Close and reopen the workbook. Sometimes a display glitch clears with a restart.
  • Check for a corrupted view setting: In Excel Options (File > Options > Advanced), under Display, confirm “Show formula bar” is checked. If it is, uncheck it, click OK, then reopen Options and recheck it.
  • Update Excel: Older versions may have bugs. Install the latest updates from Microsoft.
  • Try a new workbook: If the formula bar appears in a new workbook but not in your current one, the file may have a custom view saved. Go to View > Custom Views and delete any that hide the formula bar.
  • Reset Excel settings: As a last resort, you can reset Excel to default settings by holding Ctrl while starting Excel, then confirm the reset. This will restore all display options.

Frequently Asked Questions

Why is the formula bar missing in Excel?

The most common reason is that the “Formula Bar” checkbox under the View tab is unchecked. It may have been toggled off accidentally or by a previous user.

Can I hide the formula bar permanently?

Yes, you can uncheck the Formula Bar box under View > Show. The setting is saved with the workbook, so it will stay hidden when you reopen that file.

Does the formula bar show in all views?

No. In Page Layout view, the formula bar is still visible, but in Full Screen mode it may be hidden. In Excel for the web, the formula bar is always visible unless you hide it via View.

Why is my formula bar showing but not the content?

If the formula bar is empty even when you select a cell with a formula, check if the cell is formatted as text or if the formula is hidden. Go to Home > Format > Format Cells > Protection and uncheck “Hidden” if you want to see formulas.

How do I expand the formula bar to see a long formula?

Click the downward arrow at the right end of the formula bar, or press Ctrl+Shift+U to expand/collapse it. You can also drag the bottom edge of the bar.

Is there a shortcut to show the formula bar?

Yes, on Windows press Alt+W, V, F (press keys sequentially). On Mac, press Option+W, V, F. This toggles the formula bar on and off.

Related

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.