More features in picture inserting

Uploaded time: December 17, 2021 Difficulty: Beginner

More features in picture inserting

More features in picture inserting

More features in picture inserting

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. WPS Spreadsheet and Microsoft Excel both have the function of inserting pictures. Compared with Microsoft Excel, WPS spreadsheet has an added advantage-Embed to cell.

 

In Microsoft Excel, we usually need to manually adjust the size of the pictures after inserting them.

If the position of the table changes, the inserted pictures will not fit in the new cells, requiring us to readjust these pictures, which will be time-consuming if they are excessive.

_1.gif


Faced with this situation, we can use the Embed to Cell function in WPS Spreadsheet, which has three advantages.

 

First,

Click Embed to Cell, the picture will be automatically embedded in the cell. Let's insert some horizontal pictures. Adjust the row height and column width of the cell. Then the picture will be adjusted with the cell without changing the picture's aspect ratio.

 

At this time, the picture does not fill up the cell. We only need to place the mouse in the middle of column E and column F. Double-click, and the picture will automatically fill up the cell. Double-click the picture, and you can check it in a greater size.

_2.gif


Second,

When we want to move the areas containing cells, the inserted pictures will automatically follow the changing area and be adapted according to the size of the cell. At this point, manual adjustment is unnecessary.

_3.gif


Third,

The Embed to Cell function also allows us to filter after inserting pictures. Take this table as an example. If we want to filter out the content containing pictures, uncheck the Blanks in the Filter window. What is left are the cells containing pictures. Click OK.

_4.gif


This is the difference in inserting pictures between WPS Spreadsheet and Microsoft Excel. Did you get it?