Feature Summary

The image feature is used to insert and edit pictures in a worksheet, supporting local images and online images, with the ability to adjust size, position, and add effects.

Feature Description

Feature Dimension Description
Membership Restriction Some features require a membership
Version Restriction No version restriction

Operation Steps

Insert Local Image

Feature Entry
"Insert" tab → "Picture" button

  1. Click the "Picture" button in the Insert tab
  2. Select Floating Picture or Embed in Cell Picture
  3. Click Local Picture
  4. Browse and select the image file to insert
  5. Click Open to complete the insertion

【EN】WPS Sheets Image Feature User Guide_截图01

Insert Online Image (Membership required)

Feature Entry
"Insert" tab → "Picture" button → "More Pictures" option

  1. Click the "Picture" button in the Insert tab
  2. Select Floating Picture or Embed in Cell Picture
  3. Click the "More Pictures" option
  4. Select an image from the pop-up Daoku gallery
  5. Click Insert

【EN】WPS Sheets Image Feature User Guide_截图02

Edit Image

Feature Entry
"Picture Tools" tab → "Format Shape" arrow

  1. Select the image
  2. In the Picture Tools tab, click the "Format Shape" arrow
  3. Adjust in the task pane that pops up on the right:
  • Fill & Line
  • Effects
  • Size & Properties
  • Picture

【EN】WPS Sheets Image Feature User Guide_截图03

Convert Floating Picture to Embed in Cell Picture

Feature Entry
Right-click image → "Embed Picture in Cell" option

  1. Select the image
  2. Right-click the image and select the "Embed Picture in Cell" option
  3. The image will be embedded into the cell in the upper-left area of the image

【EN】WPS Sheets Image Feature User Guide_截图04

Notes

  • Images can be freely moved and resized
  • Multiple image formats are supported (JPG, PNG, GIF, and so on.)
  • Images can be placed above or below text