Did You Know That Microsoft Excel Has a Hidden Camera?

Excel makes it easy to take screenshots. But what if there was a way to take a snapshot of something in a spreadsheet, paste it anywhere in the workbook, and automatically update the snapshot later by changing the underlying data? Excel Hidden Camera can create related images like this.

There are various methods for inserting and displaying images, from using INDEX MATCH to XLOOKUP, depending on the data you’re using, but the Camera tool in Excel is a simple method that doesn’t require any formulas. It’s a simple button on the Quick Access Toolbar, and it’s incredibly useful, but it’s not enabled by default.

Note. This is not the same as Excel’s Screenshot tool, which can be found on the Insert tab in the Illustrations section. The Screenshot tool can take screenshots, but it can’t create linked images like the Camera tool.

How to enable camera in Microsoft Excel?

The Camera tool in Excel is a hidden feature, so you’ll have to fiddle around to add it to the Quick Access Toolbar. To do this, launch Excel and follow these steps:

1. Go to the Home screen ( Backstage view) in Excel from the file in the menu bar.

2. Select Options at the bottom of the left sidebar. In Excel Options, open Quick Access Toolbar settings from the list on the left.

3. Select the Select Commands From drop-down list and select All Commands .

4. Under All Commands, scroll down the alphabetical list and select Camera .

1. Click the Add button between the two fields to include the Camera tool in your Quick Access Toolbar.

2. Navigate to an open spreadsheet and you’ll see a Camera button on the Quick Access toolbar.

Additionally, you can customize your Quick Access Toolbar by clicking on the small downward-facing “Customize Quick Access Toolbar” arrow. Select “More Commands…” from the menu and follow the same steps listed above.

How to Use the Microsoft Excel Camera

Now that the camera is part of your Excel toolbox, you can use it to quickly take dynamic screenshots of your data. Here’s a basic example of how it works:

Open the table with the data you want to collect and paste it somewhere else. Select a data range or chart and click the Camera button on the Quick Access Toolbar.

Open the sheet where you will be pasting the data and select the location where you want to paste. The cursor will change to a tiny crosshair. Drag and release the crosshair to paste data.

When you insert an image, you can use any of the formatting options available on the Image tab of the Ribbon to customize the appearance of the data.

The cool thing about the Camera tool is that it’s not just a screenshot feature, but a way to link two sheets. Here’s how to use it to save time and improve the quality of your spreadsheets.

How to Use the Camera Button in Excel for Linked Photos

The camera button makes working with data in spreadsheets much easier. Try this with a range of data cells or a chart in a spreadsheet; The Camera button allows you to copy this data and paste it as a linked image into the same spreadsheet, another sheet in the same workbook, or a completely different workbook.

Once you’ve inserted the image in a new location, try changing something about the original data or chart. Snapshots pasted in other locations will also update instantly.

Here are some possible use cases:

• Collect data from different sheets and insert it as a dynamic snapshot into a common sheet for presentation or printing.

• Create dynamic dashboards that display information in real time as related data updates.

• Create microcharts by taking a related snapshot of a small section of a larger chart and providing only specific information.

• Manage large data sets spread across multiple sheets and workbooks by tracking important cells with cell snapshots.

• You can use the camera to insert data into Word and PowerPoint documents, but they won’t be linked. But it can help you create presentations and reports faster.

More…