Viewing formulas

[Lynne Mawson]

I need to find a formula that's on the sheet I'm working on - I don't know
what it is or where it is and it's causing problems. How can I display all
formulas on the sheet I'm working on?

 

[Gary''s Student]

Touching CNTRL ~ will toggle the display to shows formulas as opposed to
values in the cells.

 

[Niek Otten]

Hi Lynne,

CTRL` (accent grave) toggles formula view
You can also look at Tools>Formula editing>Trace errors

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I need to find a formula that's on the sheet I'm working on - I don't know
| what it is or where it is and it's causing problems. How can I display all
| formulas on the sheet I'm working on?
| --
| Lynne Mawson
| Manchester

 

[Roger Govier]

Hi Lynne

Type Ctrl + ` that is hold down Control and the key to the left of the
number 1 at top left of your keyboard.
That is a toggle to switch back and forth between normal view and
formula view.

 

[Ken Wright]

Edit / Find / =

will take you to the formulas