Excel – Create a floating dynamic image with live data from sheet

Float an “image” of some cells in your sheet and have them update automatically!

  1. Select the cells you want in the dynamic image
  2. copy them as picture (the copy drop-down on the home ribbon)
  3. paste the picture wherever you want it
  4. With the image selected, press F2
  5. Enter an equals sign in the formula bar
  6. and then select the cells where the original data lives. Hit enter.

Your data should now update in the image!

Sauce

Leave a Reply

Your email address will not be published. Required fields are marked *