How to Use Camera Tool in Excel

The Camera tool in Excel allows you to capture a picture of a selected range of cells and paste it into another location as a live image that updates dynamically when the source data changes.

The usage of a camera in Excel can be something beneficial in the long run, depending on how often you find it useful. This is about learning how to use the camera in the Excel.

Adding Camera Tool

Click on the arrow on upper left of the Microsoft Excel.

ribbon click arrow

Click on more commands.

camera tool more commands

Click on the arrow beneath choose command from (1), and on Commands not in the ribbons (2).

commands not in ribbon

Scroll down the alphabetic order to C, and click on camera (1), then press add (2), and ok.

add camera

How to use the Camera Tool?

Click on the cell that you want to create picture of.

camera tool create picture

Click on the camera on top. You have a picture of the cell ready.

camera tool cell picture ready

In conclusion, unfortunately, you can only use the camera tool to take a picture of a cell, but not a chart. I know this, because I tried.

Keep in mind that the image created by the Camera tool is a linked picture, meaning that it will update automatically when the source data changes.

Further reading: 
Watch window
SmartArt
How to define custom number format?