How can I CUT and paste to convert columns to rows?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Copy > Paste Special Transpose into a new range > delete the original range.
 
So I cannot direcctly cut and paste...I can only copy and paste then delete
the original range?
 
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.)
 
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
 
Thanks all. The info was a big help.

Gord Dibben said:
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
Click to expand...
 
You must log in or register to reply here.

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

Excel Unable to insert cut rows into Excel online anymore? 0
Prevent Cut and Paste 3
My cut and paste to my web site, converts to text and not visual 3
Cut & Paste Conditional Formatting 1
Copy/Paste Doesn't Carry Formats 2
Cut & Paste in Excel without erasing cell borders? 1
Cut last row and paste elsewhere 1
Is there a one button shortcut for "copy cell above & paste here" 4

Back
Top