Paste Transpose option not working different excel in o365

Question

Paste transpose option hidden when i copied one excel to another excel in online(O365) excel. It working in same excel sheet but different excel this option not showing.

Answer 1

Hi EDP!

I'm Jen, and I'd be happy to help you out with this issue.

For the transpose option to be visible, please make sure you copy the data first that you want to be transposed. Using the Cut command or CONTROL+X won’t work.

I hope this information helps. If you have any questions, please let me know and I'd be glad to assist you further.

Best Regards!

Jen :)

Answer 2

Hi Jen,

Thanks for your reply..

I am using o365 online excel not desktop version. Yes, It is working fine when i am using same excel but when copied the data from one excel to another excel the paste transpose option is not visible.

Thanks,

Answer 3

Hi EDP,

I was able to reproduce the issue on my end. I apologize but it looks like this is a limitation of Excel for the Web. If the file is synced with your computer, you could try editing it through the Excel desktop app for you to be able to use this option. I also suggest sending a feedback to Microsoft about this. I appreciate your kind understanding.

https://support.microsoft.com/en-us/windows/sen...

Best Regards!

Jen :)