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.

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.

camera1 Camera Tool Function In Excel 2010

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.

snapshot

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

design

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.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

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