CONTROL+SHIFT+ENTER is used when dealing with array formulas. For a
detailed explanation, have a look in Excel's help menu under 'Array
Formula'.

In article ,
KarenH wrote:

What does the CONTROL+SHIFT+ENTER do that ENTER doesnt? I notice it puts
little curly brackets around the formula -- and that if I just enter, the
values don't come out right -- but I'm wondering what exactly that
combination does. Thanks again!