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

Dear Sir

If I have formula at =SUMIF(A$1:A$20,C20,D$1:D$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:D$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


--
A36B58K641

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

just touch CNTRL-` to toggle the display
--
Gary''s Student - gsnu200776


"Mr. Low" wrote:

Dear Sir

If I have formula at =SUMIF(A$1:A$20,C20,D$1:D$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:D$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


--
A36B58K641

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

Use Ctrl + ~ to reveal the formula.




On Mar 27, 7:01 pm, Mr. Low wrote:
Dear Sir

If I have formula at =SUMIF(A$1:A$20,C20,D$1:D$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:D$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

--
A36B58K641

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

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

"Mr. Low" wrote in message
...
Dear Sir

If I have formula at =SUMIF(A$1:A$20,C20,D$1:D$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:D$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


--
A36B58K641

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

Dear Sir,

Thanks for the tip.

Low
--
A36B58K641


"Gary''s Student" wrote:

just touch CNTRL-` to toggle the display
--
Gary''s Student - gsnu200776


"Mr. Low" wrote:

Dear Sir

If I have formula at =SUMIF(A$1:A$20,C20,D$1:D$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:D$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


--
A36B58K641

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

Dear Sir,

Thanks for the tip.

Low
--
A36B58K641


"Cimjet" wrote:

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

"Mr. Low" wrote in message
...
Dear Sir

If I have formula at =SUMIF(A$1:A$20,C20,D$1:D$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:D$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


--
A36B58K641

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

Hello Muddan,

Thanks for the tip.

Low

--
A36B58K641


"muddan madhu" wrote:

Use Ctrl + ~ to reveal the formula.




On Mar 27, 7:01 pm, Mr. Low wrote:
Dear Sir

If I have formula at =SUMIF(A$1:A$20,C20,D$1:D$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:D$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

--
A36B58K641

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

You're welcome - thanks for feeding back.
Regards
Cimjet
"Mr. Low" wrote in message
...
Dear Sir,

Thanks for the tip.

Low
--
A36B58K641


"Cimjet" wrote:

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

"Mr. Low" wrote in message
...
Dear Sir

If I have formula at =SUMIF(A$1:A$20,C20,D$1:D$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:D$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


--
A36B58K641