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

How to insert and set pictures in WPS Spreadsheet

Uploaded time: October 9, 2021 Difficulty Beginner

How to insert and set pictures in WPS Spreadsheet

How to insert and set pictures in WPS Spreadsheet

When using WPS Spreadsheet, we often need to add pictures for a more visual presentation. So how can we insert a picture into the table?

Select the cell where you want to insert a picture, click the Insert tab, and then click Picture. Here we can choose Floating Picture or Embed to Cell.

Floating Picture allows pictures to float above cells, then we can move and resize the picture at will. Embed to Cell is to pin the picture within a cell. We can't move the picture but only control the size of the picture by resizing the cells.

If we want to insert a picture in a table and make the picture float above the table, we can choose Floating Picture. In the popup window, click From File, select the picture we want to insert and click Open. As we can see, the picture is inserted into the table.02.gif

After inserting the picture, we can see that there are eight small dots around the picture, and we can drag the dots at four corners to scale the picture equally. We can also drag the four dots above, below, on the left or on the right to set the length and width of the image according to your actual needs.03.gif

If the picture is too small to see clearly, we can click Picture Preview to see the original scale of the picture, or click Full Screen to view the selected picture.04.gif

The feature Crop can crop the selected area.  There are two ways to crop pictures: Crop by Shape and Crop by Scale.  For example, if we want to crop this picture into an oval, we can click Crop by Shape and choose Oval. The picture is then cropped into an oval shape.05.gif

So how can we embed a picture to a cell?  Click the Insert tab above, and click the Picture drop-down button, then choose  Embed to Cell. In the popup window, click From File, select the picture we want to insert and click Open06.gif

What a practical feature! Did you get it? To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

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