Send to a Friend

flo's avatar

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

Asked by flo (13313points) 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?

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.