Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"paste special" "paste link"
I want to paste a ROW of cells from one excel file using "past special" and
"paste link" to another excel file but into a COLUMN on the same amount of cells. I can not get it to "rotate" from a ROW of values or formulas to a COLUMN. IS this possible? |
#2
|
|||
|
|||
Look up Transpose in the Help Index
"lssweatt" wrote in message ... : I want to paste a ROW of cells from one excel file using "past special" and : "paste link" to another excel file but into a COLUMN on the same amount of : cells. I can not get it to "rotate" from a ROW of values or formulas to a : COLUMN. IS this possible? |
#3
|
|||
|
|||
As you discovered, paste link and transpose do not go together. You could
do an paste link and then a cut/paste to the final destination. -- Jim "lssweatt" wrote in message ... |I want to paste a ROW of cells from one excel file using "past special" and | "paste link" to another excel file but into a COLUMN on the same amount of | cells. I can not get it to "rotate" from a ROW of values or formulas to a | COLUMN. IS this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Link enters a 0 into the cell where I paste. How do I elemin | Excel Discussion (Misc queries) | |||
paste special (values) | Excel Worksheet Functions | |||
Paste Special values only | Excel Worksheet Functions | |||
Paste Special | Excel Discussion (Misc queries) | |||
Paste Special Question | Excel Discussion (Misc queries) |