WPS Sheets Border Function Usage Guide

Feature Summary

The border function is used to add line borders to cells, making the spreadsheet more visually appealing.

Feature Description

Operation Steps

Adding Cell Borders

Feature Entry
"Home" tab → "All Borders" dropdown menu

1. Select the cell or cell range where you want to add borders
2. Click the "All Borders" dropdown menu in the Home tab
3. Choose a preset border style (All Borders, Outside Borders, and so on.)
4. The selected borders will be added to the cells

Customizing Border Styles

Feature Entry
"Home" tab → "All Borders" dropdown menu → "More Borders" option

1. Select the cell or cell range where you want to add borders
2. Click the Home tab and select the "All Borders" dropdown menu
3. Select the "More Borders" option
4. In the border dialog, set:

• Line style (solid, dashed, dotted, and so on.)
• Line color
• Border position (outside border, inside border, diagonal, and so on.)

5. Click OK to apply the settings

Drawing Borders

Feature Entry
"Home" tab → "All Borders" dropdown menu → "Draw Border" button

1. Click the Home tab and select the "All Borders" dropdown button
2. Click the "Draw Border" button
3. The mouse cursor changes to a pencil shape
4. Drag in the spreadsheet to draw border lines
5. Press Esc to exit drawing mode

FAQ

Q1: How to remove cell borders?

• Solution: Select the cells, click the border dropdown button, and choose "No Border" to remove them.

Q2: What should I do if borders do not print?

• Solution: Check if "Print Gridlines" is enabled. In Page Layout, enable "Print Gridlines" or ensure borders are set correctly.