title: excel array formula: not have to 'ctrl-shift-enter'?
body: <p>After you press f2 to edit an array formula e.g. {=MATCH(TRUE,(B2:B100)>0,0)}, the curly brackets disappear of course. After editing, you have to press ctrl + shift + enter to make the curly brackets reappear.</p>
  
  <p>Is there some setting to keep the {} even if you press a normal ‘enter’?</p>
  
  <p>Also after copying the cell above (i.e. containing the array formula) you cannot paste it onto say 10 x other cells. You can only paste it onto one new cell at a time. Is there a way to paste onto more than one cell at once?</p>
  
  <p>Thanks</p>