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

Related

MS Excel 3488356235727713584

Post a Comment

SPAMMING will not be Appreciated.

emo-but-icon

Hot in week

Recent

Comments

Blog Archive

Our Channel

Contact Us

Name

Email *

Message *

Follow by Email

item