The Formula Bar in Microsoft Excel is one of the most critical elements of the spreadsheet interface, displaying cell coordinates, calculated formula syntax, and raw text entries. However, pressing accidental keyboard shortcuts or opening workbooks saved with minimalist display settings can cause the Formula Bar to disappear completely. Conversely, when presenting complex dashboards on smaller laptop screens, hiding the bar reclaims valuable vertical rows. Here is how to show or hide the Formula Bar in Microsoft Excel.
Method 1: Toggling the Formula Bar via the View Ribbon (Fastest)
The standard Excel ribbon provides an instant checkbox to control Formula Bar visibility:
- Open your workbook in Microsoft Excel.
- Click the View tab on the top ribbon.
- Locate the Show group (positioned between the “Workbook Views” and “Zoom” sections).
- Find the checkbox labelled Formula Bar.
- Tick the Formula Bar box to restore the bar immediately beneath the ribbon, or untick the box to hide it and expand your visible worksheet rows.
Method 2: Restoring the Formula Bar via Excel Advanced Options
If the View ribbon checkbox is greyed out or fails to persist across new workbooks, configure the setting permanently in Excel Options:
- Click the File tab in the top-left corner of the window.
- Select Options at the bottom of the left sidebar.
- In the Excel Options dialogue box, click Advanced in the left pane.
- Scroll down to the section titled Display.
- Locate the option labelled Show formula bar.
- Tick the box next to Show formula bar to make it permanently visible across all Excel sessions.
- Click OK at the bottom of the window to confirm.
How to Expand or Collapse the Formula Bar for Long Formulas
When working with lengthy nested IF, XLOOKUP, or LET formulas that spill outside a single line, you can expand the Formula Bar vertically without altering system view settings:
- Keyboard shortcut: Press Ctrl + Shift + U to toggle between a single-line view and an expanded multi-line formula box.
- Manual dragging: Hover your mouse cursor over the bottom horizontal border of the Formula Bar until it changes into a double-headed vertical arrow, then drag downward to your desired height.