Taking screenshots in Excel is easy. But what if there was a way to take a snapshot of something on a spreadsheet, paste it somewhere in the workbook, and then automatically update the snapshot later to change the underlying data? Excel’s hidden camera can create these kinds of linked images.
Excel HIDDEN Camera Feature
From using INDEX MATCH to XLOOKUP, there are a number of ways to insert and display images depending on the data involved, but Excel’s Camera tool is the straightforward, formula-free way. It’s a simple button on the Quick Access toolbar and incredibly useful, but it’s not enabled by default.
Note: This is not the same as Excel's Screenshot tool, which you'll find on the Insert tab under Illustrations. The Screenshot tool can take screen clips, but it can't create linked images like the Camera tool.
The camera tool in Excel is a hidden feature, so you’ll need to do some digging under the hood to add it to your Quick Access Toolbar. To do this, launch Excel and follow the steps below:
