Thank you everyone. All your suggestions work perfectly.
Thanks again,

"FSt1" wrote:

hi
another way would be to use the keyboard shortcut Ctrl + ~ .
this would allow you to toggle from normal view to formula view and back.

Regards
FSt1

"Lee" wrote:

Does anyone know how to list all the formulas in a worksheet and what cells
they are in?
Thanks in advance,