Array Functions on Mac

Hello Kelsey,

Thanks for reaching out!

It really depends on the version you are using. On Excel for Mac, the Ctrl+Shift+Enter shortcut to enter array formulas has been replaced in modern versions (Office 365 or Excel 2019 and later) with dynamic arrays, which eliminate the need for this shortcut in most cases. However, for older Excel versions or when dealing with legacy array formulas, here’s how Mac users can handle it.

If you are using an older version, tr Command (⌘) + Shift + Enter instead of Ctrl+Shift+Enter.

Hope this helps!

Best,
The 365 Team

I am using Office 365, so does that mean I don't have to worry about applying the array formula?

Hello Kelsey,

Thanks for reaching out!

Although not a Mac user I believe you have the newest version so you don't have to use the command.

Best,
The 365 Team

Got it! Thank you Ivan