Excel 2002: How to reveal a formula in a cell ?

[Mr. Low]

Dear Sir

If I have formula at =SUMIF(A$1:A$20,C20,D$1$20) at cell F1,

May I know the quick way to reveal the formula as a text i,e.
‘=SUMIF(A$1:A$20,C20,D$1$20) ?

Currently I could only read from the formula bar , I need to go to the bar
and key in ‘ in front of it in order for it to be shown as text.


Thanks

Low

 

[Gary''s Student]

just touch CNTRL-` to toggle the display

 

[muddan madhu]

Use Ctrl + ~ to reveal the formula.

 

[Cimjet]

Hi Mr. Low
Press on Ctrl+` (Accent grave) key before number 1 to unhyde/hyde formulas.
Regards
Cimjet

 

[Mr. Low]

Dear Sir,

Thanks for the tip.

Low

 

[Mr. Low]

Dear Sir,

Thanks for the tip.

Low

 

[Mr. Low]

Hello Muddan,

Thanks for the tip.

Low

 

[Cimjet]

You're welcome - thanks for feeding back.
Regards
Cimjet