Ok, guys. I am 100% sure that a few days ago I saw and tested a real built-in Excel formula for showing a formula as text in any cell. Now, when I need it, I cannot find it!!! No VBA, no tricks. Just a simple formula! I think I used it on my home PC, where I have Office 2013. At work I have Office 2010, so I cannot find it. It might be a new feature of Office 2013. The worst thing is that I cannot find it on internet... I saw SHOWFORMULA(). Is that a valid formula? Because It does not work for Excel 2010.
1 Answer
You are correct, Excel 2013 has the FORMULATEXT function which shows the formula as text.
Since Excel 2010 does not have this feature, there are a couple ways you can show formulas without VBA;
- By pressing Ctrl + ` (that's the tilde key above the Tab). This one shows all formulas in the sheet.
- You can place a space it the cell before the
=. This causes Excel to treat the cell as text.
