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. May you help me with this, please!
4 Replies
Try Ctrl+Shift+Return.
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.
