Forum Discussion
Array Formula on Macbook
I am trying to get the output of an array formula using a Macbook such as TRANSPOSE, MMULT, etc. I know it should be Ctrl+Shift+Enter on windows but I have no clue what this combination is on Macbook...
Doesn't work HansVogelaar
Try Command+Return or Shift+Command+Return
Remark: if you have Microsoft 365 or Office 2021, you don't need to do this anymore. In those versions, Excel treats ALL formulas as array formulas automatically.
- Thanks. I do. Then the formula created (that's supposed to be an array) does not work. Hmm.