copied vertical data always pastes horizontally

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
Forum Rules Please read the forum rules before posting!

Put CODE tags around your macro/vba code in a post. Easy way to do this: select the macro/vba in your post and click the CODE button above where you input the text.

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
 
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
Do what you can, with what you have, where you are. (FDR)
Sisyphus
 
Posts: 4437
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 198
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 13 guests