When you need view formulas instead of their results press Ctrl + ~ to display formulas in all cells in the worksheet. To return to viewing the worksheet as it was, press Ctrl + ~ again.

Helen Bradley

Related posts:

  1. Copy Excel Formulas Without Updating References
  2. Trevor’s Quick Excel Tip – Date and Time
  3. Trevor’s Quick Excel Tip – Navigate cells
  4. Trevor’s Quick Excel Tip – Select Everything
  5. View formulas in Excel