Excel Formula Bar Not Showing Text? Fixes That Work

Formulas & functions · Updated November 19, 2026

If Excel’s formula bar is missing, turn it back on with View > Show > Formula Bar in Excel for Microsoft 365 on Windows. If the bar is visible but empty, select the cell that should contain the text and check whether it is genuinely blank, whether a formula is hidden on a protected sheet, or whether you selected a different cell than you intended.

What the formula bar is supposed to show

The formula bar sits above the worksheet grid, beside the name box. It displays the contents of the currently selected cell: text, a number, a date, or a formula. It is not a permanent text panel for the whole worksheet. Select a different cell and its contents replace what you saw before; select an empty cell and the bar is empty.

For a cell containing a formula, the formula bar normally shows the formula, while the grid shows the result. For example, a cell might display a total such as 25 in the worksheet while the formula bar shows the calculation used to produce it. That difference is expected: the formula bar helps you inspect or edit the cell’s underlying entry.

It also helps to distinguish the formula bar from the way text appears inside a cell. A narrow column, a custom number format, or text color matching the background can make a value hard to see in the grid. Those display issues do not usually remove the cell’s contents from the formula bar.

Turn the formula bar back on in Windows

In Excel for Microsoft 365 on Windows, the formula bar can be hidden as a worksheet display option. To show it again:

  1. Open the workbook and select the View tab.
  2. In the Show group, select the Formula Bar checkbox.
  3. Click a cell containing a known value or formula to confirm that its contents appear above the grid.

If the ribbon is simplified or the Excel window is narrow, the Show controls may be condensed. Maximize the window or expand the relevant ribbon controls and look for the Formula Bar option on the View tab. Another route in Windows is File > Options > Advanced; under the Display section, enable Show formula bar, then select OK.

The checkbox controls whether the bar is displayed, not whether cell contents exist. Switching it on should restore the bar across the workbook window. If it is already checked, continue with the checks below rather than repeatedly toggling it.

Check the selection and the cell’s contents

When the formula bar is visible but blank, first verify the active cell. The name box to the left of the formula bar shows the selected cell reference, such as C7. If the text you expected is in C6, clicking C7 will not show C6’s contents. Click the cell directly, or use the name box to go to a specific address.

Next, consider whether the selected cell is actually empty. A cell can look like part of a data table even when it has no entry, and a selection outline can make it easy to click the row or column beside the intended value. Click another cell whose contents you know, then return to the original cell. If the known cell appears normally but the target does not, the issue is likely about that cell’s contents or protection rather than the formula-bar setting.

For a reliable check, select the cell and inspect the formula bar, then look at the cell reference in the name box. If you are navigating a large sheet, press Ctrl+G on Windows to open Go To, enter a reference such as C7, and select OK. This helps avoid clicking a nearby blank cell. On Mac, the common Go To shortcut is Control+G.

Understand formulas that return an empty display

A formula can return an empty string, making the cell look blank even though it contains a formula. If the selected cell is the one with that formula, the formula bar should still show the formula. The grid displays the formula’s result, not the formula text, unless you edit the cell or use the formula bar to inspect it.

For example, with a formula in B2 that refers to A2, an empty A2 can make B2 display nothing when the formula is written to return an empty string. The formula bar for B2 should still show =IF(A2="","",A2). This example assumes the source value is in A2; when A2 is empty, the result displayed in B2 is an empty string. If the bar is truly blank, double-check that B2—not A2 or another neighboring cell—is selected.

A genuinely blank cell and a formula returning an empty string can look alike in the worksheet, but they are different. Selecting the formula cell reveals its formula in the bar. This distinction matters when troubleshooting copied formulas, conditional displays, or reports that intentionally leave results blank until someone enters a value.

Check whether a protected sheet is hiding a formula

Excel can hide a formula from the formula bar when the cell is marked as hidden and the worksheet is protected. This is different from turning off the formula bar: the bar remains visible, but the protected formula cell does not reveal its formula there. A worksheet author may use this protection to keep a calculation from being inspected or edited.

If you are authorized to change the workbook, check whether the sheet is protected on the Review tab. If it is protected, you may need the sheet password or permission from the workbook owner before changing the setting. Do not try to bypass protection on a workbook you do not own or have permission to modify.

