Excel: See Formulas in Excel 2013

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Problem: I need to audit several formulas. I already know how to use Show Formulas mode, but I need something more permanent.

Strategy: Use the new =FORMULATEXT() function in Excel 2013.

  1. FORMULATEXT is great for documenting, and also for catching shenanigans.