Using a Picture to Watch Cell Values in Other Sheets in Excel 2010

 

To use a picture to watch cell values in other sheets, we use the Camera tool in Microsoft Excel 2010.

Camera Tool – Camera tool creates a mirror image of the selected area, and this tool is used to prepare a dynamic report. It is quite useful when you can make changes in dashboards and reports. It automatically updates data from one place to another at the same time.

Camera Tool is not included in the main toolbarsin Microsoft Excel. We have to add it through the Quick Access Toolbar (QAT).

To add the Camera tool follow the below given steps:-

  • Open the Excel workbook.
  • Go to the top of the Excel worksheet.
  • The Customize Access Toolbar’s icon will appear.

img1

  • When you click on the icon, a drop down menu will appear.
  • From the drop down menu, select More Commands.
  • The Excel Options dialog box will appear.
  • Select All Commands from the “Choose commands from” list.

img2

  • Find the Camera Tool from the commands.
  • Click on the Add button, and click on OK.

img3

  • The Camera tool will be displayed at the top of the Excel sheet.

img4

Let’s take an example to understandhow we can use a picture to watch cell values in other sheets.

We have data in the 1st sheet of a workbook.

img5

To prepare a dynamic report, follow the below given steps:-

  • Select the data range C4:G10.
  • Click on the Camera icon at the top of the excel sheet.

img6

  • The Cursor point will get changed to a “+” sign.
  • Click on the 2nd sheet in Excel.
  • The Image will get created.

img7

Note: When you make any changes to the main data,the image will get updated automatically.

DATA

img8

IMAGE

img9

This is how we can use a picture to watch cell values in other sheets in Microsoft Excel.



3 thoughts on “Using a Picture to Watch Cell Values in Other Sheets in Excel 2010

  1. “Hi,

    I have inserted hypelinks into excel sheets using the activesheet.hyperlinks.add and want to define targets for the hypelinks to be able to handle the sessions in instances of these hypelinks destination applications .

    if any one has any idea as to how to do this, please let me know asap.

    thanks in advance
    veena”

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>