How I can change the direction of Paste All in MS-Excel (MOST URGE

G

Guest

I am using Office 2003. I have copied some data from a word file in Office
Clipboard. Now I want to paste this all data in MS-Excel. When I
choose the "Paste All" option it pastes all data down side, while I want to
paste the data right side / left side. How can I change it's pasting
direction? I do not want to use "Transpose" option beacuse it is tadious &
time consuming. I want to do this with a fasttest manner. How can I do this.
Is it can be done by a macro? If yes then please tell me the macro code.

It is Most Urgent so Please help me as soon as possible.

Hari!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I can change the direction of Paste All in MS-Excel 1
How to paste data into multiple cells in Excel 4
Excel clipboard in Microsoft Office 2007 2
Excel 2010 not allowing me to paste as formula 5
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
i`d like to change the direction of office 2007 to left to right 8
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
Paste a value into "Find What" 1

Top