📷 Excel CAMERA Tool - Create Linked Images that update automatically

In this video, I will show you the camera tool in Excel, which you can use to create dynamically linked images that update when you change the original data.

Camera tool is not available by default in Excel, so you need to add it first in the Quick Access Toolbar. Once you have added it, you can create a linked image with a single click.

All you need to do is select the range of cells for which you want to create the image and then click on the camera tool icon in the QAT.

You can place the image on the same sheet or in any other sheet of the workbook.

In case you need to take a snapshot of a chart and create a linked picture, you need to select all the cells around it (in such a way that the chart is within the range of cells.

Once done, simply click on the camera tool icon and it will create a linked picture of the chart.

This tool can be really useful when you want to create a dashboard. You can use these images to quickly take a snapshot and create the dashboard.

This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.

It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[mikaylanoble]

Great video! Got right to the point and made it easy!!!

[wayneedmondson]

Hi Sumit.. such a cool tip.. thanks! I've already committed to memory the keystroke sequence to quickly produced a linked picture through the ribbon menu: CTRL+C and then ALT, H, V, I
It even adjusts each linked picture if you change the column width or row height of the source.. amazing! Thanks for sharing this one. Thumbs up!

[MohAboAbdo]

Thank you very much for this very useful video and for this simple, clear and wonderful method.

[raisasontillano]

Thank you so much. This is what I've been looking for.

[preethladybird]

Good enlightening message. God bless you. Thank you

[mombaby]

Very useful I was searching for it thanks 👍

[PabloVipVid]

Thank you very much, this is very helpfull. Simple but very powerfull.

[georgetosounidis]

Hi Sumit, thanks for this, very useful!!!

[bensmallwood]

Top quality video, excellent stuff my friend!

[ManthaarJanyaro]

Paste as Linked Images is an awesome feature...

[hectorleonardovillalobosdu]

Great Is it possible to create a linked image but paste it in Powerpoint?

[RonaldKennedyMD]

I see that changing values updates linked images but what if you change formatting, or column size, etc.

[EshwarN]

Really good one...
subscribed your channel

[staninjapan]

I was told that this tool could be used to create bingo cards using images.
Apparently if I put images next to a certain column of text within a sheet, I can make something like a randomizing tool to make, say, a 3x3 bingo sheet with the same range of images but in different positions.
Does anyone know whether that is true, and how much work is involved?
Thank you.

[haqiredha]

Paste as linked picture option is easier :)

[thakerdevdutt]

Great tips, but where is usable ??? Plz give proper example.

[axia]

Wow. Its good for excel invoices that are pending of payment.
Can it be pasted in email to customers

[mymatemartin]

That's an amazing feature. How long has that been in excel?

[surajthakur]

Great work but we may do this by using paste picture link as well.