Special functions in Excel

[Guest]

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?

 

[Pete_UK]

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

 

[RagDyeR]

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

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?

 

[Guest]

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