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
 
use copy,edit, paste special and tick "transpose"
Regards
Bill K
 
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...
 
You must log in or register to reply here.

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

fill horizontally 1
How to Convert same horizontal row to vertical row in Excel? 3
formating issue 2
Excel copy and paste 1
Doing a VLOOKUP (probably using the INDEX and MATCH function), withboth vertical and horizontal valu 2
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Vertical to horizontal repeat after 16 rows 3

Back
Top