Viewing formulas

L

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?
 
G

Gary''s Student

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

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
 
R

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.
 
Top