Hi Aindril De,

Thanx,it works,saving my time and, I am new to Macro,

But I could not do this,
The shortcut Key for the above is:

Ctrl+C followed by ALT + e + s + e then hit return (for transpose)
Or

You can consider creating your own shortcut key (one time affair and will
always help you)


On Thu, Jul 2, 2009 at 2:45 PM, Aindril De <aind...@gmail.com> wrote:

> Dear Shivshankar,
>
> You can use the copy -> paste special -> transpose .
>
> The shortcut Key for the above is:
>
> Ctrl+C followed by ALT + e + s + e then hit return (for transpose)
> Or
>
> You can consider creating your own shortcut key (one time affair and will
> always help you)
>
> Create a macro that does what you want
> (try macro recorder)
>
> and then assign a shortcut key combination to the macro.
>
> One macro that I use follows
> Sub PasteValue()
> '
> ' PasteValue Macro
> ' Copy selection and Paste as Value Ctrl-Shift-v
> '
> ' Keyboard Shortcut: Ctrl+Shift+V
> '
> With Selection
> .Copy
> .PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
> False, Transpose:=False
> End With
> Application.CutCopyMode = False
> End Sub
>
> Please let me know if this helps.
>
> Regards,
> Andy
>
> On Thu, Jul 2, 2009 at 2:34 PM, shivashankar katageri <
> shankarkatag...@gmail.com> wrote:
>
>>
>>  Dear all,
>>
>> Any one can help w.r.t copy from subjects of column cells to row cells,by
>> just dragging or in no time, please
>>
>> for reference see attached file,
>> --
>> Thanks & Regards
>>
>> Shivashankar.C.Katageri.
>>
>>
>>
>>
>
> >
>


-- 
Thanks & Regards

Shivashankar.C.Katageri.

--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---

Reply via email to