ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   array function (https://www.excelbanter.com/excel-discussion-misc-queries/33456-array-function.html)

cutsygurl

array function
 

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


Tom Ogilvy

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





All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com