04 Feb

The Camera Tool in Excel is a very useful, yet hidden, feature. Basically, you specify a rectangular area in your workbook and  the camera tool creates a mirror image of that area as a drawing object. You can move it or resize it. And whenever the contents of original rectangular area changes (charts, drawings or cell values) the mirror image changes too. 

Take a look at the video to learn more.

* The email will not be published on the website.