# Display Formulas

### Display Formulas

You Can toggle between Excel’s normal display which shows the results of the formulas in the spreadsheet and a display mode that shows the actual formulas.

The keyboard shortcut is **Ctrl + tilde** (tilde is this key: ~)

press it once, and Excel displays formulas instead of results. Press it again, and the results appear again.

You can also use the **Show Formulas** command under the **Formulas tab** rather than using the keyboard shortcut.

### Highlight All Formulas

To select all the cells on the worksheet that contain a formula.

Click on any empty cell.

Select the **Home** Tab.

Click **Find and Select**.

Click **Formulas** from the dropdown menu.

If you would like to have these cells permanently highlighted add a light background colour while you have them selected.

Note: This action is not dynamic and if you delete or add another formula the shading will not change.

armaan

Jul 08, 2015@ 17:40:29challange

View Commentsuppose i have 2 cells. i one cell value i give is 10 then second cell automatically add 10 in his sum. and again when i enter 10 in cell1 then the value of cell2 should 20. if i repeat it again then cell 20should 30

cell1 cell2

10 10

10 20

10 30

21 51

masterexcel

Jul 09, 2015@ 12:03:33A B

1 10 10

2 10 20

3 10 30

4 21 51

Formula in B2 would be =B1+A2 and fill the formula down column B

5

View Comment6