Camera, Lights, Action! Excel Camera Tool

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.