Transposing Cells which contains formula
 

If we want to transpose a range of cells in a row which contains "sum"
formula, the values in the row change after transpose. One olution is to use
"paste link". However the "paste link" is disabled when the transpose
checkbox is checked.
Is there any way out to retain the cell values the same while transposing
the range of cells?
Thank you.

Transposing Cells which contains formula
 

If you really want to transpose the values--not the formulas:

Select the range to copy
you can edit|copy
followed by edit|paste special, check values and transpose

if you really wanted to keep the formulas, you can do this:

Select the range to copy
edit|replace
what: = (equal sign)
with: $$$$$
replace all

now the formulas are just plain old strings

Edit|copy the range
edit|paste special|transpose

Select both ranges (or do it twice)
edit|replace
what: $$$$$
with: =
replace all

And the strings are reconverted to formulas.



Hemant wrote:

If we want to transpose a range of cells in a row which contains "sum"
formula, the values in the row change after transpose. One olution is to use
"paste link". However the "paste link" is disabled when the transpose
checkbox is checked.
Is there any way out to retain the cell values the same while transposing
the range of cells?
Thank you.

--

Dave Peterson

Transposing Cells which contains formula
 

"Dave Peterson" wrote:

If you really want to transpose the values--not the formulas:

Select the range to copy
you can edit|copy
followed by edit|paste special, check values and transpose

if you really wanted to keep the formulas, you can do this:

Select the range to copy
edit|replace
what: = (equal sign)
with: $$$$$
replace all

now the formulas are just plain old strings

Edit|copy the range
edit|paste special|transpose

Select both ranges (or do it twice)
edit|replace
what: $$$$$
with: =
replace all

And the strings are reconverted to formulas.



Hemant wrote:

If we want to transpose a range of cells in a row which contains "sum"
formula, the values in the row change after transpose. One olution is to use
"paste link". However the "paste link" is disabled when the transpose
checkbox is checked.
Is there any way out to retain the cell values the same while transposing
the range of cells?
Thank you.

--

Dave Peterson

Thanks for your suggestions . It really help ... I owe you a cup of tea ....
Hemant