Get instant access to this free e-book fully loaded with Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes.
Do you know why excel users are not aware of Excel Camera Tool?
Because it is not listed in any of the tabs of excel ribbon. And, Excel Camera Tool is one of the most ignored tools in excel.
Do you know why you have to learn about Excel Camera Tool?
Using Excel Camera Tool is really helpful for those who want to get best out their spreadsheets. It can be your best friend for creating dashboards.
In this post, I’ll show you some great tips to make your dashboards more awesome.
So, Let’s move ahead to explore this amazing tool.
Like a normal camera, this camera captures the picture of cell range.
In simple words, Excel camera tool help you to copy a range & create a live picture of that range. And, you can paste that range anywhere in your worksheet.
As this is a live picture, If you make any changes to your original range that will reflect in the image as well.
So the basic idea to use this camera is to create a live image of a range & put it into your dashboards.
As I have already mentioned, we don’t have any option of Excel Camera Tool in excel ribbon. We have to enable it first before we use it.
Following are the simple steps to activate it.
Using excel camera tool is as easy as clicking a picture with a camera. Just follow these steps to create a live picture in your excel spreadsheet.
Now you now about how to use camera tool & you can use it in the way you want.
Here I have listed some inspiring examples of using Excel Camera Tool.
I am a huge fan of In-Cell Charts but the most difficult part of these charts is to add them in dashboards. So, I use camera tool to create a live image to add them to the dashboards.
Using excel camera tool really helps me a lot because I can change the size of the chart by using this method.
You can also use it to insert live image of data tables. Sometimes data tables consume lots of space in our dashboard. We can add a live snapshot of data in our dashboards.
You can change the size of the data table according to your need.
I really love this one. Suppose you have some important cells which are related with your dashboard. And all the cells are in different worksheets and you want to monitor them.
The best way to do that, just create live images of all important cells put them in a single worksheet or in your main dashboard sheet.
And, the best part of this, a user can’t make a change in these live images.
You can also use watch window to monitor important cells.
Yes, we have an alternate to Excel Camera Tool. And, that alternate is creating a linked image with paste special.
Please follow these simple steps to create a linked image with paste special option.
So the bottom line is, using Excel Camera Tool is a smart move.
But you can also use Paste Special Option instead of Excel Camera Tool.
I hope this tip will help you to make best out of your excel dashboards.
If you ask me I always prefer to use Excel Camera Tool.
What is your stand on this? Which one you’ll prefer to use?
Do you like excel camera tool or creating a linked image with paste special?
Submit your views in the comment box.
Here are some other amazing tools like excel camera tool to win your spreadsheet war.