when you edit the formula, you normally exit edit mode by selecting another
cell or hitting Enter. At this point, you should hit Ctrl+SHIFT+enter
instead. (SHIFT, not ALT)

--
Regards,
Tom Ogilvy

"cutsygurl" wrote
in message ...

I'm having trouble making an array. When do you press ctrl-alt-enter?


--
cutsygurl
------------------------------------------------------------------------
cutsygurl's Profile:
http://www.excelforum.com/member.php...o&userid=15041
View this thread: http://www.excelforum.com/showthread...hreadid=383901