The Camera Tool in Excel

The Camera tool takes a live picture of a cell range and places it as a linked image you can move, resize, and position anywhere. Unlike a copied screenshot, the picture updates whenever the source cells change. For dashboards it lets you pull several scattered ranges onto one clean summary sheet without rebuilding them.

What the Camera tool does and when to use it

The Camera tool creates a picture that stays linked to the range it captured. Change a number in the source range and the picture refreshes to match. The image can be resized freely without disturbing the underlying cells, since it floats above the grid.

Use it to assemble a one-page dashboard from blocks that live on different sheets, to show a small table at a custom size next to a chart, or to display the same range twice at different scales. It is the cleanest way to put a live snapshot somewhere its native column widths would not fit.

Step by step

The Camera command is not on the ribbon by default, so add it to the Quick Access Toolbar first.

1. Go to File > Options > Quick Access Toolbar.
2. In Choose commands from, pick All Commands, find Camera, click Add, then OK.
3. Select the range you want to capture, for example B2:E10.
4. Click the Camera icon on the Quick Access Toolbar.
5. Click on the target sheet where you want the linked picture to appear.
6. Drag to reposition or resize the picture; the link to the source stays intact.

The live link is the whole point: edit the source range and the picture follows.

A model use case

Build a summary tab that shows a KPI block from the model sheet, a small assumptions table from the inputs sheet, and a ratios grid from a third sheet. Capture each with the Camera tool and arrange the linked pictures on the summary page. When the model recalculates, every snapshot updates.

This keeps the source ranges in their natural homes with their own column widths, while the dashboard stays tidy and consistent. You report from one page without duplicating formulas.

• One summary page can mirror live ranges from many sheets.
• Source ranges keep their own column widths and formatting.
• Resizing the picture never disturbs the underlying cells.

Pitfalls and limits

Linked pictures carry a recalculation cost, so a dashboard packed with Camera images can feel sluggish on large workbooks. If the source range is deleted or its sheet is removed, the picture breaks and shows a reference error.

Because the image is tied to live data, it is not what you want when you need a frozen snapshot to paste into an email or slide. For that, a static image is safer, since it will not change later or leak future edits. The Camera tool is for live internal dashboards, not for sending a fixed picture outside the file.