Do you have Dynamic Arrays in Excel 365?

Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.


It’s quite easy to tell if your Excel 365 has the new Dynamic Arrays. No need to setup a table and use the new feature – just three keypresses are enough.

Some people are reporting that they have the right Excel 365 but with no dynamic arrays. Checking the program/app version is possible, see below.

Dynamic Arrays are important but not obvious. There are no new buttons on the ribbon.

Instead try to type one of the new Dynamic Array functions. Open Excel 365 (Windows, Mac, Apple, Android, Aardvark <g>) and in any empty cell start typing :

=Sort

do you have dynamic arrays in excel 365 office 365 29881 - Do you have Dynamic Arrays in Excel 365?

After typing the first three characters, autocomplete will show any available functions.

If dynamic arrays are available both Sort() and Sortby() will be offered as suggestions.

Simple as that.

If you want to test a complete function, choose an empty cell with empty cells below it.

=SORT(A1:A10,1,1)

Will sort the first ten cells in Col A, no matter what they are.  The results don’t matter, as long as Sort() works.

do you have dynamic arrays in excel 365 microsoft office 29885 - Do you have Dynamic Arrays in Excel 365?

Another simple dynamic array test is

=RANDARRAY(5,1)

Which inserts random numbers, 5 rows down 1 column.

do you have dynamic arrays in excel 365 office 365 29888 - Do you have Dynamic Arrays in Excel 365?

Which Excel 365 versions have dynamic arrays?

According to Microsoft these are the first Excel 365 versions which have Dynamic Arrays.

Excel 365 for Windows – v 1907 build 11901.20176

However there are many reports that version of Excel 365 for Windows does not have Dynamic Arrays despite what Microsoft says.

Excel 365 for Mac – v 16.27.19071500

Excel 365 for Apple iOS  iPhone/iPad – 2.27 (19070901)

Excel 365 for Android – v 16.0.11901.20110

Excel 365 for Windows Mobile – v 16.11901.20062

Only Excel Online doesn’t support dynamic arrays .., or just ‘Excel’ as we’re supposed to call it now.


Want More?

Office Watch has the latest news and tips about Microsoft Office. Independent since 1996. Delivered once a week.