Want to find out the formula that is working behind the scenes in a particular cell to bring out the result? It is very easy to display the formulas in the cells in Excel Worksheets.
For Excel 2003
There are two ways to see the formulas in Excel 2003,
1. Go to Tools > Formula Auditing, and click on Formula Auditing Mode.
2. The other way to do is to use the shortcut, Ctrl + ‘. This automatically activates the Formula Auditing Mode. Note that ‘ key is just above the tab key in normal keyboard.
For Excel 2007
Just click on Formulas on the ribbon and then click on Show Formulas
That’s it. You’ll now see the formula that was responsible for bringing the desired results.
You must have noticed that this is the first Excel trick I have published on HackTrix. Do let me know your opinion on it. Also tell me what else you’d like to see on Hacktrix. Waiting for your comments :)