4

If we select a empty line and we type:

=TRANSPOSE(A1:C27)

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

Is there any way to keep the format too?

9

To preserve the data and the formatting:

  • go to Edit
  • choose Paste special
  • choose Paste transpose (A1:C27)
2
  • 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
    Feb 9 '20 at 20:34
  • 2
    What? this does not keep the destination format Jul 14 '20 at 10:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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