To bring back the formula bar in Excel, go to the View tab and check Formula Bar in the Show group. It reappears just above the column headings. The formula bar is the long box above the column letters, and it shows the real contents of the selected cell: the formula behind a result, or long text that’s cut off in the cell. To make it taller for long formulas, press Ctrl + Shift + U, or click the down arrow at its right end.
When the formula bar shows references with R and C in place of cell names like B2, you can switch Excel back from numbered columns to letters.

Where the Formula Bar Is
It sits between the ribbon and the worksheet grid, in three parts:
| Part | What it does |
|---|---|
| Name Box (left) | Shows the selected cell’s address, such as D5. Type a cell or range name here to jump to it. |
| Buttons (X, check mark, fx) | Cancel an edit, confirm an edit, or open the Insert Function dialog |
| Contents box | Shows and edits the cell’s formula or value |
Show or Hide the Formula Bar
Excel for Windows (Excel 2013 through Microsoft 365)
- Click the View tab.
- In the Show group, check Formula Bar. Uncheck it to hide the bar.
Alternative: File > Options > Advanced, then under Display, check Show formula bar.
Excel for Mac
Choose View > Formula Bar from the menu bar, or check Formula Bar on the ribbon’s View tab.
Excel for the web
Click View and turn on Formula Bar (under Show).
Can I hide the formula bar for just one workbook?
The setting applies to the Excel window, not individual workbooks. A VBA macro can toggle it when a specific workbook opens.
Expand the Formula Bar for Long Formulas
- Press Ctrl + Shift + U to expand or collapse it.
- Click the small down arrow at the right end of the formula bar.
- Drag the bottom edge of the formula bar down to any height.
- Inside a formula, press Alt + Enter to add a line break and make long formulas easier to read.
Edit Without the Formula Bar
Press F2 or double-click a cell to edit its contents directly in the cell. If double-clicking doesn’t work, turn on File > Options > Advanced > Allow editing directly in cells.
Show Formulas in Every Cell
Press Ctrl + ` (the grave accent key, usually left of 1), or go to Formulas > Show Formulas. Every cell now displays its formula instead of the result. Press the shortcut again to switch back.
Need more room for your data? Learn how to insert a new worksheet in Excel.
When the Formula Bar Won’t Behave
The formula bar is checked but still missing
The ribbon or screen may be in a collapsed mode. Press Ctrl + F1 to show the ribbon, or exit full-screen view. Also try maximizing the Excel window.
The formula bar is empty for a cell with a value
The sheet may be protected with hidden formulas. Go to Review > Unprotect Sheet if you have the password. The formulas were hidden under Format Cells > Protection > Hidden.
The formula bar is huge
Press Ctrl + Shift + U or drag its bottom edge back up.
For a tidier window you can also hide ribbon tabs you never open, such as Draw or add-in tabs.

Kermit Matthews runs Live2Tech from just outside Philadelphia. He is an IT specialist with over 20 years of experience, from a university help desk to small-business IT, IT management and his own consulting practice, and has written tech guides full time since 2020. Steps are checked against the current software on a real device or the maker’s official documentation. More about Kermit.