Formulas, Functions, Formatting, Charts, Data Analysis, etc.
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.
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.
- Posts: 1
- Joined: Mar 22, 2012
- Reputation: 0
- Excel Version: 2007
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:
I hope this helps.
Have a great day!
Do what you can, with what you have, where you are.
- Posts: 3918
- Joined: Dec 7, 2011
- Location: Shanghai
- Reputation: 162
- Excel Version: 2010
Return to General Excel Questions
Who is online
Users browsing this forum: Bing [Bot], Google [Bot], jontherev and 9 guests