Viewing formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Touching CNTRL ~ will toggle the display to shows formulas as opposed to
values in the cells.
 
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
 
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.
 
Back
Top