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 to customize draw borders for tables

Uploaded time: August 27, 2021 Difficulty Beginner

How to customize draw borders for tables

How to customize draw borders for tables

When using WPS Spreadsheet to create tables, we may want some of the cells in the table to have borders and some without borders.

To do this, we can use the Draw Borderfunctions to customize the drawing of cell borders, which could be also used in Microsoft Office Excel and Openoffice.

Take this table as an example.

1. Click the Home tab.

2. Click the Draw Border drop-down button.

3. Select the Draw Border option in the drop-down menu. The mouse cursor will turn into a brush style.

4. Now we click the border of the cell to draw borders for the cell. 

We can also set the Line Color and Line Style. Select SlateGray Accent4 in Line Color, and select a thick line in Line Style. Then select the cell to be drawn. Now we can draw the Outside Borders of the selected cell area.

If we want to draw all the borders of the cell, click on the Draw Border Grid, and then select the needed cell area to complete the drawing of all the cell borders.

If we want to cancel the borders we drew, click Erase Border and select the cellsto clear borders.

Did you get it?

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