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.
Great direction and step-by-step process!
I also found that we can obtain a dialog listing of ALL the formulas in the worksheet by using the following steps (within Excel 2010);
1) Click the Formulas tab (upper menu ribbon of Excel)
2) Within the Defined Names group, click the Name Manager icon
3) Dialog appears, which itemizes all the formulas in the current workbook. You can use the Filter drop down (upper-right corner) to further filter and refine the search, too.