Quick answer
The Excel Camera tool is not on any ribbon tab. Add it through File → Options → Quick Access Toolbar, set Choose commands from to All Commands, select Camera and click Add. Then select a range such as B2:E12, click the camera icon, and click where you want it: Excel drops a picture of those cells that redraws itself every time the source changes.
The Camera tool is the most useful Excel feature most people have never seen, and the reason is simple — it has never appeared on the ribbon. It predates the ribbon entirely, survived the 2007 redesign as a command without a home, and still ships in every desktop version of Excel. You have to go and fetch it.
What you get is worth the two minutes. A camera picture is a live image of a range: change a number in the source cells and the picture updates, including colours, borders and conditional formatting. Because it is an ordinary picture object, you can put it anywhere — another part of the sheet, another sheet, on top of a chart — and move, resize or rotate it freely.
Add the Camera tool to the Quick Access Toolbar
The Quick Access Toolbar is the small strip of icons above or below the ribbon. It is the only place the Camera command can live.
- Go to File → Options → Quick Access Toolbar. (Faster: right-click the Quick Access Toolbar itself and choose Customize Quick Access Toolbar.)
- Open the Choose commands from dropdown and pick All Commands. Microsoft also lists it under Commands Not in the Ribbon, which is a shorter list if you prefer.
- Scroll to the letter C and select Camera.
- Click Add, then OK.
On Excel for Mac the same command is reached through Excel → Preferences → Ribbon & Toolbar → Quick Access Toolbar. Excel for the web has no Camera tool at all.
The icon looks like a small camera. Once it is on the toolbar it stays there for every workbook you open on that machine.
Take your first snapshot
Say you have a summary block in B2:E12 on a sheet called Data, and you want it visible on your Dashboard sheet.
- Select
B2:E12. Select cells, not the objects inside them — if you want a chart in the picture, select the cells the chart sits over. - Click the Camera icon. The marching-ants border appears around the selection and the pointer becomes a crosshair.
- Switch to the Dashboard sheet and click once where you want the top-left corner. Excel drops the picture at the source range’s own size.
Instead of a single click you can drag out a rectangle, and the picture is created at whatever size you drew. Either way you can drag the handles afterwards.
The formula bar is the whole trick
Click the picture once and look at the formula bar. It does not show a file path or an image name — it shows a range:
=Data!$B$2:$E$12That reference is the link, and it is editable. Type a different range and the picture immediately shows different cells. This turns a static snapshot into something much more flexible:
- Point it at a defined name. If
SummaryBlockis a name built with OFFSET or INDEX so that it grows with the data, the picture grows too. This is the fix for the most common complaint about the Camera tool — that it ignores rows you add below the original range. - Point it at another workbook’s range by using a full external reference, though a closed source workbook will stop updating.
- Rotate the result. Cells cannot be rotated; pictures can. A camera picture turned 90 degrees is the honest way to get a sideways block of data next to an upright one.
Camera tool or Paste as Linked Picture?
These two get treated as rivals, and they are not. They produce the same kind of object: a picture whose formula bar holds a range reference and which updates live. What differs is how you get there.
| Camera tool | Paste → Linked Picture | |
|---|---|---|
| Where it lives | Quick Access Toolbar only, after you add it | Home → Paste dropdown, under Other Paste Options |
| Workflow | Select, click the icon, click or drag on the sheet | Copy first, then paste |
| Size when created | Source size on a click, any size if you drag | Always source size |
| What you end up with | A picture object with a range formula, updating live | |
What it is genuinely good for
Dashboards built from scattered sheets. Four camera pictures pointed at four different sheets give you one screen that always agrees with the underlying data, without a single formula linking them.
Printing ranges that are nowhere near each other. Excel will only print one rectangle per sheet. Camera pictures of three separate blocks, arranged on a blank sheet, print as one tidy page.
Watching a distant range. Keep a picture of your assumptions block visible while you work three hundred rows further down. It is the poor relation of the Watch Window, but it shows formatting and layout rather than bare values.
Cleaner reporting sheets. The same instinct behind hiding working values in a column applies here: keep the calculation sheet honest and ugly, and let a camera picture present it.
Where it goes wrong
It gets fuzzy when you scale it. A camera picture is rendered at the source range’s size. Shrink it a long way and text softens; enlarge it and edges blur. Adjust the source column widths and font sizes instead of resizing the picture, and keep it near 100% for anything that will be printed.
It does not expand on its own. Add rows 13 and 14 under a picture pointed at $B$2:$E$12 and they will not appear. Point the picture at a dynamic defined name, as above, or edit the reference.
Too many cameras slow a workbook down. Every picture redraws on recalculation. A handful is free; fifty on one sheet is noticeable.
The link does not survive leaving Excel. Paste a camera picture into Word or PowerPoint and you get a flat image, frozen at the moment you copied it.
They accumulate quietly. Camera pictures are picture objects, so a sheet that has been through a few redesigns can be carrying images nobody can see. If you need to clear them out, the methods for deleting all pictures or charts on a worksheet apply to camera pictures exactly as they do to any other image.
Frequently asked questions
Where is the Camera tool in Excel?
It is on no ribbon tab in any version. Add it yourself through File, Options, Quick Access Toolbar, then set Choose commands from to All Commands, scroll to Camera, click Add and then OK. It then lives on the Quick Access Toolbar for every workbook on that machine.
Is the Camera tool the same as Paste as Linked Picture?
They are different commands that produce the same object: a picture holding a range reference that updates live. Paste Linked Picture needs you to copy first and always pastes at source size. The Camera tool lets you click or drag the picture out at any size, but you have to add it to the Quick Access Toolbar before you can use it.
Does an Excel camera picture update automatically?
Yes. It redraws whenever the source cells change, and it carries formatting with it, including fill colours, borders and conditional formatting. The one thing it will not do is grow when you add rows outside the range it points at.
Can I point a camera picture at a named range?
Yes, and this is the most useful thing you can do with it. Click the picture, then replace the reference in the formula bar with a defined name, for example =SummaryBlock. If that name is built with OFFSET or INDEX so it resizes with the data, the picture resizes too.
Why does my camera picture look blurry?
Because it was rendered at the source range size and then scaled. Instead of dragging the picture smaller, change the source: narrow the columns, reduce the font size, then let the picture redraw at its natural size. Keep it close to 100% for anything you intend to print.
Sources
- Customize the Quick Access Toolbar — Microsoft Support. Accessed September 17, 2026.
- Create a picture from cells, a chart, or an object in Excel — Microsoft Support. Accessed September 17, 2026.
- Using the Excel camera tool — Journal of Accountancy. Accessed September 17, 2026.
- Microsoft Excel Camera Tool — My Online Training Hub. Accessed September 17, 2026.
