Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

In Excel, you are supposed to be able to change the rows to columns and the columns to rows (in effect, rotating the sheet through a diagonal axis), by selecting the area to be transposed, and doing a Copy, Paste Special. But the dialog that opens has the Transpose checkbox greyed out.

I've tried several methods, such as selecting a square area, selecting the upper left-hand cell before the paste, selecting the lower right hand cell before the paste, but they all have the same result.

How do I ungrey the box so I can check it?

share|improve this question

2 Answers 2

To do a transpose, select the area to be transposed and execute a Copy to get it onto the clipboard. A Cut will not work.

Select the Target area, and do a Paste/Special. Click the Values radio button; this will ungrey the Transpose checkbox. Check the Transpose checkbox, and click the OK button. The data will be transposed, and pasted to the newly-selected area.

In order for the Transpose to be successful, all of the following conditions must occur:

  1. The area selected for the target paste must be the right shape and size. For example, if the copied source data is six columns wide and three rows high, you have to select a target area that is three columns wide and six rows high.

  2. The target area must be empty; you can't transpose in place.

Doug Mitkiff has an excellent tutorial for this, along with an Excel file you can download and practice on.

share|improve this answer

Also..You cannot paste special between separate sessions in excel. For example, when I use dual monitors it is often times convenient to have two separate sessions of excel open (one on each monitor). In order to do a paste special you must be within the same session. I will typically paste the entire sheet I'm working from into a new tab and paste special from there.

Hope this helps...

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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