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


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?

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

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?