Office Settings & Configuration

Restore the Formula Bar and Name Box in Excel

Elise WilliamsElise Williams Nov 12, 2026 869 views

Question details

Restore the Formula Bar and the Name Box that displays the active cell reference at the top of an Excel worksheet.

How to Restore the Formula Bar and Name Box in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to make the cell location box and formula entry area visible again in the Excel window.
Observed behavior
The Name Box and Formula Bar are missing from the top of the worksheet window.
Before you start

Open the workbook in the Excel desktop app and make sure the worksheet window is active. The Formula Bar setting is controlled from the View tab on the Ribbon.

Solution 1Recommended

Enable the Formula Bar from the Excel View tab

Use this option when the Formula Bar and its associated Name Box are hidden in an Excel worksheet window.

The Name Box appears at the left side of the Formula Bar and shows the reference of the active cell, such as A1. Turning on the Formula Bar restores both controls.

1
Open the View tab

In the Excel Ribbon, select the View tab at the top of the window.

2
Show the Formula Bar

In the Show group, select the Formula Bar check box.

3
Verify the restored controls

Click a worksheet cell and confirm that its reference appears in the Name Box to the left of the Formula Bar.

Enable the Formula Bar from the Excel View tab
Formula Bar restored: When the Formula Bar check box is selected, Excel displays both the formula entry area and the Name Box.
Work with formulas more easily in WPS Spreadsheets

Show the Formula Bar and Cell Name Box in WPS Spreadsheets

WPS Spreadsheets provides a familiar worksheet interface for viewing active cell references and editing formulas. Use its View controls to display the Formula Bar, then continue working with Excel files without changing their layout or formulas.

  1. 1. Open the spreadsheet in WPS Spreadsheets: Launch WPS Office, select Spreadsheets, and open your .xlsx or .xls workbook.
  2. 2. Select the View tab: On the Ribbon, click View to access worksheet display options.
  3. 3. Enable the Formula Bar: In the View options, turn on Formula Bar to display the formula editing area and cell reference box.
  4. 4. Confirm the active cell reference: Select any worksheet cell and verify that its address is shown in the Name Box beside the Formula Bar.
Show the Formula Bar and active-cell Name Box while editing worksheets.Open and edit Microsoft Excel .xlsx and .xls files with strong format compatibility.Use a familiar Ribbon-based interface for spreadsheet settings and formulas.Work in a free, lightweight office suite designed for everyday spreadsheet tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Why is the Name Box missing in Excel?

The Name Box is displayed with the Formula Bar. Go to View on the Ribbon and select the Formula Bar check box to restore it.

Where is the Formula Bar option in Excel?

Open the View tab and look in the Show group. Select Formula Bar to make the formula entry area visible.

Can I use the Name Box when the Formula Bar is hidden?

No. The Name Box is part of the Formula Bar area, so enabling View > Formula Bar restores both features.

What does the Excel Name Box do?

The Name Box shows the address of the active cell, such as B4. You can also type a cell reference or named range in the box and press Enter to jump to it.