Formula Bar In Microsoft Excel

Table of Contents[Show]

Formula Bar In Microsoft Excel

Understanding Formula Bar in Excel

What is the formula bar in Microsoft Excel?

The formula bar is a rectangular box that functions to display and edit the contents of the active cell. This section also functions as a place to enter formulas and to edit or improve Excel formulas that have been created.

In addition to typing directly into an active cell, we can input data or write excel formulas in the formula section of this bar.

The formula bar is located between the ribbon and the worksheet area or workspace.

Formula Bar In Microsoft Excel

Name Box

On the left side of the formula bar is called the Name Box which shows the cell address or name of the active cell or range.

In the name box, there is a small triangle icon which, if you select, will show a list of cell names or ranges or other names that are being used in the workbook file you are currently opening.

Name Box

If the file opens new files, those names are of course still empty. 

Cancel, Enter, Insert Function

Between the name box and the formula bar there are 3 icons, each of which has the following functions:

1) Cancel icon (x) : This icon button has the same function as the Esc key on the keyboard, which is to cancel changes or data editing that we do in the formula bar or active cell.

2) Enter icon (): This check icon button functions like the enter key on the keyboard, is used to accept data input or changes to the active cell or formula bar.

3) Insert Function (fx) icon: If you click on this icon an insert function window will open. In this pop-up window we can find a list of Excel functions that we can use to compile an Excel formula as needed.

Cancel, Enter, Insert Function


Change the Height of the Formula Bar

By default the formula bar size only fits to display 1 line of input data only. We can expand the formula bar area by selecting the triangle icon at the far right of the formula bar.

Change the Height of the Formula Bar


To return the formula bar size do the same as before.

return the formula bar size do the same as before


Hide or Show the Formula Bar

Like on Excel's ribbon, we can hide the formula bar to expand the workspace. The trick is to uncheck the Formula bar in the VIEW - Show - Formula Bar tab.

Hide or Show the Formula Bar

To show the hidden formula bar again, you can do it by clicking or checking the section.

Before leaving, don't forget to bookmark and share this excel tutorial article with the buttons provided below. Greetings Excel Class.

Leave a Comment