I was trying to teach some pupils how to display the formulae rather than the
answers. The method involves changing a setting in Tools Options.

As often the case, I try to encourage the use of the help system ... but I
could not find this in the help file using any common keywords that I could
think of. Is it there? What keywords should I be using.

All I kept coming up with is hide/unhide for protected cells.

Many thanks

Martin.

Keyboard...
Ctrl + ` (Ctrl + ~)

Menu...
Tools | Options | View | Formulas
Tools | Formula Auditing | Formula Auditing Mode (xl2002)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Martin Folley"

wrote in message
I was trying to teach some pupils how to display the formulae rather than the
answers. The method involves changing a setting in Tools Options.

As often the case, I try to encourage the use of the help system ... but I
could not find this in the help file using any common keywords that I could
think of. Is it there? What keywords should I be using.

All I kept coming up with is hide/unhide for protected cells.

Many thanks

Martin.

Sorry, I answered the wrong question.
Excel 2000 help is very difficult to use. I can't find the subject in the
help file. It's probably there, but the designer probably thought you would
learn more if you had to read the entire help file to find something.
In Excel 97, it is under "viewing"
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html



"Jim Cone"
wrote in message
Keyboard...
Ctrl + ` (Ctrl + ~)
Menu...
Tools | Options | View | Formulas
Tools | Formula Auditing | Formula Auditing Mode (xl2002)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Martin Folley"

wrote in message
I was trying to teach some pupils how to display the formulae rather than the
answers. The method involves changing a setting in Tools Options.
As often the case, I try to encourage the use of the help system ... but I
could not find this in the help file using any common keywords that I could
think of. Is it there? What keywords should I be using.
All I kept coming up with is hide/unhide for protected cells.
Many thanks
Martin.

Excel 2002 and 2003 Help responds to the keywords "show formulas"

Not sure about 2000

Moot point since Jim has provided help.


Gord Dibben MS Excel MVP

On Fri, 30 Jun 2006 06:55:01 -0700, Martin Folley
wrote:

I was trying to teach some pupils how to display the formulae rather than the
answers. The method involves changing a setting in Tools Options.

As often the case, I try to encourage the use of the help system ... but I
could not find this in the help file using any common keywords that I could
think of. Is it there? What keywords should I be using.

All I kept coming up with is hide/unhide for protected cells.

Many thanks

Martin.