or simply use Ctrl-` (that's the key to the left of the 1 on the top row.
This toggles the setting.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Paul W Smith" wrote in message
...
Tools | Options | View

Tick Formulas in Window options section


"scrabtree23" wrote in message
...
How can I quickly identify all cells with a formula in
them?