Excel Unplugged

Smile for Excel’s Camera

There are many more or less unknown tools in Excel. One of those is definitely the Camera Tool. Imagine the following scenario. You have two sheets in Excel. On one Sheet you have all the data, and on the other, all the calculations or a chart based on that data. Now we wish to be able to see what impact does changing the data have on our calculations or a chart (which are on another Sheet).

One way to do this is to implement a Watch Window which is very rigid and Excel 2003 looking. But there’s another way. Take a photo of the desired area with the camera tool and place that photo anywhere in Excel (another Worksheet or even another Workbook). And now you have a surveillance camera that dynamically shows you what is happening to that area. Here’s how you find it and work with it.

You can’t find the Camera Tool on any of the Ribbons, so you have to add it to your QAT – Quick Access Toolbar. Here’s how.

Camera Tool in Excel

Go to the dropdown at the end of QAT and choose More Commands…

Camera Tool in Excel

In the Excel Options window that appears do the following:

  1. Choose commands from: All Commands
  2. Find the Camera Tool in the List
  3. Click Add>> and press OK

Camera Tool in Excel

Now the Camera Tool should reside in your QAT. Now to use it, you must first select the Range of Cells that you want to keep an eye on and then select the Camera Tool.

Camera Tool in Excel

You will get the famous army of ants walking around the selected area and that means that the Camera Tool will now create a copy of this area wherever you choose. Now you place yourself in the area where you need the picture to be and just draw it out by clicking & dragging. As soon as you draw out the area, the picture appears. And now it’s like having a surveillance monitor where you will dynamically see the changes made to that area live!

Camera Tool in Excel

Great fun and sometimes a very useful tool to know. And once again, we are one step closer to eternal happiness.