Is there a way to copy a column of cells and transfer them into a row
of cells?

I get a list of numbers that come to me in a column and I have to
transfer them into a row on another spreadsheet. Right now I'm doing
it manually it would be nice to be able to automate the process
because they all follow the same sequence.

Highlight your range of cells in the column (just the range...not the entire
column). Ctrl+C to copy.
Then right-click on the first cell of the row you want these values in.
Select Paste Special.
Check the box for Transpose.
Click OK.

Note: The cell that you want to paste to cannot be part of the copied
range.

HTH,
Paul

--

"Joe" wrote in message
...
Is there a way to copy a column of cells and transfer them into a row
of cells?

I get a list of numbers that come to me in a column and I have to
transfer them into a row on another spreadsheet. Right now I'm doing
it manually it would be nice to be able to automate the process
because they all follow the same sequence.

On Apr 9, 2:34 pm, "PCLIVE" wrote:
Highlight your range of cells in the column (just the range...not the entire
column). Ctrl+C to copy.
Then right-click on the first cell of the row you want these values in.
Select Paste Special.
Check the box for Transpose.
Click OK.

Note: The cell that you want to paste to cannot be part of the copied
range.

HTH,
Paul

--

"Joe" wrote in message

...

Is there a way to copy a column of cells and transfer them into a row
of cells?

I get a list of numbers that come to me in a column and I have to
transfer them into a row on another spreadsheet. Right now I'm doing
it manually it would be nice to be able to automate the process
because they all follow the same sequence.

thanks!