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. > > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
