CODEWITHSUNDEEP
excelmacosarray-formulasexcel-2011
Ievgenii
Ievgenii

Reputation: 477

Array formula on Excel for Mac

I need to call LINEST in Excel 2011 for Mac, I would say - this was a detective story. My laziness, my curiosity, all was here! I had a homework from university course to use LINEST.

I even stopped trying to do so on MAC, because after googling I could not find any solution how to do it. (I have tried EACH AND EVERY combination of Fn Ctrl Alt Cmd Return!)

Finally, I found a solution here on stack overflow! I want to mention it again, as it was a long time I spent looking for the solution. I have spent 4 days outside of home, to use just windows PC where it is easy as a pie - F2, CTRL+SHIFT+ENTER.

If you want to check if I tell truth - go to HELP in Excel for Mac, type array formula, find LINEST and look at the solution combination!

The solution: select the range, press CONTROL+U and then press ⌘+RETURN.

Here is the link to the original post: Excel formulas giving #VALUE! error when ported to Mac

Upvotes: 17

Views: 143820

Answers (7)

Shubham Khare
Shubham Khare

Reputation: 21

This works 100%.

  1. Select the cells you want to populate with the formulated data.
  2. Press Control + U.
  3. Add your array formula on any cell (preferably first).
  4. Press Control + Shift + Return.

Remember Control and Command are different keys on Mac!!

Upvotes: 2

Anna
Anna

Reputation: 1

This solution worked for me:

  1. When you’ve chosen range of cells in formula press control+u
  2. Then press shift+enter/return

Upvotes: 0

Bubbi von Beijer
Bubbi von Beijer

Reputation: 11

CTRL+SHIFT+ENTER, ARRAY FORMULA EXCEL 2016 MAC. So I arrive late into the game, but maybe someone else will. This almost drove me nuts. No matter what I searched for in Google I came up empty. Whatever I tried, no solution seemed to be in sight. Switched to Excel 2016 quite some time ago and today I needed to do some array formulas. Also sitting on a MacBook Pro 15 Touch Bar 2016. Not that it really matters, but still, since the solution was published on Youtube in 2013. The reason why, for me anyway, nothing worked, is in the Mac OS, the control key by default, for me anyway, is set to manage Mission control, which, at least for me, disabled the control button in Excel. In order to enable the key to actually control functions in Excel, you need to go to System preferences > Mission Control, and disable shortcuts for Mission control. So, let's see how long this solution will last. Probably be back to square one after the coffee break. Have a good one!

Upvotes: 1

Wild Woz
Wild Woz

Reputation: 1

  1. Select the desired range of cells
  2. Press Fn + F2 or CONTROL + U
  3. Paste in your array value
  4. Press COMMAND (⌘) + SHIFT + RETURN

Upvotes: -3

sscc
sscc

Reputation: 21

Found a solution to Excel Mac2016 as having to paste the code into the relevant cell, enter, then go to the end of the formula within the header bar and enter the following:

Enter a formula as an array formula Image + SHIFT + RETURN or CONTROL + SHIFT + RETURN

Upvotes: 1

damien_papworth
damien_papworth

Reputation: 339

This doesn't seem to work in Mac Excel 2016. After a bit of digging, it looks like the key combination for entering the array formula has changed from ⌘+RETURN to CTRL+SHIFT+RETURN.

Upvotes: 33

Ievgenii
Ievgenii

Reputation: 477

Select the range, press CONTROL+U and then press ⌘+RETURN.

Upvotes: 7

Related Questions