How to add and use camera tool in Excel？
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.
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.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!