How to use FormulaText function in Excel

FormulaText function in Excel was introduced in version 2013. It requires just one parameter – the cell from which you want to display the formula.  Even if you select a range, it will return the formula in the top left cell.


Detailed syntax.

When to use the FormulaText function in Excel

Here are three practical scenarios.

  1. It is very helpful in documenting important formulas.
  2. It can also be used as a part of an audit process.
  3. Trainers can use it to teach formulas more effectively.
  4. I find it useful for creating more readable screenshots while creating learning content for Excel.

2 thoughts on “How to use FormulaText function in Excel”

    1. Yes you are correct. This feature was added in 2013. I have updated the post accordingly. Thank you and have a nice day. Dr. Nitin

Comments? Suggestions? Wish list?