What Is The Formula Bar?

 

The Formula Bar is where data or formulas you enter into a worksheet appear for the active cell. The Formula Bar can also be used to edit data or formula in the active cell.

 

006-Formula-Bar-With-Active-Cell Formula Bar

 

The active cell displays the results of its formula while we see the formula itself in the Formula Bar.

 

Expanding Or Contracting The Formula Bar

 

001-Formula-Bar Formula Bar

 

The Formula Bar can be expanded either vertically or horizontally depending on your needs.

  1. To expand the Formula Bar horizontally, move the mouse cursor to the area between the Name Box and the the Formula Bar until the cursor turns into a horizontal double ended arrow. Left click and drag to adjust the horizontal size.
  2. To expand the Formula Bar vertically, move the mouse cursor to the bottom of the Formula Bar area until the cursor turns into a vertical double ended arrow. Left click and drag to adjust the horizontal size.
  3. On the right hand side of the Formula Bar there is a expand or contract toggle. Use this to quickly adjust the Formula Bar.

 

005-Formula-Bar Formula Bar

 

You can also hide the Formula Bar entirely by going to the View tab and uncheck the Formula Bar option.

 

Entering And Editing Data In The Formula Bar

 

002-Formula-Bar Formula Bar

 

Enter data into any cell.

  1. Select the cell where you want to enter your data and start typing.
  2. As you type the data notice the data also appear in the Formula Bar.
  3. To accept the data either click the Check Mark or press Enter. To discard the data either click the X or press Esc.

 

The process for entering a formula is the same except all formulas need to start with “=” (without the quotation marks). To edit any data and formula in any cell, select the cell and either click into the Formula Bar or press F2 to enter editing mode.

 

The Insert Function Dialog Box

 

If you’re not familiar with what functions Excel offers, then the Insert Function dialog box is a great way to learn what functions are available, what they do and how to use them.

 

003-Formula-Bar Formula Bar

 

Insert Function dialog box.

  1. Select a cell where you want to enter a function.
  2. Press the Insert Function icon.
  3. You can search for functions by typing in keywords and pressing the Go button, or select functions based on category using the drop down menu.
  4. Select a function.
  5. View the brief description of what the function does.
  6. Click the Help on this function to read more about the function and see examples in Excel’s help menu.
  7. Press the OK button.

 

004-Formula-Bar Formula Bar

 

Function Arguments dialog box.

  1. Fill in the various argument parameters for the function. Use the right hand range selector icon to select a cell or range from the workbook as input.
  2. As you click on the different function argument parameters, a brief description of it will appear.
  3. The value of your inputs appear to the right of the inputs.
  4. Notice as you enter items into the inputs, the formula bar builds your function.
  5. Here you can see the output that will be returned from the function. This is what will be visible in the worksheet cell.
  6. Press the OK button to enter the function.