CTRL+SHIFT+ENTER don't respond

[spery]

Hi,
I try to define an array formula, but the CTRL+SHIFT+ENTER keys don't respond.
So far I already tried:
1. using the CTRL, SHIFT keys both on the right and on the left with all combinations.
2. First writing the formula, then choosing the range and pressing C+S+E => no response.
3. First choosing the range, then writing the formula, then pressing C+S+E => no response
4. I copied the most simple example from the Excel help file, tried to implement the formula there, no luck.
5. Tried the same things on another computer => same no luck.

I'm sure it has something to do with my computers definitions / installations / add-ins. But I have no idea what it is, and I couldn't find anywhere for another shortcut instead of the C+S+E.

Help...

Have a wonderful and cheerful day,
Sarit

 

[VoG]

Perhaps it is the way you are doing it. Try entering the formula as a normal formula, then select the cell with the formula, click within the formula in the formula bar, then hold down CTRL and Shift and press Enter.

 

[spery]

Vog You're a genius!
It worked, I struggled with it for hours, and all it took was your reply
So simple...
Thank you, Thank you, Thank you...
Sarit