ExcelBanter - change cells contents from vertical to horizontal

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - change cells contents from vertical to horizontal (https://www.excelbanter.com/excel-discussion-misc-queries/248884-change-cells-contents-vertical-horizontal.html)

GailH

change cells contents from vertical to horizontal

I need to copy from one workseet the values in cells that are arranged
vertically into another worksheet and the values need to be arranged
horizontally. Can this be done? If so, how?

Jacob Skaria

change cells contents from vertical to horizontal

Select the data to be copiedCopySelect target cellRight
clickPasteSpecialselect 'TransposeOK

If this post helps click Yes
---------------
Jacob Skaria

"GailH" wrote:

I need to copy from one workseet the values in cells that are arranged
vertically into another worksheet and the values need to be arranged
horizontally. Can this be done? If so, how?

GailH

change cells contents from vertical to horizontal

Perfect-thank you-you just saved me a ton of time.

"Jacob Skaria" wrote:

Select the data to be copiedCopySelect target cellRight
clickPasteSpecialselect 'TransposeOK

If this post helps click Yes
---------------
Jacob Skaria

"GailH" wrote:

I need to copy from one workseet the values in cells that are arranged
vertically into another worksheet and the values need to be arranged
horizontally. Can this be done? If so, how?

All times are GMT +1. The time now is 11:13 AM.