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
:noprob:
:smile:
:shy:
:trope:
:sneered:
:happy:
:escort:
:rapt:
:love:
:heart:
:angry:
:hate:
:sad:
:sigh:
:disappointed:
:cry:
:fear:
:surprise:
:unbelieve:
:shit:
:like:
:dislike:
:clap:
:cuff:
:fist:
:ok:
:file:
:link:
:place:
:contact:

Hot in weekRecentComments

Hot in week

Recent

Comments

Our Channel

Contact Us

Name

Email *

Message *

item