from rows to columns
 

When you have data in a long row and in another tab sheet you want the
same data but in a column and when you copy the values you reference
the cell so like ='tabsheet'!B2 and then you drag that corner of the
cell down so that you can get all the values, you know so the next cell
formula is ='tabsheet'!B3 and so on.

Well what is the easiest way to do that because if the values are in a
column and your copying them to a column that works perfectly but rows
to columns and columns to rows i have to type in manually as thats the
only way i know of doing it because dragging it won't work as the next
cell formula will be ='tabsheet'!C2.

So whats the easiest an quickest way of copying column formulas/values
to rows or vica versa?


--
alymcmorland
------------------------------------------------------------------------
alymcmorland's Profile: http://www.excelforum.com/member.php...o&userid=27652
View this thread: http://www.excelforum.com/showthread...hreadid=483428

from rows to columns
 

One way to do this is copy / paste special / transpose
I hope that helps.

Herbert

"alymcmorland" wrote:


When you have data in a long row and in another tab sheet you want the
same data but in a column and when you copy the values you reference
the cell so like ='tabsheet'!B2 and then you drag that corner of the
cell down so that you can get all the values, you know so the next cell
formula is ='tabsheet'!B3 and so on.

Well what is the easiest way to do that because if the values are in a
column and your copying them to a column that works perfectly but rows
to columns and columns to rows i have to type in manually as thats the
only way i know of doing it because dragging it won't work as the next
cell formula will be ='tabsheet'!C2.

So whats the easiest an quickest way of copying column formulas/values
to rows or vica versa?


--
alymcmorland
------------------------------------------------------------------------
alymcmorland's Profile: http://www.excelforum.com/member.php...o&userid=27652
View this thread: http://www.excelforum.com/showthread...hreadid=483428