Formula Bar in Excel: A Beginner’s Guide to Show, Hide & Expand

Formula Bar in Excel: What It Is and How to Use It

Whether you’re performing simple calculations or building complex formulas, the Formula Bar in Excel helps ensure accuracy and enhances efficiency when managing worksheets. In this post, you’ll learn what the Formula Bar is, how to use it effectively, how to expand or collapse it, how to show or hide it, and best practices to follow when using the Formula Bar in Excel.

What is the Formula Bar

The Formula Bar in Excel is a toolbar that is used to view, enter, and edit data or formulas in selected cells. It is especially useful when working with long and complex formulas and functions.

The Formula Baris located below the Ribbon and just above the worksheet grid and has two parts:

• Name Box on the left, which shows the cell address or name. For eg, A12 is displayed in the above image.
• The Formula Input Area, on the right of the Name Box, displays the content of the selected cell, whether it contains a number, text, or a formula.

Why Is the Formula Bar Useful?

• It shows what’s inside a cell (e.g., =SUM (A1:A5) instead of just the final result)
• It let’s you enter or edit formulas
• It helps in debugging errors in the formulas
• It is very useful for long formulas or complex calculations.

How to Expand or Collapse the Formula Bar

Method 1: By using the Mouse

• Hover over the bottom edge of the expanded or collapsed Formula Bar.
• When the cursor turns into a double-headed arrow (↕), click and drag upward or downward to expand or collapse the Formula Bar.

Method 2: By using the down or Up Arrow

• At the end of the formula bar, click on ˅ to expand or ˄ to collapse.

How to Show or Hide the Formula Bar

• Go to:View tab → Show group → Check/Uncheck “Formula Bar”

Best Practices when using Formula Bar

• Use the Formula Bar to avoid errors while editing long formulas for better visibility.
• Expand the bar by dragging its bottom edge for long formulas, or just click on ˅ to expand or ˄ at the end of the formula bar to expand or collapse.
• Use the Keyboard shortcut F2 to edit directly in the cell, or use the formula bar to enter data.
• Press Tab after typing a formula name to auto-complete it.
• Use Ctrl + Z or Ctrl + Y to undo or redo changes.

Summary

• The Formula Bar in Excel is a key feature used to view, enter, and edit data or formulas in selected cells.
• It has Name Box on the left, which shows the cell address or name.
• The Formula Input Area, on the right of the Name Box, displays the content of the selected cell, whether it contains a number, text, or a formula.
• Function Insert (fx), which lets you quickly insert predefined Excel functions
• The formula bar expands for better visibility when working with long formulas.

To explore all our posts covering the fundamentals of Excel, please follow this link.

FAQs