 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Excel 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  SignatureA36B58K641 just touch CNTRL-` to toggle the display SignatureGary''s Student - gsnu200776 > Dear Sir > [quoted text clipped - 9 lines] > > Low Dear Sir, Thanks for the tip. Low SignatureA36B58K641 > just touch CNTRL-` to toggle the display > [quoted text clipped - 11 lines] > > > > Low Use Ctrl + ~ to reveal the formula. > Dear Sir > [quoted text clipped - 12 lines] > -- > A36B58K641 Hello Muddan, Thanks for the tip. Low SignatureA36B58K641 > Use Ctrl + ~ to reveal the formula. > [quoted text clipped - 14 lines] > > -- > > A36B58K641 Hi Mr. Low Press on Ctrl+` (Accent grave) key before number 1 to unhyde/hyde formulas. Regards Cimjet > Dear Sir > [quoted text clipped - 9 lines] > > Low Dear Sir, Thanks for the tip. Low SignatureA36B58K641 > Hi Mr. Low > Press on Ctrl+` (Accent grave) key before number 1 to unhyde/hyde formulas. [quoted text clipped - 14 lines] > > > > Low You're welcome - thanks for feeding back. Regards Cimjet > Dear Sir, > [quoted text clipped - 22 lines] >> > >> > Low |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.