New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.

ExcelKey

copied vertical data always pastes horizontally

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

copied vertical data always pastes horizontally

Postby azaba » Thu Mar 22, 2012 12:51 am

Whenever I copy vertical columns of data from a website and paste it to my spreadsheet, it always pastes it horizontally instead of vertically! When I copy vertical columns from "my spreadsheet" and paste it, it pastes vertically as I've copied it. Why the differance from a website?

Thanks for any help.
  • 0

azaba
Rookie
 
Posts: 1
Joined: Mar 22, 2012
Reputation: 0
Excel Version: 2007

Re: copied vertical data always pastes horizontally

Postby Sisyphus » Thu Mar 22, 2012 3:22 am

Hello azaba,
What you describe is called "transpose" and is a function of Paste Special. You should be able to get or not get this functionality at your will and not Excel's. Read morea bout this at the following link:
http://www.dummies.com/how-to/content/using-paste-options-with-copied-data-in-excel-2010.html

I hope this helps.
  • 0

Have a great day! :D

Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
Former Moderator
 
Posts: 4454
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 203
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 7 guests