Entering an array formula
 

When I press "CTRL + SHIFT + ENTER" to enter an array formula, nothing
happens. I am not able to enter the array formula. Why does this happen and
how do I make the array formula work?

Entering an array formula
 

Can we see the formula? What you expect to happen when you enter it?

Mike

"wthawaii" wrote:

When I press "CTRL + SHIFT + ENTER" to enter an array formula, nothing
happens. I am not able to enter the array formula. Why does this happen and
how do I make the array formula work?

Entering an array formula
 

The only visible indication you have that a formula is an array formula is
that Excel will display the formula in the formula bar enclosed in curly
braces { }. Beyond that, any response is meaningless without seeing the
actual formula. What is the formula you are using? For information about
array formulas, see www.cpearson.com/Excel/ArrayFormulas.aspx.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"wthawaii" wrote in message
...
When I press "CTRL + SHIFT + ENTER" to enter an array formula, nothing
happens. I am not able to enter the array formula. Why does this happen
and
how do I make the array formula work?