If you’ve ever wanted to view your formulas in an Excel worksheet, perhaps because you suspect one has been overwritten by data or you need to troubleshoot something press CONTROL + ~ to display formulas so you can troubleshoot or debug them. Press the same keystroke again to return to your regular view of your worksheet.

If you select a cell with a formula in it before you press CONTROL + ~ you will see not only the worksheet formulas but also all the precedents to the formula in the current cell.

Helen Bradley