How to show all formula's

[MichaelJDrake]

Is it possible to highligt all formulas so that any ommissions or
error's can be seen?

 

[Peo Sjoblom]

Ctrl + ` (grave accent) same key as the tilde ~ will toggle formulas back
and forth
or you can select all formulas using F5 (or Ctrl + G), then special and
formulas

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"MichaelJDrake" <[email protected]>
wrote in message
news:[email protected]...

 

[CLR]

F5 > Special > Formulas > ok

Vaya con Dios,
Chuck, CABGx3

 

[Niek Otten]

If you mean showing the formulas themselves:

Tools>Options>View, check Formulas

If you mean highlighting the cells:

Edit>Go To>Special, check Formulas

--
Kind regards,

Niek Otten

"MichaelJDrake" <[email protected]>
wrote in message
news:[email protected]...

 

[Cutter]

To highlight all formulas:

Edit > Go To > Special > select Formulas > OK
This selects all cells containing formulas


To show all formulas:
Tools > Options > View tab > in Window options select Formulas > OK
This displays all the formulas instead of their value