If Excel’s formula bar is not working, first turn it back on by choosing View > Show > Formula Bar. If it is visible but blank or will not accept edits, select a cell and check whether it is empty, the sheet is protected, or the workbook is open in a restricted mode.
What the Formula Bar Does
The formula bar sits above the worksheet grid, below the ribbon. It shows the contents of the selected cell: a typed value, text, or formula. For example, a cell might show 12 in the grid while the formula bar shows the formula that calculates 12. Selecting a different cell changes what appears in the bar.
The formula bar is also an editing area. You can select a cell, click in the bar, and change its contents, then press Enter to commit the change or Esc to cancel it. It is separate from the Name Box, which usually appears to its left and displays the selected cell address, such as B4. If the Name Box is visible but the formula bar is not, the bar may simply be hidden or collapsed.
Start With These Quick Checks
In Excel for Microsoft 365 on Windows, open the View tab, find the Show group, and select the Formula Bar checkbox. If the box is already checked, click it off and on once. The bar may have been collapsed rather than switched off; look for its expand control near the right end of the formula bar area. Ctrl+Shift+U expands or collapses the formula bar in Excel for Windows.
Then select a cell you know contains something. A blank cell naturally produces a blank formula bar, which can look like a fault if you expected Excel to display the worksheet’s current formula. If you are unsure which cells contain data, click a visible cell with a value or formula, or use the Name Box to go to a known address.
- Check whether the formula bar is visible on the View tab.
- Select a populated cell rather than an empty one.
- Click inside the bar and see whether the insertion cursor appears.
- Press Esc if Excel seems to be waiting for an unfinished entry or edit.
When the Formula Bar Is Hidden or Too Small
A hidden formula bar is usually a view setting, not a workbook problem. In Windows Excel, the Formula Bar checkbox is under View > Show. Turning it on restores the bar without changing cell contents. If the bar is present but has little height, expand it using the control at its right edge or the Ctrl+Shift+U shortcut. A tall bar is useful for reading or editing long formulas, especially formulas that wrap across multiple lines.
Ribbon layout can differ slightly with window size or display scaling, so the Show group may be compressed. Maximize the Excel window or widen it and look again on the View tab. If the checkbox is on but the bar is still missing, close and reopen the workbook, then restart Excel. This helps distinguish a temporary display glitch from a workbook-specific setting.
On a Mac, use the View menu or View tab and enable Formula Bar; the exact placement depends on the Excel interface version. In Excel for the web, look on the View tab for the Formula Bar option. The Windows shortcut for expanding the bar may not behave the same way on Mac, so use the visible control or menu instead.
Why the Bar May Be Blank or Read-Only
If the selected cell contains a formula but the formula bar appears blank, the worksheet may be protecting a hidden formula. In Excel, a cell’s Hidden protection property prevents its formula from appearing in the formula bar only when the worksheet is protected. If you have permission, go to Review > Unprotect Sheet and provide the password if prompted. Do not try to bypass protection; ask the workbook owner for access if you do not have it.
To check the setting after the sheet is unprotected, select the cell and open Format Cells with Ctrl+1. On the Protection tab, inspect Hidden and Locked. Hidden does not hide a formula on its own; sheet protection must also be active. If the formula should be visible, clear Hidden, then protect the sheet again only if that is part of the workbook’s intended setup.
A protected sheet can also prevent editing locked cells. Depending on the protection options, you may still be able to select a cell while being unable to change its contents. A read-only workbook, a file opened in Protected View, or a permission restriction can have a similar effect. Check for an Enable Editing button in the security message area, or check the workbook title and File information for read-only or access notices. Only enable editing when you trust the file and its source.
Formula Bar Versus Show Formulas
A common mix-up is confusing the formula bar with Excel’s Show Formulas worksheet view. Show Formulas changes what appears inside worksheet cells: instead of calculated results, cells display formulas. On Windows, Ctrl+` (the grave-accent key, often near the top-left of the keyboard) toggles that view. You can also use Formulas > Show Formulas.
This setting does not turn the formula bar on or off. When Show Formulas is enabled, selecting a formula cell still displays its contents in the formula bar. If formulas suddenly appear across the grid, toggle Show Formulas off; if the bar itself is missing, use View > Show > Formula Bar. Distinguishing these two features prevents changing a worksheet display setting when the real issue is simply a hidden bar.
When Editing or Calculation Seems Broken
Sometimes the formula bar is working, but Excel is in a state that makes editing feel unresponsive. If a cell is being edited, Excel may be waiting for you to finish an entry. Press Enter to accept it or Esc to cancel, then try selecting another cell. If a dialog box is open, close or respond to it first. Also check whether the workbook is in Protected View or whether the sheet is protected, as described above.
Another separate issue is a formula that does not update its result after you edit it. That is usually a calculation setting, not a formula-bar failure. In Windows Excel, choose Formulas > Calculation Options > Automatic. If calculation is manual, press F9 to recalculate the workbook. A formula can also return an unexpected result because of its references, data, or logic; the formula bar can help inspect the expression, but it does not diagnose every formula error by itself.
Formatting can also create confusion. A cell may display a number as a date, percentage, or rounded value while the formula bar shows its underlying entry or formula. That difference is normal: the formula bar shows cell contents, while the grid applies the cell’s number format to the displayed result. Do not assume the bar is broken just because the grid and bar do not look identical.
Further Troubleshooting for Persistent Problems
If the formula bar remains unavailable after checking visibility, protection, and editing mode, narrow down whether the problem affects one workbook or all workbooks. Open a new blank workbook and select a cell. If the bar works there, investigate the original workbook’s protection, view settings, or file state. If it fails in every workbook, restart Excel and check whether Office needs an update through File > Account > Update Options > Update Now.
On Windows, add-ins can sometimes interfere with Excel’s interface. To test without changing the original workbook, close Excel and start it in Safe Mode by holding Ctrl while launching Excel and confirming the prompt. If the issue disappears, review add-ins through File > Options > Add-ins. At the bottom, choose COM Add-ins next to Manage, select Go, and temporarily clear an add-in’s checkbox to test; re-enable items one at a time to identify a conflict. Menu details can vary by installation, and Safe Mode is a diagnostic step, not a permanent fix.
If only one file is affected, ask its owner whether it is intentionally protected or restricted. Save a separate copy before making structural changes, and avoid altering protection or file settings when the workbook contains shared business data. For a persistent issue across files, use Excel’s built-in repair options or contact your organization’s Microsoft 365 support team, especially if the device is managed.
Frequently Asked Questions
Why is my Excel formula bar missing?
It is most often hidden through the View settings. In Windows Excel, select View > Show > Formula Bar. If it is already selected, try toggling it off and on, then check whether the bar was collapsed.
Why does the formula bar show nothing when I click a cell?
The cell may be empty, or the formula may be hidden on a protected worksheet. Select a cell that visibly contains data. If a known formula cell is blank in the bar, ask whether the sheet is protected and whether that cell has its Hidden property enabled.
Why can I see a formula but not edit it?
The worksheet may be protected, the workbook may be read-only, or the file may be in Protected View. Check the Review tab and any security or access message. You need appropriate permission to remove protection or enable editing.
How do I make the formula bar bigger?
Use the expand control at the right side of the formula bar, or press Ctrl+Shift+U in Excel for Windows. On Mac or the web, use the interface control if the shortcut differs or is unavailable.
Does Show Formulas turn on the formula bar?
No. Show Formulas changes formula display inside worksheet cells. The Formula Bar checkbox controls the bar above the grid. They are separate settings, and changing one does not repair or hide the other.
Related
- Excel Custom Number Format: Show Zero as a Dash
- Excel Custom Number Format with Text: How It Works
- Excel Custom Number Format for Millions
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel COUNTIF Spill Error? Causes and FixesExcel’s COUNTIF usually returns one count when its criteria argument is a single value. In Microsoft 365, it…
- ISBLANK Not Working on a Cell With a Formula?Yes—this is usually expected behavior, not a problem with Excel. ISBLANK returns FALSE when a cell contains a…
- Excel Cell Keeps Changing to Date? Stop the Auto-FormatIf an Excel cell keeps changing to a date, format the cell as Text before entering the value,…
- Excel SUM Formula Not Working? Fix It Step by StepIf an Excel SUM formula shows zero, leaves out values, or does not update, first check that the…
- Excel File Not Opening? Fix the Blank Screen in ExcelIf Excel opens to a blank screen, first check whether the workbook window is hidden, then start Excel…
- Remove Double Spaces in Word and Fix Double Line SpacingTo remove repeated spaces between words in Microsoft Word, open Home > Replace, enter two spaces in Find…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.