G
Guest
When I transpose the paste link button greys out. Can I transpose and paste
the link somehow
the link somehow
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
arno
Hi JJJ,
No, this why it is greyed out.
You could write a formula with the OFFSET() function, however, this
will not be readable for humans, ie. you'll get a problem when
troubleshouting.
arno
When I transpose the paste link button greys out. Can I transpose and
paste the link somehow
No, this why it is greyed out.
You could write a formula with the OFFSET() function, however, this
will not be readable for humans, ie. you'll get a problem when
troubleshouting.
arno
D
Dave Peterson
You could try this:
Copy|paste special|paste link
(but in an out of the way location)
Then select those cells
edit|replace
what: =
with: $$$$$= (some unique string)
replace all.
Now those formulas are strings
Copy|paste special|transpose
select the range
edit|replace
what: $$$$$= (same string)
with: =
replace all
And clean up that out of the way helper range.
Copy|paste special|paste link
(but in an out of the way location)
Then select those cells
edit|replace
what: =
with: $$$$$= (some unique string)
replace all.
Now those formulas are strings
Copy|paste special|transpose
select the range
edit|replace
what: $$$$$= (same string)
with: =
replace all
And clean up that out of the way helper range.
A
arno
Hi Dave,
coooool.
arno
coooool.
arno
B
Bernie Deitrick
JJJ,
I have written an add-in that adds a "Transpose Paste-Link" option to the
right-click menu. Contact me privately, and I will send it to you. Change
the dot to ., and take out the spaces.
HTH,
Bernie
MS Excel MVP
I have written an add-in that adds a "Transpose Paste-Link" option to the
right-click menu. Contact me privately, and I will send it to you. Change
the dot to ., and take out the spaces.
HTH,
Bernie
MS Excel MVP