I am attempting to paste a string of horizontal text vertically into Excel 2010. I have tried several things.
When I simply paste it is horizontal text. When I paste special to try and transpose , that option does not appear.
When I ctrl+c the horizontal text I pasted and then I do get the transpose option, it does not change the text to vertical.