Copy and paste from Vertical to Horizontal

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?
 
B

Barb Reinhardt

Copy the cells that you want to transpose.
Go to the location where you want to paste them.
Edit -> Paste Special -> Transpose
 
M

mardskee

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...
 
Top