Office Settings & Configuration

Fix Excel Formula Bar Showing Cell References Instead of Values

Maira Mehtab Sep 28, 2026 870 views

Question details

The user needs to restore the display of cell values and formulas in the Excel formula bar, which currently appears to only show cell references.

Product: Excel
Device & OS: not provided
Scenario: Viewing or editing data and formulas in the Excel workspace.
Observed behavior: The formula bar seems to only display the cell reference (like A3 or B2), occurring because the Name Box has been expanded too far, covering the actual Formula Bar space.

Before you start

Open your Excel spreadsheet and ensure that the Formula Bar is enabled in the View tab before attempting to adjust its layout.

Solution 1Recommended

Adjust the Name Box and Formula Bar Divider

Resize the Name Box to restore the visible space for the Formula Bar so you can see your cell contents.

In Excel, the Name Box (which shows the cell reference) and the Formula Bar share the same horizontal row. If the divider between them is accidentally dragged to the right, the Name Box takes up the entire space, hiding your formulas and values.

Locate the Divider

Look at the area just above your spreadsheet grid. Find the vertical divider line that separates the Name Box on the left from the Formula Bar on the right.

Drag to Resize

Hover your mouse cursor over the vertical divider until it turns into a double-headed horizontal arrow. Click and hold, then drag the divider towards the left to reduce the size of the Name Box.

Verify the Display

Select a cell containing data or a formula. Look at the newly expanded Formula Bar space to confirm that the cell's actual value or formula is now fully visible.

Quick Adjustment Tip: You can usually double-click the vertical divider to automatically snap the Name Box back to its default width.

WPS Office Spreadsheet

Easily Manage Formulas and Layouts in WPS Spreadsheet

WPS Office provides a clean, highly compatible spreadsheet interface where managing formulas, cell references, and workspace layouts is intuitive and straightforward without annoying UI glitches.

1. Open WPS Spreadsheet: Launch WPS Office and open your workbook or create a new one.
2. Locate the Formula Bar: Find the Formula Bar below the ribbon, which displays the Name Box on the left and the cell contents on the right.
3. Adjust the Workspace: Hover over the space between the Name Box and Formula Bar. Click and drag the vertical divider left or right to customize your viewing space perfectly.

Fully compatible with Microsoft Excel (.xlsx, .xls) formats and formulas.Intuitive Formula Bar and Name Box layout that is easy to customize.Lightweight and fast, ensuring smooth performance even with large datasets.Free to download with a familiar user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why did my Formula Bar completely disappear in Excel?

If the entire Formula Bar is missing, it is likely disabled in your view settings. Go to the 'View' tab on the ribbon and check the box next to 'Formula Bar' to restore it to your workspace.

How do I expand the Formula Bar to show multiple lines?

You can expand the Formula Bar vertically by clicking the small down arrow at the far right of the Formula Bar, or by using the keyboard shortcut Ctrl + Shift + U.

Can I completely hide the Name Box in Excel?

The Name Box cannot be completely hidden or removed from the interface. However, you can minimize its width by dragging the divider between it and the Formula Bar as far to the left as possible.

What is the difference between the Name Box and the Formula Bar?

The Name Box displays the address or assigned custom name of the currently selected cell (e.g., A1), while the Formula Bar shows the actual text, data, or underlying mathematical formula entered into that specific cell.

Office App Problems