Many friends do not know that Excel has a camera function, now small knitting for everyone to explain where Excel camera and Excel camera function use method, quick to see this effective "photography" tool in the end how to use it.
In Ecxel, if you need to sync a page to reflect the changes of another page, we generally use sticky links and other ways to achieve. However, if you need to reflect more content, especially when the format of the target location must be reflected, then the way to connect the data will not work. At this time, Excel camera function can help us a lot of AH ~
The first step is to prepare the camera, as shown in the following steps:
The second step, to the target "photo":
Third step, paste "photo":
Fourth step, cancel the photo-pasting function:
Simple four steps, we can control a few more times Oh ~
Classification: