How to copy a row with transposing to a column retaining links to input cells?

D

Dmitry

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
 
D

Dave Peterson

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.
 
D

Dmitry

Thanks Dave Peterson for your instruction!
Dave Peterson said:
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.
Click to expand...
 
Top