How to Use WPS Borders on macOS

Use WPS Borders through 4 how-to topics, including adding preset borders, customizing border styles, drawing borders, and clearing borders; use the How-to Index to jump to the task you need.

How-to Index

How-to Guide

1. Add Cell Borders

Entry: Home tab → All Borders drop-down

1. Select the cell or cell range where you want to add borders.
2. Click the All Borders drop-down on the Home tab.
3. Select a preset border style, such as All Borders or Outside Borders.
4. Check whether the selected range now shows the chosen border style.

Success Criteria

• The selected range displays the border style you chose.
• You can continue editing, formatting, or saving the file.

Tips While Using

• Select the target cells before opening the border menu so the style is applied to the correct range directly.

2. Customize Border Styles

Entry: Home tab → All Borders drop-down → More Borders

1. Select the cell or cell range that needs border changes.
2. Open the All Borders drop-down menu.
3. Select More Borders.
4. In the border settings window, choose the line style, color, and border position.
5. Click OK to apply the settings.

Success Criteria

• The cell border appears with the selected style.
• The color, line type, or border position has been updated.

Tips While Using

• Membership: Some custom border functions may require WPS Premium.
• Before applying changes, confirm whether you need outside borders, inside borders, or only specific sides.

3. Draw Borders

Entry: Home tab → All Borders drop-down → Draw Border

1. Open the border drop-down menu on the Home tab.
2. Click Draw Border.
3. When the pointer changes to drawing mode, drag across the spreadsheet to add border lines.
4. Press Esc when finished to exit drawing mode.

Success Criteria

• New border lines appear where you dragged.
• After exiting the mode, you can continue selecting cells and editing content.

Tips While Using

• Membership: Draw Border is a membership-related feature.
• Confirm the target area before drawing to avoid repeated lines.

4. Clear Cell Borders

Entry: Home tab → All Borders drop-down

1. Select the cell or range where you want to remove borders.
2. Click the All Borders drop-down menu.
3. Select No Border.
4. Check whether the existing borders have been removed.

Success Criteria

• The selected range no longer shows the previous borders.
• Cell content remains unchanged.

Tips While Using

• If you still need visual guides for printing, distinguish between actual borders and worksheet gridlines.