General Question

flo's avatar

Is Excel 2013 supposed to lead you Transpose for converting vertical to horizontal list, if not what does?

Asked by flo (9916points) January 10th, 2017

Is Excel 2013 supposed to lead you Transpose for converting vertical to horizontal list, and vice versa?
I know this instruction doesn’t mention Excel.
https://www.extendoffice.com/documents/excel/2718-excel-vertical-to-horizontal.html
“1. Select a vertical list or horizontal list you want to convert, and then press Ctrl + C keys simultaneously to copy the list.”
“2. Select a blank cell which you want to locate the converted list.”
“3. Then click Home > Paste > Paste Special. See screenshot.”

After clicking the drop down menu under “File” (not Home) I get “Special Paste”, and clicking that should produce dialog box that includes Transpose. But all I’m getting is the dialog box that only has “Text”, “Unicode text” etc., So, how do I get the dialog box with Transpose in it, whether it’s Excel 2013 or something else?

Observing members: 0 Composing members: 0

8 Answers

ARE_you_kidding_me's avatar

You can just type =transpose( then highlight your cells

zenvelo's avatar

After copying a column, I highlighted a cell, then clicked on Edit>Paste Special> and a menu came up with Transpose at the bottom, and it worked great. I am running an older version of Excel for Mac.

flo's avatar

@ARE_you_kidding_me Type ”=Tanspose” where?
@zenvelo Ok. Why doesn’t the above instruction take me to the one with Transpose though?

ARE_you_kidding_me's avatar

In a blank cell. Excell 101

Stinley's avatar

Does this article help you? I have Excel 2010 so can’t try it out.

flo's avatar

@Stinley Thanks but that’s almost the same instruction as the one in my OP.

ARE_you_kidding_me's avatar

Highlight the cells you want to transpose, type =transpose in the equation bar hit cntl-alt and enter

flo's avatar

@ARE_you_kidding_me I tried it, nothing happened.

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther