Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose a cut section
Hi,
I have a table with input values that are referenced in other cells. I would like to cut and transpose that and keep those references. The paste special does not work with the cut option though. Does anyone knows how to do that? Thanks. Neda |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose a cut section
I do this.
I select the range Edit|Replace what: = (equal sign) with: $$$$$= replace all then edit|cut edit|paste special|transpose Then select that range and edit|replace what: $$$$$= with: = replace all Try this against a copy to see if meets that "keep the references" portion of your post. neda5 wrote: Hi, I have a table with input values that are referenced in other cells. I would like to cut and transpose that and keep those references. The paste special does not work with the cut option though. Does anyone knows how to do that? Thanks. Neda -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
isolating different aspects of worksheets...as objects? through section breaks? | Excel Worksheet Functions | |||
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
transpose a column into many rows | Excel Discussion (Misc queries) | |||
Transpose into a _working_ transposed array | Excel Discussion (Misc queries) | |||
TRANSPOSE() | Excel Worksheet Functions |