Why Is the Formula Bar Missing in Excel?

You open an Excel spreadsheet and the formula bar — the long text box above the cells where you can see and edit the contents of the selected cell — has completely vanished. Without the formula bar, it is much harder to see what formulas are in a cell, edit long text entries, or spot errors. If Excel’s formula bar has disappeared, it is almost certainly a display setting rather than a bug.

Here is how to get it back in seconds.

Show the Formula Bar from the View Tab

The formula bar can be toggled on and off with a single checkbox:

  • Go to the View tab in the ribbon.
  • In the Show group, tick the Formula Bar checkbox.

The formula bar should reappear immediately above the column headers. If it was accidentally unticked, this is all you need to do.

Show the Formula Bar from Excel Options

If you prefer using the settings menu:

  • Go to File → Options.
  • Select Advanced in the left panel.
  • Scroll down to the Display section.
  • Make sure Show formula bar is ticked.
  • Click OK.

Check Whether the Ribbon Is Collapsed

If both the ribbon and the formula bar have disappeared, the ribbon may be collapsed or set to auto-hide. Try pressing Ctrl + F1 to toggle the ribbon back on. Once the ribbon is visible, you can enable the formula bar from the View tab.

Alternatively, click the small Ribbon Display Options button in the top-right corner of the Excel window (it looks like a small box with an arrow) and choose Show Tabs and Commands to restore full ribbon visibility.

Exit Full Screen Mode

If Excel is in full screen mode, the formula bar and ribbon may both be hidden. Press Esc or F11 to exit full screen mode. The formula bar should reappear along with the rest of the interface.

Resize the Formula Bar If It Is Too Small to See

The formula bar might still be enabled but collapsed to a single thin line that is nearly invisible. Hover your mouse cursor over the bottom edge of the formula bar area (the thin line between the formula bar and the column headers). When the cursor changes to a double-headed vertical arrow, click and drag downwards to expand the formula bar.

You can make the formula bar as tall as you like — this is especially useful when working with long formulas or large blocks of text in cells.

Check Whether Sheet Protection Is Hiding the Formula Bar

In rare cases, a protected worksheet may have been configured to hide the formula bar. If the spreadsheet was shared by someone else and you cannot enable the formula bar, the sheet may be protected. Go to Review → Unprotect Sheet (you may need a password from the person who protected it) and then try enabling the formula bar again.

Repair Microsoft Office

If the formula bar refuses to appear despite being ticked in the settings, the Excel installation may have a corrupted configuration:

  • Open Settings → Apps → Installed apps.
  • Find Microsoft Office (or Microsoft 365).
  • Click the three dots and select Modify.
  • Choose Quick Repair first. If that does not resolve it, run Online Repair.

Reset Excel’s Display Settings via the Registry

As a last resort, you can reset Excel’s display preferences by clearing its registry key. This is an advanced step — back up the registry before making changes:

  • Close Excel.
  • Press Windows + R, type regedit, and press Enter.
  • Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options.
  • Look for a value called FormulaBar. If it exists and is set to 0, change it to 1.
  • Close the Registry Editor and open Excel.

The formula bar should now be visible. If the key does not exist, the issue is elsewhere — try the Office repair instead.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.