Maybe you can change the formulas to strings, copy|paste special and change the
strings back to formulas.
I do this:
Select the range to copy
edit|replace
what: = (equal sign)
with: $$$$$=
replace all
Do the copy and paste special|transpose.
Then change the $$$$$= back to = in both the copied range and pasted range.
> Hello!
> How to copy a row with transposing to a column retaining links to input
> cells? Excel transposes with a links change or only values.
> Best regards,
> Dima
> +7 9163876746

Signature
Dave Peterson
Dmitry - 19 Jul 2006 10:09 GMT
> Maybe you can change the formulas to strings, copy|paste special and change the
> strings back to formulas.
[quoted text clipped - 17 lines]
> > Dima
> > +7 9163876746