Where Is the Formula Bar in Excel? (Show, Hide, Expand)

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.

Spreadsheet View tab with the Formula Bar checkbox in the Show group highlighted and the formula bar showing a SUM formula
Check Formula Bar on the View tab (1). The formula bar (2) shows the formula in the selected cell.

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)

  1. Click the View tab.
  2. 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.