making all formulas appear in the cells instead of values

[Alejandro Caballero Aste]

Hi all,

How do I make all the existing formulas in a worksheet appear on it, instead
of the resulting values?
I opened a worksheet that have looks this way, but I don't know how it was
done.

Thanks in advance,

Alejandro

 

[Alejandro Caballero Aste]

I found it out!
tools/options/view/formulas
Thx!

--
Alejandro Caballero Aste
Ministerio de Economía y Finanzas
Dirección General de Asuntos de Economía
Internacional, Competencia e Inversión Privada
Tlf 311-5930 Axo 3536
(e-mail address removed)

 

[Gord Dibben]

Info only.

CTRL + '(backquote above Tab key) will toggle this on/off

Saves a few clicks.


Gord Dibben MS Excel MVP

 

[Alejandro Caballero Aste]

I tried with CTRL + '(backquote above Tab key)
....but nothing happens.

I am using excel 2003

Any ideas?

 

[Gord Dibben]

Other than try another keyboard...........no ideas.

Does your CTRL key work with other shortcut keys?

i.e. CTRL + 9 for hiding rows, CTRL + w for closing workbooks?


Gord