WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


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


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


More features in picture inserting

Uploaded time: December 17, 2021 Difficulty Beginner

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.

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


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.


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.


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.

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

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