G
Guest
I can't seem to use array formulas. The problem is when I am finished
editing it. I'll hit CTRL-SHIFT-ENTER and nothing happens; the screen just
blinks and the cursor stays in the formula bar. Could it be that there's an
option somewhere to disable these? I've been pulling my hair out for hours
trying to figure out why this isn't working and cannot seem to find a case of
anyone else having this problem.
Also, I've used array formulas quite a bit in the past and am positive it
has nothing to do with the formula or the way I'm hitting the
CTRL-SHIFT-ENTER command. To double-check that I'm not crazy, I've even
copied examples from Excel's Help sections, and they still won't let me use
the CTRL-SHIFT-ENTER command.
editing it. I'll hit CTRL-SHIFT-ENTER and nothing happens; the screen just
blinks and the cursor stays in the formula bar. Could it be that there's an
option somewhere to disable these? I've been pulling my hair out for hours
trying to figure out why this isn't working and cannot seem to find a case of
anyone else having this problem.
Also, I've used array formulas quite a bit in the past and am positive it
has nothing to do with the formula or the way I'm hitting the
CTRL-SHIFT-ENTER command. To double-check that I'm not crazy, I've even
copied examples from Excel's Help sections, and they still won't let me use
the CTRL-SHIFT-ENTER command.