Forum Discussion
Drag-able Excel Tables
Is there a way to pull a table (including all of its formatting, formulas, etc.) Into something like a text box so that it can be moved around to create a more creative and aesthetically pleasing work...
you could use a linked picture of that table. This picture automatically updates when the original table gets changed.
Just select all cells of the relevant table and copy it with Ctrl-C.
Then right-click in a target cell and choose from the context menu in the Paste Options the "Linked Picture" icon:
When the inserted picture is selected, you can see in the command line the reference to the original table:
Whenever you change a value there, it is also reflected in the linked picture.