Choose Your Language
How to use Camera Tool in MS Excel | HARTRON EXAM

How to use Camera Tool in MS Excel

How to use Camera Tool in MS Excel
How to use Camera Tool in MS Excel

Friends, you must be using the camera in your mobile / laptop, but today we are going to tell you about the existing camera in MS Excel, friends when we are doing some work in Excel and there is more than one sheet. So we have to go to that sheet again and again to get the data of other sheet which is very complex and we have to face a lot of difficulties in collecting the final data in one place and printing it.

With the camera tool in Excel, you can see the data in other sheets in MS Excel without having to go to that sheet. Excel’s camera tool is an important tool for preparing dashboards and reports. You can see the data in picture form by staying on the same sheet, selecting data from different data range from different sheets and bringing it to the same sheet. And this picture is connected to the original sheet with the help of the camera tool. And changing the data of the original sheet also changes the data of the picture, so in this way you can see the data / summary of any other sheets on the same sheet and by double clicking on that picture, you can go to the original work sheet so that You do not have to find out from which sheet this picture is taken.

How To Use Camera Tool in Excel

To use these features of MS Excel, you need to add the camera tool on the Quick Access Toolbar.

Step 1: How to Add Camera Tool.

First you have to open MS excel and then click on Quick Access Toolbar.

 How to Add Camera Tool
How to Add Camera Tool

Then you click on More Commands.

2-How to Add Camera Tool
2-How to Add Camera Tool

Then select All Commands from there.

3-How to Add Camera Tool
3-How to Add Camera Tool

Choose Camera Option and click on Add, then click OK.

4-How to Add Camera Tool
4-How to Add Camera Tool

In this way, you will see that Camera Tool Active has been activated even in your Excel winter.

5-How to Add Camera Tool
5-How to Add Camera Tool

Step 2: How to use Camera Tool.

Select the range of data you want to print or view on other sheets with the help of Camera Tool and click on Camera Button Tool.

6-How to Add Camera Tool
6-How to Add Camera Tool

Now paste any sheet that you want to view or print with the help of a mouse, in this way you will see a data picture of the sheet that you can move, rotate and print.

7-How to Add Camera Tool
7-How to Add Camera Tool

Similarly, you can print or view the data of any sheet on the same sheet and when you change the original data, the picture data will also change.

8-How to Add Camera Tool
8-How to Add Camera Tool

With the help of this process, you can collect data of many worksheets on a single page and print it is very useful.

Leave a Reply

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