MS Excel Secrets - Camera Tool In Toolbar

In order to use camera tool, you must add the tool to a tool bar in excel menu area.

Here is how you can do that:

1. Go to menu > tools > customize
2. In the dialog go to “Commands” tab and select “tools” in categories.
3. Scroll down in the commands area until you see a little camera tool
4. Now drag and drop this in your tool bar as shown below

Read lots more  MS Excel Secrets

Using camera tool to create a micro-chart in excel.

1. First make a normal chart.
2. Now select the cells surrounding the chart
3. Click on camera tool
4. Now click any where in the worksheet and excel places a snapshot of the range you have selected
5. Resize it until you get the microchart effect.
6. Bingo !
7. Btw, excel adds a border to the camera tool output. You can remove it by using drawing tool bar

MS Excel Secrets - POST's INDEX

Related Posts:
How to Convert PowerPoint to Flash Flipbook