transfer a column into a row?
 

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.

transfer a column into a row?
 

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.

transfer a column into a row?
 

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!