Is there a way to paste a range of cells as links, but have the links use the locked (I don't know the proper term) address of the target cell). I would have said "absolute" reference but the paste link doc already says it uses absolute references.
For example, if I copy cell A2 from sheet1, and I paste as a link, i get the reference sheet1!A2 in the target cell.
Is there any way to get it to paste sheet1!$A$2? I'd like to be able to recopy and paste the link and have it refer to the original A2 but as it is now, the A2 is adjusted to be relative to where I copy it.
Thanks, first time poster here.
( I searched for paste and link but couldn't wade through the 1700+ results.)
For example, if I copy cell A2 from sheet1, and I paste as a link, i get the reference sheet1!A2 in the target cell.
Is there any way to get it to paste sheet1!$A$2? I'd like to be able to recopy and paste the link and have it refer to the original A2 but as it is now, the A2 is adjusted to be relative to where I copy it.
Thanks, first time poster here.
( I searched for paste and link but couldn't wade through the 1700+ results.)