WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

The Camera in WPS Spreadsheet

Uploaded time: November 16, 2021 Difficulty Beginner

The Camera in WPS Spreadsheet

The Camera in WPS Spreadsheet

Today we will get to know the Camera in WPS Spreadsheet. With this feature, we can convert the table into a picture, and the contents of the picture will change as those of the table.

Here are two sheets: Itinerary and Tour Route Planning Table. To make it convenient for comparison, we would like to place them side by side. Most people may choose to copy the data of the Tour Route Planning Table sheet and paste it into the Itinerary sheet.

However, this is not a perfect way. First, we can not move the copied data freely or make it cover other data.  Second, we need to copy and paste again if some data in the Tour Route Planning Table has changed.

At this time, the Camera can help a lot.

Come to the Tour Route Planning Table sheet, select the cell range of B5:E14, click the Insert tab and click Camera. Then go back to the Itinerary sheet, and press and drag the mouse to get a Camera Picture, which shows the data we selected before.

We can move the picture freely.

Unlike the Screenshot, the Camera can refresh its data in line with its original sheet.

Now we return to the original sheet to supplement the rest of the information on time , fill the cell with 11.11 in yellow, and insert a plane shape in the Transport column.Then we can also find the information on the picture has changed.

Did you get it?

WPS Office is a one-stop tool with high compatibility and cross-platform for Windows PC and MacAndroid, and IOS Mobile.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.