How to Use WPS Borders on Android

Last updated:July 20, 2026

Use WPS Borders with 3 how-to topics: apply border types, change border line color, and clear existing borders; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Apply border types

Entry: Tools at the bottom > Home tab > Borders area

  1. Select the cell range where you want to apply borders.
  2. Tap Tools at the bottom.
  3. Open the Home tab.
  4. In the Borders area, choose the border type you need.
  5. Apply an outside border, inside border, all borders, or a bold border style as needed.

Success Criteria

  • Interface result: The selected range shows the border style you chose.
  • Next action available: You can continue changing colors, adjust other formatting, or save the file.

Tips While Using

  • Common mistake: If you do not select cells first, the border effect may not be applied as expected.
  • Environment note: You need to work in an editable spreadsheet file.

2. Change border line color

Entry: Tools at the bottom > Home tab > color option below the Borders area

  1. Select the cell range where you want to change the border color.
  2. Tap Tools and open the Home tab.
  3. In the Borders area, choose a border type first.
  4. Tap the color option below the border controls.
  5. Select the border line color you want.

Success Criteria

  • Interface result: The selected range shows the chosen border color.
  • Next action available: You can continue adjusting border types or save the spreadsheet.

Tips While Using

  • Common mistake: If no border type is applied first, changing color may not produce an obvious visible result.
  • Environment note: On some table backgrounds, light border colors may be harder to see.

3. Clear existing borders

Entry: Tools at the bottom > Home tab > Borders area

  1. Select the cell range that already has borders.
  2. Tap Tools at the bottom.
  3. Open the Home tab.
  4. Open the border type list in the Borders area.
  5. Select No Border to remove the current borders.

Success Criteria

  • Interface result: Existing borders are removed from the selected range.
  • Next action available: You can apply a new border style or continue editing the sheet.

Tips While Using

  • Common mistake: If only part of the intended range is selected, only that selected area will be cleared.