you can use the Show Formulas options to display all formulas at once. When you activate it, Excel temporarily hides the calculated results in all cells and displays the actual formulas instead.

Excel is well known for its many ... but for some of the more commonly used formulas, it's handy to know their shortcuts. First, activate the cell directly to the right or underneath the array ...