For a sheet you are allowed to edit, the cell’s setting is in the Format Cells dialog. Select the cell, open Home > Format > Format Cells, and look at the Protection tab. The Hidden option suppresses a formula in the formula bar only when the worksheet is protected. If you change that option, the sheet must be unprotected first; after making the permitted change, protect it again if protection is required. A hidden formula is not the same as hidden worksheet rows or columns.

Do not confuse the formula bar with worksheet display issues

If text is missing from the cell but visible in the formula bar, the cell’s contents are present and the problem is likely visual formatting or layout. Check the following before changing the formula-bar setting:

  • Column width: Widen the column by dragging its right boundary, or double-click that boundary to AutoFit it. Text may also be obscured by a value in the cell to its right.
  • Font and fill colors: Text colored the same as the cell background can appear invisible. Check the font color and fill on the Home tab.
  • Number format: A custom format can affect how a value is displayed in the grid. Inspect the cell’s number format if numbers or dates look unexpected.
  • Row height or alignment: A small row height or unusual vertical alignment can clip visible content. AutoFit the row height or adjust the alignment.
  • Formula display: If formulas appear across the worksheet instead of their results, check Formulas > Show Formulas. That setting changes what is displayed in cells; it does not turn the formula bar on or off.

These checks address different symptoms. If the bar itself is absent, use the View setting. If the bar is present and shows the content but the grid does not, investigate formatting, column width, or row height instead.

Expand the bar or troubleshoot a display glitch

The formula bar may be visible but too short to show a long entry comfortably. Use the small expand control at the right side of the formula bar, or press Ctrl+Shift+U on Windows to expand or collapse it. The shortcut changes the bar’s height; it does not reveal a formula that is hidden by worksheet protection or restore a bar that has been switched off.

If the setting is enabled and the bar still does not behave normally, try selecting another cell, saving the workbook, and reopening it. You can also maximize Excel and check whether the ribbon or window layout is simply crowding the bar. If the problem occurs only in one workbook, compare a cell in another workbook; that can help separate a workbook-specific protection or content issue from an application-wide display problem.

For a problem that persists across workbooks, close and reopen Excel, then check for Office updates through File > Account > Update Options > Update Now where that option is available. If you use an organization-managed installation, update controls may be managed by your administrator. Avoid changing registry settings or removing workbook protection as a first response; the ordinary display and selection checks usually identify the cause more safely.

Excel for Mac and Excel for the web

On Excel for Mac, look for the Formula Bar option on the View tab or in the View menu, depending on the interface. Turn it on, then select the cell whose contents you want to inspect. The Windows shortcut for expanding the bar is not the same as the Mac convention: Control+Shift+U is commonly used in Excel for Mac to expand or collapse it. Keyboard shortcuts can vary with macOS settings and keyboard layout.

In Excel for the web, use the View tab and its formula-bar display control if the bar has been hidden. The exact arrangement can vary as Microsoft updates the web interface. If a workbook is open in a browser and a feature or control is unavailable, opening it in the desktop app may provide more complete options for inspecting protection and cell settings. A protected formula may still be intentionally concealed in either environment.

Frequently Asked Questions

Why is the formula bar missing in Excel?
It is usually hidden by the Formula Bar display option. In Windows Excel for Microsoft 365, open View > Show and select Formula Bar. If it is already selected, check whether the window or ribbon layout is obscuring the bar.

Why is the formula bar blank when I click a cell?
The selected cell may be empty, or you may have clicked a neighboring cell. Check the cell reference in the name box and select a cell whose contents you know. If the cell contains a formula hidden on a protected sheet, Excel may conceal that formula from the bar.

Why can I see text in the formula bar but not in the cell?
The value is present, but its worksheet display may be affected by a narrow column, overlapping content, font color, row height, alignment, or number format. Adjust the relevant layout or formatting rather than switching the formula bar off and on.

Why does the formula bar show a formula instead of the answer?
That is normal for the selected formula cell: the bar shows the cell entry, while the grid normally shows its calculated result. If formulas are also displayed in worksheet cells, check whether Formulas > Show Formulas is enabled.

Can I expand the formula bar to see a long formula?
Yes. Use the expand control at the end of the bar or press Ctrl+Shift+U on Windows. On Mac, Control+Shift+U is commonly used. This gives the formula more room but does not change the cell’s contents.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.