Forum Discussion
Drag-able Excel Tables
2 Replies
- PeterBartholomew1Silver Contributor
Some of the basic editing techniques work perfectly with Tables. If an entire table is selected, it may be dragged and dropped to its new location on the worksheet. To move a table to another worksheet Ctrl/X will cut the sheet and Ctrl/V will place it within its new sheet. The latter uses the Clipboard to hold the copy of the Table prior to pasting.
- Martin_WeissBronze Contributor
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.