Where is the excel2007 camera?

Many people who want to convert excel2007 tables into pictures use screenshots, but screenshots inevitably have defects. In fact, excel2007 has its own camera function. Let me show you how to set up the excel2007 camera.

Excel2007 camera setting steps:

1. Open the Excel Tools menu and select Customize Dialog Box.

2. Click the Command tab, select Tools in the category, find Photography in the command 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 the toolbar in Excel 2007, find the camera among the commands that are not in the ribbon, and click Add to use it.)

The little-known camera function in Excel tables

2 , Take a photo 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 photos 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 photos

1. Open the Sheet1 worksheet.

2. Click the left mouse button on the location where the photo needs to be displayed, and the taken photo will be pasted immediately.

Adjust the various formats of the 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 will also apply to this photo. Effectively, photos can also be rotated, zoomed, and dragged freely.

IV. Cancel the photo-paste function

If you have finished taking photos and want to cancel the photo-paste function, just click the camera button on the toolbar again with the mouse and the photo you just took will be displayed. will be canceled and will not be pasted again

Recommended articles related to excel2007 camera:

1. How to add camera function to Excel2007

2. How to display excel2007 The camera function

3. How to use the camera function in excel2007