I have been exposed to Excel for many years, but I only recently came into contact with this "camera" due to work needs. Now I write down how to use it, firstly because I am afraid that I will forget it as time goes by - a good memory is not as good as a bad pen (oh, now I should say: A good memory is not as good as a bad keyboard!); Second, it may be needed by others and can be used as a reference.
Excel
In Excel, if we need to synchronously reflect changes in another page in one page, we usually use methods such as pasting connections to achieve this. However, if there is a lot of content that needs to be reflected, especially when the formatting of the target location must also be reflected, then using the method of connecting data will not work. Fortunately, there is always a way, and Excel has already prepared a "camera" for us. You only need to "photograph" the part of the content you want to reflect, and then paste the "photo" into other pages. And note: the inserted image file is indeed an image file that is automatically updated simultaneously. The data and format will be updated simultaneously. At the same time, you can use the "Picture" toolbar to edit the photo. And since this is a picture, in addition to Excel, of course it can also be pasted in Word, PPT, or the drawing tool that comes with Windows attachments. Of course, it can also be edited in software such as Photoshop.
Here's how to use this camera:
1. Prepare the “camera”
1) Open the Excel "Tools" menu and select the "Customize" dialog box.
2) Click the "Commands" tab, select "Tools" in "Categories", find "Photography" in the "Commands" list on the right, and drag it to any position on the toolbar of the Excel page. Many people are not familiar with this step, so you must try it yourself. (Open "Toolbar" in Excel 2007, find "Camera" in "Commands not in the Ribbon", and click "Add" to use it.)
2. “Take photos” of the target
Suppose we want some content in Sheet2 to automatically appear in Sheet1.
1) Drag the mouse and select the content in Sheet2 that needs to be "photographed". This step is very important. You must choose it correctly. If you don't choose it or choose it wrongly, your "photo" will be ridiculous.
2) Use the mouse to click the prepared "Camera" button on the toolbar, and the selected area will be "photographed".
3. Paste the “photo”
1) Open the Sheet1 worksheet.
2) Click the left mouse button on the location where the "photo" needs to be displayed, and the "photographed" will be pasted immediately.
Adjust the various formats of "Photo" in Sheet2, and the content pasted into Sheet1 will change simultaneously, and because the inserted image file is indeed an automatically updated image file, the "Picture" toolbar is also effective for this photo. Photos can also be freely rotated, zoomed, and dragged.
4. Cancel the photo and paste function
If you finish taking pictures and want to cancel the photo pasting function, just click the "Camera" button on the toolbar again with the mouse, and the photos you just "taken" will be canceled and will not be pasted again.
Of course, the above are only the most basic steps, and there are still many problems that need to be explored and solved in practice, such as taking pictures of data charts and so on. Some issues can be discussed in an email.
