The F2 key in Excel toggles between Edit and Enter modes. Monitor formulas and their calculated values (Watch Window).Trace formula relationships in Excel (Trace Precedents and Trace Dependents).Highlight all formulas that reference a given cell.Highlight all cells a given formula refers to.Highlight and match parenthesis pairs in Excel formulas.Debug a formula by using the Evaluate Formula feature.Use F9 to evaluate and debug formula parts.Today, I'd like to share a few tips and techniques to check, evaluate and debug Excel formulas that will hopefully help you work even more efficiently with Excel. If you've had a chance to read them, you already know how to write formulas in Excel, how to show formulas in cells, how to hide and lock formulas, and more. In the last few tutorials, we have been investigating different aspects of Excel formulas.
See how to use the F9 key to evaluate formula parts, how to highlight cells that reference or are referenced by a given formula, how to determine mismatched or misplaced parentheses, and more. In this tutorial, you will learn a few quick and efficient ways to check and debug formulas in Excel.
