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

- 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.
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.
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.
In the Excel Ribbon, select the View tab at the top of the window.
In the Show group, select the Formula Bar check box.
Click a worksheet cell and confirm that its reference appears in the Name Box to the left of the Formula Bar.

Check the active workbook window and Excel display mode
Use this check if Formula Bar is already selected but the controls are still not visible.
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. Open the spreadsheet in WPS Spreadsheets: Launch WPS Office, select Spreadsheets, and open your .xlsx or .xls workbook.
- 2. Select the View tab: On the Ribbon, click View to access worksheet display options.
- 3. Enable the Formula Bar: In the View options, turn on Formula Bar to display the formula editing area and cell reference box.
- 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.

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.




