Excel: Formula Bar

The formula bar is located between the ribbon and the workspace. When you click any cell in the worksheet, Excel will display contents of the cell inside the formula bar and its address in the Name Box that is located to the left.

You can enter or edit the formula in the formula bar, as well as directly in a cell.


Between the Name Box and the Formula Bar, you will find three icons.

  1. The first icon is called Cancel. Click it if you want to finish editing the cell. It’s an equivalent of the Esc key.
  2. The second icon is Enter. It works the same way as the Enter from the keyboard. It is used to accept changes inside a cell.
  3. The third icon is called Insert Function. When you click it, a window with the list of functions to choose will appear. 

Visibility of the Formula Bar

If you want to hide or display the formula bar, you can do it in VIEW >> Show >> Formula Bar.