When you enter formula in a cell, Excel calculates and return the result to be shown in that cell. You will not be able to see the formula any more unless you select that cell. Sometimes you might need to display all the formulas appearing in a sheet instead of results. You can quickly do this in Excel by using a short-cut Ctrl+` (grave accent). See that key left side of number 1 key, that's the one to be pressed along with control key.
In Excel 2007 or later, you can also do this by clicking on Formula tab > Formula Auditing group > Show Formulas. In Excel 2003 or earlier versions, Tools > Formula Auditing > Formula Auditing Mode
Doing this will not change the way calculations are made in Excel. Only appearance of Excel window will be changed. All columns size will become broader and instead of results in the cell, all formulas will be displayed. Any range references used in the formulas will be highlighted with different colour borders.
You can read through all the formulas and edit / delete any formula just the way you do in regular mode. You can as well print the sheet with formulas appearing all over.
Pressing the short-cut again or clicking in sequence above make the Excel appear normal. Enjoy!!
No comments:
Post a Comment