 |
 | 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 / Worksheet Functions / February 2007Special functions in Excel
I need to update a worksheet that has a formula that is bounded in curly brakets "{}". I remember that they are inserted by a special keystroke, a function key I think, but I can not remember what it is. The Excel help has no info on it. Anyone know what this is and the keystroke that inserts the curly brakets? The curly brackets { and } signify that this is an array formula. When you type it in, or subsequently edit the formula, you should press CTRL-SHIFT-ENTER (CSE) instead of the normal ENTER. If you do this correctly, then Excel will insert the curly brackets when the formula is viewed in the formula bar - you must not type these yourself. Hope this helps. Pete > I need to update a worksheet that has a formula that is bounded in curly > brakets "{}". I remember that they are inserted by a special keystroke, a > function key I think, but I can not remember what it is. The Excel help has > no info on it. Anyone know what this is and the keystroke that inserts the > curly brakets?  SignatureArray formulas are entered using CSE, <Ctrl> <Shift> <Enter>, instead of the regular <Enter>, which will *automatically* enclose the formula in curly brackets, which *cannot* be done manually. Also, CSE *must* be used when revising the formula. -- HTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== I need to update a worksheet that has a formula that is bounded in curly brakets "{}". I remember that they are inserted by a special keystroke, a function key I think, but I can not remember what it is. The Excel help has no info on it. Anyone know what this is and the keystroke that inserts the curly brakets? Yes, that is the answer. Thanks to both of you. > I need to update a worksheet that has a formula that is bounded in curly > brakets "{}". I remember that they are inserted by a special keystroke, a > function key I think, but I can not remember what it is. The Excel help has > no info on it. Anyone know what this is and the keystroke that inserts the > curly brakets? |
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.