Suppose you worksheet has 10 cells with formulas and 20 with text or numbers.
If you use CTRL+` )the key below ESC), then the 10 cell with formulas will be displayed as formula. You cannot have only some of these cells displaying formulas.

You can use a User-defined function such as

Function ShowFormula(Cell as Range) as String
ShowFormula = Cell.Formula
End Function
to display the formula of a specific cell using the syntax =ShowFormula(A1)

If you need help with VBA see David McRitchie's site on "getting started" with VBA

http://www.mvps.org/dmcritchie/excel/getstarted.htm

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"rstiff" wrote in message ...
How do I show formulas in only specific cells in Excel