How to insert and set pictures in WPS Spreadsheet

Uploaded time: October 9, 2021 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download

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.


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.