When a dashboard needs to show a compact view of cells stored elsewhere in a workbook, Excel’s Camera command can place that range as a picture that follows changes to its source. It is a linked view of worksheet cells—not a new chart type or a separate copy of the underlying data.
What an Excel linked picture does
A linked picture displays a selected cell range as a graphic on a worksheet or chart. Microsoft explains that changes to the source cells automatically appear in the graphic. This makes the Camera command useful when the source table and the dashboard layout belong in different places in a workbook.
The picture can be formatted like other pictures. For example, Microsoft documents changing its border or making its background transparent. The linked picture still depends on its source range; it does not update data independently.
How to create a linked picture with Camera
Microsoft documents these instructions for Excel for Microsoft 365, Excel 2024, and Excel 2021.
Recommended Free Tools
#1 Best Overall
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
- Add Camera to the Quick Access Toolbar if it is not already there. Click the Quick Access Toolbar arrow, choose More Commands, set Choose commands from to All Commands, select Camera, click Add, then click OK.
- Select the cells. Highlight the range you want the dashboard to display.
- Click Camera. Use the Camera button on the Quick Access Toolbar.
- Place the picture. Click the destination on a worksheet or chart. Excel inserts a picture showing the selected range.
- Format if needed. Right-click the picture to access picture formatting and other operations, such as changing its border or background transparency.
Choose the right Excel picture method
These options serve different purposes: Camera links a worksheet range, Copy as Picture creates a static snapshot, and IMAGE displays an image from a URL in a cell.
| Method | What it shows | Follows worksheet data changes? | Where it appears |
|---|---|---|---|
| Camera / linked range picture | A picture of a selected cell range | Yes; changes to the source range appear in the graphic, according to Microsoft Support | On a worksheet or chart |
| Copy as Picture | A static picture of worksheet cells, a chart, or an object | No; it is a copied picture, not a link to the source range | Pasted into the worksheet |
| IMAGE function | An image retrieved from an HTTPS URL | Not as a link to worksheet cell contents | Inside a cell |
Make a static snapshot with Copy as Picture
To copy worksheet content as an image, use Home → Copy → Copy as Picture, choose the appearance and format in the dialog, and paste. Microsoft recommends As shown on screen and Picture for best quality; the copied image is pasted at 100% of its original size. If you do not want worksheet gridlines in a copied range, turn them off first through View → Show → Gridlines.
Use IMAGE for an image URL, not a cell-range view
Microsoft’s IMAGE function displays an image from an HTTPS URL in a cell. Its syntax is =IMAGE(source, [alt_text], [sizing], [height], [width]). Microsoft says authentication-required or redirected URLs do not render, external-content security settings may block images, and custom dimensions can distort the image’s aspect ratio. Add alternative text for accessibility. IMAGE is documented for Microsoft 365 and Excel 2024 on the desktop and mobile platforms listed by Microsoft; it is not a substitute for a picture linked to worksheet cells.
If the picture does not show the intended information
- Check that you selected the intended cell range before clicking Camera.
- Confirm that you used the Camera command. A picture made with Copy as Picture is static and will not reflect later source-range changes.
- If you cannot find Camera, add it through More Commands → All Commands on the Quick Access Toolbar.
Microsoft’s cited instructions cover Excel for Microsoft 365, Excel 2024, and Excel 2021; they do not establish whether Camera is supported in Excel for the web.
Quick Recap
Rank #4
Sources
- Microsoft Support: Use the Camera tool to take a picture of your workbook data
- Microsoft Support: Copy a picture of cells or a chart
- Microsoft Support: IMAGE function
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
