How to insert and set pictures in WPS Spreadsheet

Uploaded time: October 9, 2021 Difficulty: Primary

How to insert and set pictures in WPS Spreadsheet

How to insert and set pictures in WPS Spreadsheet

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

Graphic skills

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.


01.gif


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


At this point, the picture is embedded to a cell. When we resize the cell, the size of the picture changes.07.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.