Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I transpose and paste a link in excel
When I transpose the paste link button greys out. Can I transpose and paste
the link somehow |
#2
|
|||
|
|||
Hi JJJ,
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 |
#3
|
|||
|
|||
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. JJJ wrote: When I transpose the paste link button greys out. Can I transpose and paste the link somehow -- Dave Peterson |
#4
|
|||
|
|||
Hi Dave,
coooool. arno |
#5
|
|||
|
|||
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 "JJJ" wrote in message ... When I transpose the paste link button greys out. Can I transpose and paste the link somehow |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to link from column to row? | Excel Worksheet Functions | |||
How do I transpose an Excel 2003 column of data? | New Users to Excel | |||
Trying to transpose linked data using Paste Special | Excel Worksheet Functions | |||
Paste Special | Excel Discussion (Misc queries) | |||
TRANSPOSE() | Excel Worksheet Functions |