The little-known "camera" function in Excel

In Excel, the little-known "camera" function exists in Excel, but almost 80% of Excel users do not know this very effective "photography" tool, not to mention. I have been in contact with Excel for many years, but I just recently got in touch with this camera because of my work needs. Now I want to write down how to use it, first, I am afraid that I will forget it for a long time-a good memory is worse than a bad pen (Oh, now I should say: a good memory is worse than a bad keyboard !); Second, it may be needed by others and can be used as a reference. In Excel, If You Need To synchronously reflect changes to another page on a page, we generally use the paste connection method. However, if you need to reflect a lot of content, especially when the format of the target location must also be reflected, then using the connection data method will not work. Fortunately, Excel has prepared a "camera" for us. You just need to "photograph" the part of content you want to reflect, then paste the "photo" on another page. Note: The inserted image file is automatically updated at the same time. The data and format are updated at the same time. You can also use the "image" toolbar to edit the photo. In addition to Excel, this image can also be pasted in word, PPT, or a drawing tool in the Windows attachment. Of course, it can also be edited in software such as Photoshop. The camera is used as follows: 1. Prepare a camera. 1) Open the "Tools" menu in Excel and select the "Custom" dialog box. 2) Click the "commands" tab, select "Tools" in "category", and find "photography" in the "commands" list on the right ", drag it to any position on the toolbar of the Excel page. Many people are not familiar with this step. You must give it a try on your own. (Open "toolbar" in Excel 2007, find "camera" in "commands not in the functional area", and click "add" to use it .) Www.2cto.com 2. "Take a photo" for the target. Suppose we want to make part of Sheet2 automatically appear in sheet1. 1) drag the mouse and select the content in sheet2. This step is very important. You must select the right one. If you do not select a picture or choose a wrong one, your "photo" will be a joke. 2) Click the camera button on the toolbar, and the selected area is shot.
3. Paste "photo" 1) Open the sheet 1 worksheet. 2) Click the left mouse button at the position where the "photo" is to be displayed, and the "photo" is immediately pasted. In Sheet2, adjust the various formats of "Photos" and paste the content in Sheet1 to change synchronously. Because the inserted content is indeed an automatically updated image file, the "image" toolbar is also valid for this photo. The photo can also be rotated, scaled, or dragged freely. Www.2cto.com 4. Cancel the photo and paste function. If you want to cancel the photo and paste function, just click "camera" on the toolbar again, the photo just taken is canceled and will not be pasted. Of course, the above is only the most basic step, and there are still many problems that need to be solved in practice, such as taking photos of data charts. This article is from Wenqi's ladder