How to hide, display, and expand the Formula bar

Excel 365
The Formula bar displays data and formulas for the current cell in Microsoft Excel. You can expand the formula editor if the data or formula does not fit and hide the formula bar if you need more screen space.

Expand and collapse the Formula bar

When working with long formulas in the default position of the Formula bar, you may not see the entire formula. Excel starts scrolling the text to the left as you continue typing. The best way to avoid this and see the whole formula is to expand the Formula bar. There two ways to expand the formula editor:

  • Drag the bottom edge of the Formula bar downward:
    Expand and collapse the Formula bar in Excel 365
  • Click the arrow at the right corner of the Formula bar:
    Expand and collapse the Formula bar 2 in Excel 365

See also how to create new lines in the Formula bar.

Hide the Formula bar

Many Excel users do not use the Formula bar but need more screen space (see how to collapse the Ribbon to get more space on the screen and hide spreadsheet tabs).

To hide the Formula bar, do one of the following:

  • On the View tab, in the Show group, uncheck the Formula bar option:
    Formula bar option in Excel 365
  • On the File tab, click the Options button:
    Excel 365 Options

    In the Excel Options dialog box, in the Advanced tab, under Display, uncheck the Show formula bar option:

    Show formula bar in Excel 365

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more