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.

Comments 5

  1. JOSE ALBERTO PEREIRA says:

    It is an excellent tool when you need to do Dashboards or Reports. There are several ways to use it such as: graphics, flags, etc. Good tip!

  2. Frank Byl says:

    Love it! Really useful tool

  3. MF says:

    On top of putting the icon on QAT, you may also copy and paste linked picture. I find this is more convenient.

  4. Sandy Paul says:

    Wow, that is very cool and will be very useful. Thanks for sharing!

  5. RAKESH DESAI says:

    Excellent TIP

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.