SOLVED

Excel error with spilling in frequency function

%3CLINGO-SUB%20id%3D%22lingo-sub-2272058%22%20slang%3D%22en-US%22%3EExcel%20error%20with%20spilling%20in%20frequency%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2272058%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20Excel%20with%20Microsoft%20Office%202019%20in%20a%20Windows%2010%20OS.%26nbsp%3B%3C%2FP%3E%3CP%3ESome%20days%20ago%20I%20remember%20using%20the%20frequency%20function%20without%20the%20Ctrl%2BShift%2BEnter%2C%20and%20all%20the%20results%20spilled%20in%20a%20matrix%20all%20the%20way%20down.%26nbsp%3B%3C%2FP%3E%3CP%3ENevertheless%2C%20today%20I%20tried%20to%20use%20it%2C%20and%20had%20to%20use%20the%20Ctrl%2BShift%2BEnter%20functionality%2C%20as%20in%20the%20old%20versions%20of%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20reinstalled%20and%20restored%20Office%20and%20didn't%20work.%20Also%20searched%20on%20the%20internet%2C%20and%20on%20the%20Excel%20options%20and%20didn't%20find%20nothing%20that%20could%20give%20answer%20to%20my%20problem.%3C%2FP%3E%3CP%3EI%20suspect%20that%20the%20recent%20update%20of%20my%20OS%20by%20Microsoft%20might%20have%20produced%20the%20loss%20of%20this%20functionality.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20you%20can%20help%20me.%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2272058%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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. 

2 Replies
best response confirmed by JosemaLopez (New Contributor)
Solution

@JosemaLopez 

Dynamic arrays and spilling is only supported by Office 365 and probably the next Excel 2021 but never Excel 2019.

 

@Detlef Lewin 

Well, guess I should be wrong and that never happened in my Excel. 

Thanks for your response. 

Case closed.