can you show formulas in selected cells only of a worksheet?
 

I am trying to show formulas in certain cells of a worksheet, but not all.
When I use the ctrl+` command it changes all the cells and not just the ones
I've selected. Is it possible to only show formulas in selected cells?

can you show formulas in selected cells only of a worksheet?
 

In the selected cells, use edit/replace, and change "=" to "x=". When you're
finished viewing/printing them, change "x=" to "="
(no quotes)
Bob Umlas
Excel MVP

"covenantdanes" wrote in message
...
I am trying to show formulas in certain cells of a worksheet, but not all.
When I use the ctrl+` command it changes all the cells and not just the
ones
I've selected. Is it possible to only show formulas in selected cells?

can you show formulas in selected cells only of a worksheet?
 

There is no support for this.

--
Regards,
Tom Ogilvy

"covenantdanes" wrote in message
...
I am trying to show formulas in certain cells of a worksheet, but not all.
When I use the ctrl+` command it changes all the cells and not just the
ones
I've selected. Is it possible to only show formulas in selected cells?

can you show formulas in selected cells only of a worksheet?
 

see the user defined functions GetFormula and GetFormulaD in
http://www.mvps.org/dmcritchie/excel/formula.htm

Not exactly what you asked for but I think it is much better, because
you can place these User Defined Functions anywhere on the sheet
to show representative cells, and you can print the worksheet showing
actual worksheet with some functions shown.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"covenantdanes" wrote in message
...
I am trying to show formulas in certain cells of a worksheet, but not all.
When I use the ctrl+` command it changes all the cells and not just the ones
I've selected. Is it possible to only show formulas in selected cells?