View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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?