Array formula on Excel for Mac

Question

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

User · Accepted Answer

Select the range  press CONTROL U and then press   RETURN

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

Select the desired range of cells Press Fn   F2 or CONTROL   U  Paste in your array value Press COMMAND       SHIFT   RETURN

[excel] Array formula on Excel for Mac

Examples related to excel

Examples related to macos

Examples related to array-formulas

Examples related to excel-2011