Transpose, Paste Special

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm just wanting to transpose when pasting some data (rows become columns,
vise versa). Other posts on the forum have said to go to the Paste Special
option and click on transpose. My Paste Special screen does not show that, I
instead have the option of pasting it in a different file format or as a
link. A different versio of excel maybe?
I'm using Excel 2003 SP2.
How do I paste transposed data in my version?

Thanks,

Jennifer
 
Are you copying data from somewhere else than Excel? If it is from an Excel
file you should always get a long list of options on how to paste
 
Ah, you are right. I was copying from one Excel spreadsheet to another in a
different instance of Excel, so it gave me the paste special menu for data
coming in from another application. If I copy and paste into the same
spreadsheet, I get the window everyone was describing.

Thanks!

Jennifer
 
Back
Top