There’s a new way to view your formulas in Excel 2013, thanks to a new function called FormulaText(). While other versions of Show Formula force you to choose between seeing your formula or the calculated value, this new function allows you to convert the formula to text and put it in another cell.
This is great for enterprise environments where you need to document your work, and when you are trying to figure out what the last person did in a spreadsheet.
Using FormulaText() is Easy!
- Click your mouse in a blank cell, presumably beside the cell that contains the formula.
- Type =FormulaText(A1) in the blank cell, but replace A1 with the address of the cell you want to view.
- Press Enter.
Like I said, nothing could be easier.!