Have you ever imaged to take a screen shot on data range in a worksheet then paste it into another worksheet, and the data in the picture will change automatically when the original data change? In fact, you can add the Camera command into Excel’s Quick Access Toolbar to take a screenshot on Excel data range or chart then paste it anywhere as you need quickly.
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
Please do as following steps to add the Camera tool into Excel’s Quick Access Toolbar.
1. Click on the arrow of Customize Quick Access Toolbar in the Excel Toolbar, then select More Commands from the drop down list. See screenshot:
Tip: In Excel 2007, you also can right click at the blank place of the Toolbar, and select Customize Quick Access Toolbar to show the Excel Options dialog.
2. In the popping out Excel Options dialog, select Commands Not in the Ribbon from the Choose commands from list, then scroll down to find Camera command. See screenshot:
3. Then click Add button to add the Camera command to right command list. See screenshot:
4. Click OK to close the dialog. Now you can see the Camera tool in the Excel Quick Access Toolbar.
If you want to take a screenshot on a data range, you can do as follow:
1. Select a data range you want, for instance, I select A1:B6. See screenshot:
2. Click Camera tool in the Quick Access Toolbar. See screenshot:
3. Click the location you want to place the screenshot at, then the picture will appear. See screenshot:
Tip: The data in the picture will change automatically with the original data changing.