Question

is there any stop by step solution that displays most of the formulas

Answer 1

Show most of the Formulas

1. To display all formulas, in all cells, press CTRL + ` (you can find this key above the tab key).
2. Press ↓ twice.
3. Note: as you can see, Excel highlights all cells that are referenced by a formula. ...
4. To hide all formulas, click Show Formulas again.