Using the keystroke shortcut Ctrl+~ (or a Formulas tab button)  display all formulas  instead of results  in the current worksheet Use a simple command sequence to highlight all cells in the current worksheet that contain formulas  use another command sequence to highlight all cells containing numbers