using control + shift + enter

[jrtaylor]

For Excel 2007, does this key function only work after typing in a formula into a cell? I tried pasting the formula and am unable to get the {}.

Is there some setting in preferences to allow this?

Thanks.

[shg]

Drag and drop, autofill, and copying all preserve array formulas. The only think you can't do is copy a formula into the formula bar and then just press Enter.

[jrtaylor]

thanks! it worked.