Forum Discussion

flageollefamilymission's avatar
flageollefamilymission
Copper Contributor
Feb 11, 2022

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 worksheet? (I have multiple tables on 1 sheet) I also want the tables to remain "live", not just show a "snapshot in time" of a table.

2 Replies

  • flageollefamilymission 

    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_Weiss's avatar
    Martin_Weiss
    Bronze Contributor

    Hi flageollefamilymission 

     

    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.

     

     

     

Resources