No Transpose Option – Excel 2010

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.