Apr 14 2021 03:04 AM
Hello,
I am using Excel with Microsoft Office 2019 in a Windows 10 OS.
Some days ago I remember using the frequency function without the Ctrl+Shift+Enter, and all the results spilled in a matrix all the way down.
Nevertheless, today I tried to use it, and had to use the Ctrl+Shift+Enter functionality, as in the old versions of Excel.
I've reinstalled and restored Office and didn't work. Also searched on the internet, and on the Excel options and didn't find nothing that could give answer to my problem.
I suspect that the recent update of my OS by Microsoft might have produced the loss of this functionality.
I hope you can help me.
Thanks.
Apr 14 2021 04:22 AM
SolutionDynamic arrays and spilling is only supported by Office 365 and probably the next Excel 2021 but never Excel 2019.
Apr 14 2021 04:55 AM
Well, guess I should be wrong and that never happened in my Excel.
Thanks for your response.
Case closed.
Apr 14 2021 04:22 AM
SolutionDynamic arrays and spilling is only supported by Office 365 and probably the next Excel 2021 but never Excel 2019.