97. Excel Tips - Camera Tool
Excel Tips - Camera Tool (Excel 2007)
- This is an excellent time saving tip to get screen shots from Excel into outlook
- Use Camera Tool
I have the Camera Tool added to my custom toolbar. See this tip for more info on how to customise your toolbar.
Once you have the camera tool on your toolbar:
- Select a range of cells
- Click on the camera tool
- Click away from the range
- Right click on the picture
- Cut
- Select your email
- Paste
Here's what it looks like:
Download sheet to practise how to use the Camera Tool in Excel
Training Video on how to use the Camera Tool in Excel:
| Attachment | Size |
|---|---|
| camera-tool.xls | 545.5 KB |
»
- Nick's blog
- Login or register to post comments
- 19100 reads
Camera Tool
Hi Nick,
Sorry if I'm being slow here but what's the camera 'tool'? I followed your link about to customise the tool bar but this shows the file location.
I downloaded the above xls which shows me a picture of the ExcelExperts.com data but how would I be able to use this for anything else?
Best regards,
Gareth
Camera tool
hi Gareth
If you're confused, then I need to clarify
What use is the spreadsheet ?
that kind of thing.
Hope that helps.
Nick
Camera tool
Hi Gareth and Nick,
from my perspective, the camera tool is very handy when it comes to developing and creating dashboards.
In some cases, e. g. when you are limited by print layout, you can create your chart in a "hidden" sheet of your spreadsheet file, take a "photo" with the camera tool and place it on your dashboard sheet, where you can apply all image adjustments (like resizing etc.) to this photo that you would like to do.
Hope that helps ;-)
Phil
handy
really help full tips thanks