Copy and paste from Vertical to Horizontal

  • Thread starter Thread starter mardskee
  • Start date Start date
M

mardskee

Does anyone know how to copy a vertical column from excel and paste it into
a horizontal row? I have a sheet with column A 1-256 filled in and I want to
copy and paste it into a new sheet using row 1 A-ZZ etc. Can this be done?
 
Copy the cells that you want to transpose.
Go to the location where you want to paste them.
Edit -> Paste Special -> Transpose
 
Barb, it worked

Thanks


Barb Reinhardt said:
Copy the cells that you want to transpose.
Go to the location where you want to paste them.
Edit -> Paste Special -> Transpose
Click to expand...
 
Back
Top