how to display the formula bar on excel for mac

The Formula Bar can also be used to edit data or formula in the active cell.

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.

Use the right hand range selector icon to select a cell or range from the workbook as input.

If there is no equals sign, then whatever is typed in the cell will not be regarded as a formula.

An addition formula using the plus sign, subtraction formula using the negative sign -, a multiplication formula using an asterisk sign and division formula using the slash.

The first way is using the keyboard and the arrow keys, the second way using the keyboard and mouse and a third way to use the keyboard by typing directly the formula and the address of cell involved.

The reduction formula to use the second way, i.e.

For the multiplication formula using the third way of using the keyboard by writing directly the formula and the address of the cell involved.

To see formulas in other cells just move the cursor to the desired cell and see the formula in the formula bar.

To be able to display all the formulas in a worksheet, please read the article below How to Display Cell Formulas in Excel.

The contents of the formula will appear, and the cells involved in the formula will be marked with a colored box.

The address of the cell B1 light blue colored then the cell B1 will be surrounded with the same colored line, likewise with cell B2, the color of lines around it is same as cell B2 address color.

For example, the formula will be edited by subtracting the number 2.

The difference, which is copied is the formula, not the value of the cell and the cell address forming the formula will be changed according to the location.

Do a copy (CTRL C).

Select C4: F4 range, then paste it (CTRL V).

Cell C4 contains a formula that adds C1 and C2 values, as well as cell D4 until F4; all contain a formula that adds cell values in row 1 and row 2 in the same column.

Click cell B5, point mouse to bottom right of cell B5 until the cursor change shape become thinner.

The question is what if you want to copy the value, not the formulas.

Range A4:F7 mostly contains the formula, what if the range is copied and placed on the range A9:F11.

If checked, cell B9 contains formula B6B7, as well as other cells in range B9:F12, all containing formulas.

Select range A4:F7.

Do a copy (CTRLC).

Place the cursor in cell A9, and then do a paste special (CTRLALTV).

If rechecked, the content of cell B9 and other cells in the range B9:F12 is not a formula but a number.

There is one drawback, only can see the formula in one cell only.

If you want to see all the formulas that exist in the worksheet, the only way is to use the Show Formulas command.

Click once, then all data generated from formula will show its formula.

How To Display The Formula Bar On Excel For Mac