How can I CUT and paste to convert columns to rows? in Excel Worksheet Functions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Lillylutoo 6/13/2006 12:18 PM PST   Question   In converting columns to rows, I am able to COPY and paste but cannot CUT and paste. Am I doing something wrong or is it not possible to do this? Thank you.     Was this post helpful to you?         Reply |   Top           CarlosAntenna 6/13/2006 1:03 PM PST   Answer   Copy > Paste Special Transpose into a new range > delete the original range. -- Carlos "Lillylutoo" <Lillylutoo@discussions.microsoft.com> wrote in message news:36B924E1-07C1-4635-845A-D5085E73E74E@microsoft.com... > In converting columns to rows, I am able to COPY and paste but cannot CUT and > paste. Am I doing something wrong or is it not possible to do this? > Thank you.     Was this post helpful to you?         Reply |   Top           Lillylutoo 6/13/2006 1:19 PM PST   So I cannot direcctly cut and paste...I can only copy and paste then delete the original range? "CarlosAntenna" wrote: > Copy > Paste Special Transpose into a new range > delete the original range. > > -- > Carlos > > "Lillylutoo" <Lillylutoo@discussions.microsoft.com> wrote in message > news:36B924E1-07C1-4635-845A-D5085E73E74E@microsoft.com... > > In converting columns to rows, I am able to COPY and paste but cannot CUT > and > > paste. Am I doing something wrong or is it not possible to do this? > > Thank you. > > >     Was this post helpful to you?         Reply |   Top           Kevin Vaughn 6/13/2006 1:21 PM PST   Answer   This is not a definitive answer to your question, but in my experience, there are certain things that cannot be done after a CUT that can be done after a COPY. They seem to be the things that you do with Paste Special so I assume that it is not possible to do what you ask. (other than workarounds like what was already suggested.) -- Kevin Vaughn "Lillylutoo" wrote: > In converting columns to rows, I am able to COPY and paste but cannot CUT and > paste. Am I doing something wrong or is it not possible to do this? > Thank you.     Was this post helpful to you?         Reply |   Top           Gord Dibben 6/13/2006 2:51 PM PST   Answer   Paste Special is one thing you cannot do with Cut cells, so you will not be able to access the Transpose radio button. Gord Dibben MS Excel MVP On Tue, 13 Jun 2006 12:19:01 -0700, Lillylutoo <Lillylutoo@discussions.microsoft.com> wrote: >In converting columns to rows, I am able to COPY and paste but cannot CUT and >paste. Am I doing something wrong or is it not possible to do this? >Thank you.     Was this post helpful to you?         Reply |   Top           Lillylutoo 6/15/2006 12:20 PM PST   Thanks all. The info was a big help. "Gord Dibben" wrote: > Paste Special is one thing you cannot do with Cut cells, so you will not be able > to access the Transpose radio button. > > > Gord Dibben MS Excel MVP > > On Tue, 13 Jun 2006 12:19:01 -0700, Lillylutoo > <Lillylutoo@discussions.microsoft.com> wrote: > > >In converting columns to rows, I am able to COPY and paste but cannot CUT and > >paste. Am I doing something wrong or is it not possible to do this? > >Thank you. > >     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies