WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


How can we add and set borders for cells

Uploaded time: August 26, 2021 Difficulty Beginner

How can we add and set borders for cells

How can we add and set borders for cells

When we use WPS Spreadsheet to organize the data form, we may sometimes need to add borders to the cells in the table.

For example, we may use the upper and lower borders to make alphabets, employee information tables, music staff, and so on. Different data forms require different cell borders, so how can we to set the table border style?

Take the employee information table as an example.

1. Select the cell area.

2. Click the Home tab in the upper feature area and then the Other Borders drop-down button in turn. There you can set the cell border. Click All Borders.

3. Then we can add borders to all the selected cells.

If we only want to add the outer border of the selected cell:

1. Click the No Borders button to cancel the border of the table first.

2. Then select cell area.

3. Click the Outside Borders button.Now we have successfully added the outer border of the cell.

We can also add top, bottom, left, and right borders to the selected cell according to the usage scenarios. We can also add double bottom borders, which will add two borders to the bottom of the cell.


1. Click the More Borders button, where you can customize the borders in the pop-up Format Cells dialog box.

2. Select the cell area, right-click and select Set up Cell Format.

3. The shortcut key for this feature is Ctrl+1.

4. Click Border in the cell format dialog box, and then you can set the style, color, preset style, and location of the borderline.

5. Finally, click OK to apply the border settings.

To be office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.