00:00Do you know about this Excel feature where you can copy the table as a picture
00:03and move it to a different location on your spreadsheet?
00:06And this picture is dynamically updated as you make change to your original dataset.
00:10Did I hear someone say how to do it?
00:12Well, this is how to do it.
00:13First, select your dataset, press Ctrl-C to copy on a clipboard,
00:17select any cell, and then press Ctrl-V to paste it.
00:20Under the Paste Option icon here, click on the pulldown,
00:23and then on the section of Other Paste Option, select Linked Picture.
00:27Now, you can reposition the Linked Picture anywhere on your spreadsheet,
00:30and if you make any modification to your main dataset,
00:33the Linked Picture will also get updated as well.
Comments