Using Camera tool in Excel 2010

Every come across a situation when you make a nice looking dashboard with lot of effort to impress your client/boss/any stake holder who can change things in your career and then you get a comment to shift the data table in the dashboard to somewhere else.Grrrrrrr.....very irritating huh .. after-all if some macro is populating your table you have to change code also !.

But then MS has made life easier with its camera tool.

What is camera  doing in my tools?

• Camera clicks a snap of the selected area on the excel spreadsheet and lets you place the image anywhere in the Excel Workbook.
• Now this snap is of those particular cells and hence any activity in these cells will be reflected in the picture taken by camera tool

Very useful in

• Making table positioning flexible in Excel Workbook
• To make charts uneditable by converting them into pictures

How do I add camera tool?

For Excel 2010 users

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Using Camera tool:

1. Selected particular range in the excel worksheet and click on camera tool

      2.   Click on any cell in the worksheet and the picture representing selected range is displayed

Found this useful?..So go ahead and make some fantastic tables in Excel