Formatting Issues

How to Underline Text or Add a Border Around an Excel Cell in WPS Office

Chanuka Geekiyanage Nov 13, 2026 868 views

Question details

The user needs to underline cell text and add a border or outline around a selected Excel cell in WPS Office Spreadsheets.

How to Underline Text or Add a Border Around an Excel Cell in WPS Office

Product: WPS Office Spreadsheets
Device & OS: not provided
Scenario: The user wants to visually emphasize or separate data by formatting a spreadsheet cell.
Observed behavior: The selected cell displays underlined text and a visible border around the cell.

Before you start

Open the workbook in WPS Office Spreadsheets and select the worksheet that contains the cells you want to format. Ensure the Home tab is visible so the Font and Borders commands are easy to reach.

Solution 1Recommended

Format a cell with underline and an outside border

Use this complete Home tab workflow when you need both text emphasis and a visible cell outline quickly.

Select the cell or range

Open your workbook in WPS Office Spreadsheets and click the cell you want to format, or drag to select a range.

Underline the cell text

On the Home tab, go to Font and click Underline, or press Ctrl+U to underline the selected cell content.

Open the Borders menu

With the cell or range still selected, click Home > Borders in the Font group.

Apply an outside border

Choose Outside Borders to outline the selected cell, or choose All Borders to include internal gridlines.

Format a cell with underline and an outside border

Formatting applied: The selected cell text is underlined and the cell border is visible immediately.

Solution 2

Customize underline and border styles in Format Cells

Use this when you need a double underline, a custom border color, or a specific line style.

WPS Office Spreadsheets formatting

Underline and Outline Cells Directly in WPS Office

WPS Office Spreadsheets includes the same underline, Borders, and Format Cells commands as Excel, so you can format your worksheet without switching tools or losing file compatibility.

1. Download and open WPS Office: Install WPS Office from the official site, then open WPS Spreadsheets and load your Excel workbook.
2. Select the target cells: Click a cell or drag across a range to select the content you want to underline or outline.
3. Apply underline: On the Home tab, click Font > Underline or press Ctrl+U.
4. Add a border: Click Home > Borders and choose Outside Borders or All Borders.
5. Save the formatted file: Press Ctrl+S to save the workbook; WPS Office preserves the formatting in .xlsx format.

Underline cell text and add outside borders from the familiar Home tabFull compatibility with Microsoft Excel .xlsx files and existing cell formattingFree and lightweight Office suite with a familiar ribbon interfaceAdvanced border and underline controls in the Format Cells dialog

microsoft office alternative - wps office

Frequently Asked Questions

What is the shortcut for underlining a cell in WPS Office Spreadsheets?

Select the cell and press Ctrl+U, or go to Home > Font > Underline.

How do I add a border to multiple cells at once?

Select the entire range, click Home > Borders, and choose Outside Borders for an outline or All Borders for every internal line in the range.

Can I change the border color and line style in WPS Office?

Yes. Press Ctrl+1 to open Format Cells, go to the Border tab, choose a line style and color, and then click the border buttons to apply them.

Will my Excel cell formatting remain when I open the file in Microsoft Excel?

Yes. WPS Office Spreadsheets saves in Excel-compatible formats such as .xlsx, so underline and border formatting is preserved.

Document & File Issues