1. Home
  2. MS Office

Camera Tool Function In Excel 2010

With Excel 2010 Camera tool, you will be able to take a snapshot of a selected datasheet portion. This enables you to place a live picture anywhere in the worksheet, you can apply different styles, colors, and designs over it. Apart from taking an exact screenshot of the highlighted data set, it also syncs the data with the image; whenever you make changes to the original data set, live image gets updated, showing you the latest cells values. You can easily copy the snapped data set to clipboard and share with others. Moreover, all image related effects can be applied over the data set snapshot. When you select the image, image tools tab appears on the ribbon, allowing you to change the orientation of the image and apply different styles. In this post, we will guide you through the process of enabling Camera feature on the quick access toolbar and applying different effects over the data set snapshot.

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

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 that 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.

camera 1

You will Camera button on the quick access toolbar.

camera button

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

select sheet `

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.

designs applied

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.

snync 1

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

Leave a comment