Feature Summary

The text box feature is used to add independent text areas in a worksheet. They can be freely placed at any position and support formatting such as borders and fills.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Operation Steps

Insert Text Box

Feature Entry
"Insert" tab → "Text Box" button

  1. Click the "Text Box" button in the Insert tab
  2. Select "Horizontal Text Box" or "Vertical Text Box"
  3. Drag the mouse on the worksheet to draw the text box
  4. Enter text content

【EN】WPS Sheets Text Box Feature Usage Guide_截图01

Format Text Box

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

  1. Select the text box
  2. Click the Drawing Tools tab
  3. Click the "Format Shape" arrow
  4. Adjust in the task pane that pops up on the right:
  • Fill & Line
  • Effects
  • Size & Properties

【EN】WPS Sheets Text Box Feature Usage Guide_截图02

FAQ

Q1: How to make the text box move with cells?

  • Solution: Right-click the text box → Format Object → Properties, select "Move and size with cells".

Notes

  • Text boxes are graphic objects independent of cells
  • Text boxes can be set to have no border and no fill
  • Text boxes can be placed anywhere on the worksheet