enter is not working for just transpose

Copper Contributor

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