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.
You can read more about it here:
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
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos –
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.
You can find a lot of useful Excel resources on the following site:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Very useful I was searching for it thanks 👍
Thank you so much. This is what I've been looking for.
Great tips, but where is usable ??? Plz give proper example.
Thank you very much, this is very helpfull. Simple but very powerfull.
well explained!
So helpful – thank you!
Top quality video, excellent stuff my friend!
amazing tool to work upon
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!
Really good one…
subscribed your channel
Bravo!
Amazing 😍
Great work but we may do this by using paste picture link as well.
Really a very good video.
Paste as linked picture option is easier 🙂
Great Tips!!!!!. Is it possible to create a linked image but paste it in Powerpoint?
Wow. Its good for excel invoices that are pending of payment.
Can it be pasted in email to customers
Thls is a great tip. Thank you.
Good enlightening message. God bless you. Thank you
I see that changing values updates linked images but what if you change formatting, or column size, etc.
Thank you very much for this very useful video and for this simple, clear and wonderful method.
Paste as Linked Images is an awesome feature…
That's an amazing feature. How long has that been in excel?
Subtitles cover the video
Hi Sumit, thanks for this, very useful!!!