Excel Tutorials · Lesson 118
The Camera tool takes a picture of any range and pastes it somewhere else as a live linked image, one that keeps updating as the source data changes. It has existed in Excel for decades and is hidden by default, which is the only reason most people have never used it. This lesson covers adding it to the ribbon, taking your first snapshot, and where it earns its place in a dashboard.
The same free Excel Xpert companion workbook used in the video, one tab per lesson. No login, no email required.
The Camera tool takes a snapshot of a selected range and turns it into a picture object that can be placed anywhere, on another part of the same sheet, on a different sheet entirely, or floating over a dashboard layout. What makes it different from a screenshot is that the picture stays linked to the original range. Change a number in the source data and the picture updates itself the next time the sheet recalculates, exactly like a formula reference would.
Under the hood it behaves like a giant version of a simple linked-cell formula such as =A1, except instead of one cell it captures an entire range, formatting, colors, borders, conditional formatting, charts and all, and displays the whole thing as one image. That image can be resized, moved, layered over other content, and placed independently of the row and column grid it came from, none of which a normal cell reference can do.
The tool has been part of Excel since the 1990s, sitting quietly in the Customize Ribbon or Quick Access Toolbar options rather than on the ribbon itself. It has no keyboard shortcut and no menu entry unless you add one, which is almost certainly why it remains one of Excel's least-known features despite being genuinely useful.
The classic use case is a dashboard. A detailed table lives on a working tab, formatted however is easiest to maintain there, and a Camera snapshot of the key range sits on a summary tab arranged next to snapshots from several other tabs, none of it requiring a single formula to assemble.
Step-by-step, matching the video above.
Right-click anywhere on the ribbon and choose Customize the Ribbon, or go to File > Options > Customize Ribbon.
In the left dropdown labeled Choose commands from, select All Commands. The Camera tool does not appear in the default Popular Commands list.
Scroll down to Camera, which sits alphabetically. Click it once to select it before adding it anywhere.
Select a tab on the right side, such as a custom group under Home, click Add to move Camera into it, then click OK. Adding it to the Quick Access Toolbar instead keeps it visible no matter which ribbon tab is active.
Highlight the exact cells you want captured, including any headers, totals or formatting you want to appear in the picture.
The cursor changes to a crosshair. This step only arms the tool, it does not paste anything yet.
A single click, not a drag, drops a live linked picture of your selection at that spot. Resize it by dragging a corner handle, exactly as you would resize any picture.
| Source Range (Data tab) | Camera Destination (Dashboard tab) |
|---|---|
| A1:D6, monthly sales table with totals | Live picture, top-left of dashboard |
| F1:F6, small chart of quarterly trend | Live picture, top-right of dashboard |
| A9:D9, KPI row with conditional formatting | Live picture, bottom strip of dashboard |
Three snapshots taken from three different locations on a working tab, arranged freely on a single dashboard tab with no formulas involved. Update any number back on the Data tab and every picture that includes it redraws automatically, including the conditional formatting colors and the chart line.
The Camera captures more than plain values.
Fill colors, borders, number formats and any conditional formatting rules applied to the range all appear in the picture and continue to update live as the underlying values change and rules re-evaluate.
If a chart sits inside the selected range, the snapshot includes it, and the chart continues to redraw inside the picture as its source data changes, the same as it would on the original sheet.
The picture preserves the exact layout of the source range, including merged cells and column widths, which means the fastest way to change how the snapshot looks is to reformat the original range rather than the picture.
The picture is not interactive. You cannot click into it to edit a cell, sort it, or filter it, because it is an image, not a live grid. Any interaction has to happen back on the source range.
Four practices that keep a dashboard built this way clean and maintainable.
Do the actual calculating, filtering and formatting on a tab nobody sees, then snapshot only the finished ranges onto the presentation tab. This separates messy working formulas from a clean final layout.
Using named ranges for anything you plan to snapshot makes it far easier to find and re-link a picture later if the source range ever moves.
Hold Alt while dragging a picture to snap its edges to the underlying cell grid, which keeps a dashboard of several snapshots looking tidy and evenly spaced.
Click the picture, then edit the reference shown in the formula bar, which for a Camera picture displays something like =Data!$A$1:$D$6. Typing a new range there re-points the snapshot without deleting and redoing it.
Three tools that overlap, each suited to a different situation.
When you want an entire formatted table, chart, or colored region to appear elsewhere exactly as it looks in the source, with no interactivity required, Camera is the fastest way to get it there.
Paste Special > Paste Link creates a plain cell formula pointing at another cell, which stays interactive and editable but carries only the value, not the formatting or any embedded chart.
If the destination needs to calculate with the linked value rather than just display it, a normal formula reference like =Data!A1 is the right tool, since a Camera picture cannot feed into further math.
The deciding question is whether the destination needs to look like the source, needs to calculate with the source, or just needs one value from it. Camera answers the first, a formula answers the second and third.
| Formula Bar Contents | What It Means |
|---|---|
| =Data!$A$1:$D$6 | Snapshot of the original range |
| =Data!$A$1:$D$10 | Edited to include four more rows |
| ='Q2 Data'!$A$1:$D$6 | Edited to point at an entirely different sheet |
Click a Camera picture once and its source range appears in the formula bar exactly like a normal formula. Typing a new range or sheet name there instantly repoints the picture, which is far faster than deleting the snapshot and retaking it from scratch.
Four limitations worth knowing before building around it.
A Camera snapshot cannot be clicked into, sorted, or filtered. Anyone who needs to interact with the data has to be sent to the source range, not the picture.
Camera pictures generally print fine, but complex layered dashboards with many overlapping snapshots occasionally render oddly in a PDF export. Test a full print preview before distributing anything built this way.
Anyone opening your workbook without the Camera button already added to their own ribbon can view existing snapshots fine, but cannot create new ones until they add the button themselves.
Sheets does not offer a Camera tool. The closest substitute is inserting a chart or image and linking specific cells, or using Insert > Linked object from Google Docs to pull in a range, which is less flexible for arbitrary formatted blocks.
After clicking the Camera button, a single click drops the picture at that spot. Dragging can distort the initial size, leaving an oddly stretched picture that then has to be manually corrected.
Camera does not appear in the default Popular Commands list when customizing the ribbon. It has to be found under All Commands or it will look like the tool does not exist.
Trying to click into a Camera snapshot to sort, filter, or edit a value does nothing, because it is an image. Any interaction has to happen on the original source range.
If rows get inserted or deleted in the source range without adjusting the snapshot's reference in the formula bar, the picture keeps pointing at the old cells and quietly stops matching the data.
The picture displays a value, it does not provide one. Anything that needs to calculate off a linked figure should use a normal formula reference instead.
There is no Camera tool in Google Sheets. Workbooks built around it will need an alternative approach, such as linked charts or images, if they are ever moved to Sheets.
A summary shouldn’t need a screenshot pasted in fresh every week.
Free 14-day trial. No credit card required.
It takes a snapshot of a selected range and pastes it elsewhere as a live linked picture, which updates automatically whenever the source data changes.
It is hidden by default and not on any ribbon tab. Add it through File > Options > Customize Ribbon, switching the command list to All Commands to find it.
Right-click the ribbon, choose Customize the Ribbon, switch Choose commands from to All Commands, select Camera, and add it to a custom group or the Quick Access Toolbar.
Select the range you want to capture, click the Camera button, then click once where you want the picture placed. A single click drops it, dragging can distort the size.
Yes. It stays linked to the source range and redraws whenever the underlying data, formatting, or conditional formatting changes, the same as a formula reference would.
No. It is an image, not an interactive grid. Any editing, sorting or filtering has to happen on the original source range, not the picture.
Yes. Fill colors, borders, conditional formatting and any embedded charts inside the selected range all appear in the picture and continue updating live.
Click the picture once and its source range appears in the formula bar just like a formula. Typing a new range or sheet name there re-points the snapshot instantly.
Camera captures an entire formatted range as one linked picture. Paste Special > Paste Link creates a plain interactive cell formula pointing at a single value, with no formatting or chart included.
No. It displays a value but does not provide one to other cells. Use a normal cell reference, such as =Data!A1, if the destination needs to calculate with the linked value.
Yes, it is the classic use case. Detailed working tables live on one tab and get snapshotted onto a clean summary or dashboard tab with no formulas required to assemble the layout.
No, there is no direct equivalent. The closest alternatives are linked charts, inserted images, or Insert > Linked object when pulling a range into a connected Google Doc.
The picture was likely placed by dragging rather than a single click, which distorts its initial proportions. Delete it and retake the snapshot with a single click instead.
They can view any existing snapshots without any setup, but creating new ones requires the Camera button to be added to their own ribbon first, since it is not there by default.
Every business starts with a spreadsheet. Updoot is where you scale past it, with live views that never need a fresh screenshot.
Start Your Free Trial →