Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reveal unshown data in cell | Excel Discussion (Misc queries) | |||
Excel 2002: How to reveal grid lines on color shaded worksheet? | Excel Discussion (Misc queries) | |||
ExcelExcel 2002 display formula in another cell as text | Excel Worksheet Functions | |||
Can I hide rows in Excel 2002 using a formula in a cell? | Excel Discussion (Misc queries) | |||
Reveal cell formats and extendable range in tool/statusbar/icon. | Excel Worksheet Functions |