Excel cell contents not visible in formula bar

The formula bar in Excel displays the value or formula of the active cell. You can use the formula bar to enter or edit formulas.

Where is the Formula Bar?

The formula bar is located below the ribbon and above the worksheet area.

To enter a formula, execute the following steps.

1. Select a cell.

2. To let Excel know that you want to enter a formula, type an equal sign (=).

3. For example, type the formula A1*A2 and press Enter.

Excel displays the result (50) in the cell and the formula in the formula bar.

Note: use the asterisk symbol (*) to multiply numbers in Excel.

Edit a Formula

You can use the formula bar to quickly edit a formula in a cell (or to change the value in a cell).

1.

Select a cell containing a formula.

2.

How to show formula in excel

Click in the formula bar and change the formula.

Note: use the forward slash (/) to divide numbers in Excel.

3. Press Enter.

Show Formula Bar

Show the formula bar so you can see formulas in cells.

If your formula bar is missing, execute the following steps.

1. On the View tab, in the Show group, check the Formula Ba

how to hide formula bar in excel

how to open formula bar in excel