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