How to show all formula's
 

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


--
MichaelJDrake
------------------------------------------------------------------------
MichaelJDrake's Profile: http://www.excelforum.com/member.php...o&userid=31892
View this thread: http://www.excelforum.com/showthread...hreadid=516181

How to show all formula's
 

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"
wrote in message
news:MichaelJDrake.23qmwb_1140791704.1894@excelfor um-nospam.com...

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


--
MichaelJDrake
------------------------------------------------------------------------
MichaelJDrake's Profile:
http://www.excelforum.com/member.php...o&userid=31892
View this thread: http://www.excelforum.com/showthread...hreadid=516181

How to show all formula's
 

F5 Special Formulas ok

Vaya con Dios,
Chuck, CABGx3



"MichaelJDrake" wrote:


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


--
MichaelJDrake
------------------------------------------------------------------------
MichaelJDrake's Profile: http://www.excelforum.com/member.php...o&userid=31892
View this thread: http://www.excelforum.com/showthread...hreadid=516181

How to show all formula's
 

If you mean showing the formulas themselves:

ToolsOptionsView, check Formulas

If you mean highlighting the cells:

EditGo ToSpecial, check Formulas

--
Kind regards,

Niek Otten

"MichaelJDrake"
wrote in message
news:MichaelJDrake.23qmwb_1140791704.1894@excelfor um-nospam.com...

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


--
MichaelJDrake
------------------------------------------------------------------------
MichaelJDrake's Profile:
http://www.excelforum.com/member.php...o&userid=31892
View this thread: http://www.excelforum.com/showthread...hreadid=516181

How to show all formula's
 

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 values


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=516181