The Excel CAMERA Feature

Once you know about it, have it in view in your toolbox and focus! your efforts, you will develop ways to use it!

This link explains the feature and how to find it.

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_winother/how-to-use-camera-function-in-microsoft-excel/44a97349-f694-4bd3-a5ca-e4097f6e9437

Here is the nifty feature. It is no just a picture. a picture is static. This is a DYNAMIC linked picture. As the range linked to the picture changes, so does the picture; both the content and the size of the picture. What a way to widen your field of view!

So how can this be used?

Suppose that you have a summary sheet with a bunch of small dissimilar summary tables. You want to have 3 or 4 tables, but the columns just don't match up nicely. Well just as you might with several chart objects, you can also use several camera pictures place wherever you want and each linked to the source table on another sheet.

Suppose you have a sheet with a multi row heading area of summary values and the columns of the data area below it, again does not match the data in the complex heading area. You can use the Camera feature for either the heading are or the data area, or both.

It's really a, er uh, SNAP to use! ;-)