You may or more not know that you can display all of the Formulas in your worksheet by clicking the Formulas tab on the Ribbon and then clicking the Show Formulas button on the Ribbon. This will display the actual formula in each cell of your worksheet that contains one.
But you can also toggle the display of formulas from any tab of your worksheet by using the Ctrl and ~ keystroke combination (Ctrl + ~). If you wish to display the dependent cells for a specific formula as well, select the cell for whose formula you wish to show dependencies.
To Toggle the Display of Formulas in Cells:
- Press the [Ctrl] and ~ keystroke combination.
- To display dependent cells for a formula, select the cell before typing in the keystroke combination.
Similar Posts:
- Using 3-D Formulas and References in Excel
- Enter data in multiple cells in Excel 2007
- Locking and Unlocking Cells in an Excel Worksheet
- Converting Formula Results to Values in Excel
- Quick Navigation in Excel using Ctrl and Arrow Keys
- Using the AutoSum Button in Excel
- Hiding the Ribbon in Word 2010
