See all How-To Articles

How to Use the Camera Tool in Excel

This tutorial demonstrates how to use the camera tool in Excel.

 

camera tool final data

 

What is the Camera Tool?

The camera tool is a lesser-known feature in Excel. However, it can be very useful in everyday work. This feature allows you to capture an image of the data set (range, table, chart, etc.). After that, all changes in your source data set is updated in the image taken by the camera. You can use it across sheets in your workbook. This can be of big help when working with:

  • Complex data sets – It can make your life easier, as you can capture a part of data and put the image anywhere in the file in order to track changes faster.
  • Linked images – You can make the picture change as you change certain data in the file.
  • Dashboards – Sometimes it’s very hard to fit everything in a dashboard (charts, scorecards, tables, etc.), and using the camera, you can format all of them as images and easily resize and reposition them on the sheet.

Enable the Camera Tool

The camera tool is not present by default in the Excel Toolbar. To use it, follow these steps to add it to the Quick Access Toolbar:

1. Click on the Customize Quick Access Toolbar icon in the toolbar, and choose More Commands…

 

enable camera tool 1

 

2. In the Excel Options window, choose All Commands from the Choose commands from drop down.

 

enable camera tool 2

 

3. Select Camera in the list, click Add, and OK.

 

enable camera tool 3

 

Now the Camera icon is in the Toolbar.

 

enable camera tool 4

 

Use the Camera Tool

Say you have the following sales data set, and Column F (Total) is the product of Columns D and E (Price and Items Sold).

 

camera tool initial data

 

You can create an image of the data set using the camera. Then, whenever you update the data, the image will also  updated accordingly.

1. Select the range of cells (or table, chart, etc.) you want to capture, and click the Camera icon in the toolbar.

 

camera tool 1

 

2. Now click anywhere in the sheet where you want to insert the captured image.

 

camera tool 2

 

3. As you can see above, the picture of captured data is now inserted (similar to a screenshot). If you change any data in the original data set, for example, cell E2 from 5 to 7, the image is also updated.

 

camera tool final data