G
Guest
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
Can this be done
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Alan
worksheet 2 and paste to column A rows A1:A26.Mike said:I have values on worksheet 1 in cells a16:z16 and would like to copy to
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.
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.
worksheet 2 and paste to column A rows A1:A26.Mike said:I have values on worksheet 1 in cells a16:z16 and would like to copy to
J
Jason Morin
Check out Edit > Paste > Transpose.
HTH
Jason
Atlanta, GA
A1:A26.
HTH
Jason
Atlanta, GA
like to copy to worksheet 2 and paste to column A rows-----Original Message-----
I have values on worksheet 1 in cells a16:z16 and would
A1:A26.
K
Ken Wright
Select range A16:Z16, do Edit / Copy, then select A1 and do Edit / Paste Special
/ Transpose
/ Transpose