What is the camera function of excel? I can't find a suitable answer.

The method of using this camera is as follows:

1. Prepare the "Camera"

1) Open the "Tools" menu of Excel and select the "Customize" dialog box.

2) Click the "Command" tab, select "Tools" in "Category", find "Photography" in the "Command" list on the right, and drag it to any part of the Excel page toolbar Location. Many people are not familiar with this step, so you must try it yourself. (Open the "Toolbar" in Excel 2007, find "Camera" in "Commands not in the Ribbon", and click "Add" to use it.)

2. "Take a photo" of the target< /p>

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 "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 It is also effective for this photo, and the photo can be rotated, zoomed, and dragged freely.

4. Cancel the photo pasting function

If you have finished taking pictures and want to cancel the photo pasting function, just click the "Camera" button on the toolbar again with the mouse. The photos under " will be canceled and will not be pasted again.