Yes, I know the official way to do this..but it's not working.

I select a column in worksheet 1.
I click cell A1 in worksheet 2.
I select EditPaste Special, click the Transpose checkbox, and select OK.
I receive this message:
"The information cannot be pasted because the Copy area and the paste area
[dontcha just love the inconsistency in capitalization?] are not the same
size and shape. [of course not--i'm transposing!!] Try one of the following:
"* Click a single cell, and then paste. [which is what I did that didn't work]
"* Select a rectangle that's the same size and shape, and then paste."

Since neither of these worked, the next question is, why the @#$#$ not?

TIA,