Is Excel 2013 supposed to lead you Transpose for converting vertical to horizontal list, if not what does?
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.
“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?
This question is in the General Section. Responses must be helpful and on-topic.