enter is not working for just transpose

%3CLINGO-SUB%20id%3D%22lingo-sub-2104821%22%20slang%3D%22en-US%22%3Eenter%20is%20not%20working%20for%20just%20transpose%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2104821%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20want%20to%20use%20transpose%20function%26nbsp%3B%20first%26nbsp%3B%20i%20appiont%20same%20size%20also%20for%20place%20that%20i%20want%3C%2FP%3E%3CP%3Eand%20i%20use%20enter%20with%20ctrl%2C%20shift%20but%20it%20is%20not%20working%20key%20is%20not%20broken%20if%20i%20push%20only%20enter%20it%20work%2C%3C%2FP%3E%3CP%3Eproblem%20is%20only%20for%20transpose%20function%26nbsp%3B%3C%2FP%3E%3CP%3Ei'm%20not%20good%20at%20english%20but%20i%20want%20to%20know%20why%20please%20help%20me%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2104821%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2104866%22%20slang%3D%22en-US%22%3ERe%3A%20enter%20is%20not%20working%20for%20just%20transpose%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2104866%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F945599%22%20target%3D%22_blank%22%3E%40rladydrhks%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHave%20you%20tried%20just%20pressing%20Enter%20(don't%20press%20Ctrl%20Shift)%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

i want to use transpose function  first  i appiont same size also for place that i want

and i use enter with ctrl, shift but it is not working key is not broken if i push only enter it work,

problem is only for transpose function 

i'm not good at english but i want to know why please help me

2 Replies

Hi @rladydrhks 

 

If you are using Excel 365 you no longer have to user Ctrl Shift as Excel now has Dynamic Array functionality.

 

 

@rladydrhks 

In addition, Ctrl+Shift+Enter on Excel with dynamic arrays returns only first element of the spill