Camera Tool Function In Excel 2010

With Excel 2010 Camera tool, you will be able to take a snapshot of datasheet portion. This enables you to place a live picture anywhere in the worksheet, you can apply different styles, colors, and designs over it. Since it is live image so it syncs with the datasheet range on run time.

Launch Excel 2010, In order to use this feature, you need to make Camera button appear on the Excel Quick Access Toolbar, because it is not present by default. Head over to Quick Access Toolbar and from small drop down button, click More Commands.

You will reach Excel Options dialog box. Hit drop-down button from right pane present beneath Choose commands. Click All Commands to show all commands which Excel contains. Now scroll-down the list and find Camera command. Select it and click Add (>>) to show it on Quick Access toolbar pane. Once added, hit OK.

You will Camera button on the quick access toolbar.

Now for using this feature, select the portion of the datasheet for which you want to take a snapshot of, and click Camera button.

Now you are ready to take a snap, just click on the location where you want to show the image.

Now when you will select this image Picture Tools tab will appear, from where you can apply different styles and designs.

So apply design and styles which best suites your datasheet image. You can apply shadowing, 3d effects, rotation, colors etc.

Most importantly, it is not a mere image of the table, but it syncs with the table values on run-time, means on changing any value in the datasheet, reflection can be seen in the image. As you can see on changing value and color of the cell, changes appear in the image.

You may also like our previously reviewed guides on Using Payment Function & HLOOKUP Function.