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?
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?
There is no support for this.
--
Regards,
Tom Ogilvy
"covenantdanes" <[email protected]> wrote in message
news:[email protected]...
> 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?
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" <[email protected]> wrote in message
news:[email protected]...
> 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?
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" <[email protected]> wrote in message
news:[email protected]...
> 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?
One excellent option in Excel 2007 is to use "ADD WATCH". Using watch window you can basically WATCH any cell anywhere in the whole sheet while you play around with other cells and their values.
Enter an apostrophe before the equals sign of your formula. The apostrophe tells Excel to treat the remainder of the cell input as a literal, and will be hidden.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks