Forum Discussion
excel paste link - keep source formatting
That is helpful. Odd that it works if I only capture a part of the table.
In fact, what I have discovered is that if you create the link with any random range, you can then re-define the linked range to the desired range within the formula window. I use that trick alot to put variable comments into graphs. I am not sure of the behavior if the table range changes, but as long as the table size is static, it seems to work, even if rows or columns are temporarily hidden.
Thank you for this great trick!
You can make it expandable by giving the table a defined name in the Name box, then after you copy part of the table as a linked picture, you replace the picture range with that name.
But you need to exclude the test well header from the defined name.
See the attached file.