No Transpose Option – Excel 2010

IT Support Forum Forums Windows Windows 7 Applications No Transpose Option – Excel 2010

This topic contains 0 replies, has 1 voice, and was last updated by  Webmaster 1 year, 9 months ago.

  • Author
    Posts
  • #1063

    Webmaster
    Keymaster

    On Excel 2010 the transpose option can sometimes be missing. To fix this, if you have no transpose option after you cut the cells (either row or column), try copying the row or column instead of using cut.

    For some reason, there doesn’t seem to be any transpose option when you cut and try to paste in Excel 2010. In their wisdom, Microsoft seems to have decided that you should only be able to paste transpose from a copy, not a cut operation.

    I suppose you could also find that there’s no transpose option if you are not selecting a row / column and trying to select multiple cells instead.

    If you find another reason that causes you to have no transpose option, please share it below to help the next guy.

You must be logged in to reply to this topic.