row to column

M

Mike

I have values on worksheet 1 in cells a16:z16 and would like to copy to worksheet 2 and paste to column A rows A1:A26.

Can this be done
 
A

Alan

Highlight the range, right click Copy, If A1:A26 in Sheet 2 is completly
empty, click A1, right click, Paste Special, check Transpose > OK. If A1:A26
is not empty, either clear the range or Paste Special somewhere else.
Mike said:
I have values on worksheet 1 in cells a16:z16 and would like to copy to
Click to expand...
worksheet 2 and paste to column A rows A1:A26.
 
J

Jason Morin

Check out Edit > Paste > Transpose.

HTH
Jason
Atlanta, GA
-----Original Message-----
I have values on worksheet 1 in cells a16:z16 and would
Click to expand...
like to copy to worksheet 2 and paste to column A rows
A1:A26.
 
K

Ken Wright

Select range A16:Z16, do Edit / Copy, then select A1 and do Edit / Paste Special
/ Transpose
 

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

VBA Coding Help for Beginner 0
Copy addition formula of non-consecutive horizontal cells 2
Need Help with a VBA subroutine 0
Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column 2
Dynamically Create and ID OptionButtons, then insert Row; Loop 2
Merging from an Excel file with graphics 1
xlFillDefault, based on values in ColA to ColZ 5
Split cells next to 1 cell 1

Top