You can toggle in or out of the formula view using
keyboard shortcut Ctrl+` (accent grave left of number 1)
but not very good as the width is 3x normal and if you change
the width it will affect the actual width.

My experience is that you normally only need
some representative formulas and if you put
them on the same spreadsheet they are easier
seen for debugging, see
Show FORMULA or FORMAT of another cell
http://www.mvps.org/dmcritchie/excel....htm#getformat

Instructions to install the Userdefined function above,
or the macro code in the previous reply at
http://www.mvps.org/dmcritchie/excel....htm#havemacro

BTW, I would also include the formatted value in Tip 37
Range("D1") = "Displayed"
Range("A1:D1").Font.Bold = True
...
Cells(Row, 3) = Cell.Value
Cells(Row, 4) = Cell.Text

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"T. Valko" wrote in message ...
See this:
Creating a List of Formulas (address, formula, value)
http://j-walk.com/ss/excel/tips/tip37.htm

Biff

"sandyramanuj" wrote in message
ups.com...
Often we use multiple formulaes in a work sheet, and to verify them at
a glance is not possible. I would request to group members, how to
review all the formulaes inserted in a particular work sheet all at
once, or is any way print out facility of the same is possible or not.
- Your valued answers will help others too for effecient checking all
the formulaes.
Regards Sandy