Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Excel see columns as rows and rows as columns | Excel Discussion (Misc queries) | |||
how do i paste rows/columns avoiding hidden rows/columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) |