Special 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?

Special functions in Excel
 

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


On Feb 28, 4:57 pm, jberlin wrote:
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?

Special functions in Excel
 

--
Array 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!
================================================== ===

"jberlin" wrote in message
...
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?

Special functions in Excel
 

Yes, that is the answer. Thanks to both of you.

"jberlin" wrote:

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?