How to Use WPS Text Box on Windows

Use WPS Text Box with 3 how-to topics, including inserting a text box, formatting a text box, and making a text box move with cells; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Insert a Text Box

Entry: Insert tab → Text Box

1. Open the WPS Spreadsheet file that you want to edit.
2. Click Text Box on the Insert tab.
3. Select Horizontal Text Box or Vertical Text Box.
4. Drag on the worksheet to draw the text box area.
5. Type the text that you want to display.

Success Criteria

• Interface result: An editable text box appears in the worksheet.
• Next action available: You can continue typing, moving, or resizing the text box.

Tips While Using

• Common mistake: If you only click once without dragging, the text box may be too small.
• Environment note: A text box is an independent object and does not automatically become cell content.

2. Format a Text Box

Entry: Select the text box → Drawing Tools tab → Format Shape

1. Click the text box in the worksheet to select it.
2. Open the Drawing Tools tab.
3. Click Format Shape to open the task pane on the right.
4. Adjust options such as Fill & Line, Effects, and Size & Properties as needed.
5. Set the border, fill color, or no-outline style based on your layout needs.

Success Criteria

• Interface result: The text box style updates based on your settings.
• Next action available: You can continue moving the text box or editing the text.

Tips While Using

• Common mistake: If the text box is not selected first, the object formatting options may not appear.
• Environment note: Different style settings can affect print and page display results, so it is helpful to preview the layout afterward.

3. Make a Text Box Move with Cells

Entry: Right-click the text box → Format Object → Properties

1. Right-click the border of the text box that you want to set.
2. Select Format Object or the corresponding formatting entry.
3. Open the Properties settings.
4. Select Move and size with cells.
5. Adjust row height, column width, or the related cell area to confirm that the text box changes with the cells.

Success Criteria

• Interface result: The text box changes position or size when the related cells are adjusted.
• Next action available: You can continue maintaining worksheet layout with fewer note alignment issues.

Tips While Using

• Common mistake: If you right-click the text content instead of the text box border, the object properties menu may not appear.
• Environment note: This setting is especially useful for templates and worksheets that need long-term maintenance.