Transposing

  • Thread starter Thread starter Brian86
  • Start date Start date
B

Brian86

I cant seem to transpose a column from the original worksheet to a new
worksheet without recieving a message that states that the area into which I
would to like to transpose is not the same size and shape. Where am I going
wrong?
 
Make sure you aren't selecting more than 256 rows of data (there's only 256
columns in XL, unless you specify more in XL 2007). Or, if you start your
paste to the right of column A, then you would need to select even fewer
rows. Also, when you go to paste special, don't have an area selected, just
click a single cell.
 
I cannot replicate this - I seem to be able to specify any target area.
Suggest you try by just clicking the one cell where you want the first entry
to be on the target worksheet, then use Paste Special/transpose
best wishes
 
Thanks for your help Luke! Sometimes, as I'm sure you know, you just have to
keep messing with it until the obvious comes to light.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transpose Large Column to Row 2
"Paste Special / Transpose" problem 3
transpose column to a row? 1
Transpose Error 2
Transpose Appears to be Broken 4
find first empty cell in column and start transpose next row in that cell 6
How to transpose data (Row to column) without losing the cell link 3
Transpose Feature Inop 2

Back
Top