If we select a empty line and we type:


We will invert everything from A1 to C27. However, formatting will be lost.

Is there any way to keep the format too?

1 Answer 1


To preserve the data and the formatting:

  • go to Edit
  • choose Paste special
  • choose Paste transpose (A1:C27)
  • Oww! This actually works. But it is a bit cryptic. Just a - select the cells you want; b - copy; c - go to where you want to paste; d - select 'paste: transpose';
    – commonpike
    Commented Feb 9, 2020 at 20:34
  • 2
    What? this does not keep the destination format Commented Jul 14, 2020 at 10:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.