Use WPS Underline with 4 how-to topics, including adding underline from the ribbon and choosing underline styles; select a topic from the index and follow the entry path and steps.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Add underline from the ribbon button | Free |
| 2 | 2. Choose an underline style | Free |
| 3 | 3. Add underline from the Format Cells dialog | Free |
| 4 | 4. Add underline from the right-click cell format menu | Free |
How-to Guide
1. Add underline from the ribbon button
Entry path: Home tab → Underline button
- Open the spreadsheet and select the target cell, or select part of the text inside the cell.
- Click the Home tab.
- Click the Underline button.
- Check whether the selected content now shows an underline.
Success Criteria
- Visual result: the selected content shows an underline.
- Next action available: you can keep typing, save the file, or adjust other font styles.
Tips While Using
- Common mistake: if no cell or text is selected first, the command may not affect the intended content.
- Environment note: if the sheet is read-only, you need editing permission first.
2. Choose an underline style
Entry path: Home tab → drop-down arrow next to Underline
- Select the cell or text that you want to format.
- Click the drop-down arrow next to the Underline button on the Home tab.
- Select the underline style you want, such as single underline or double underline.
- Confirm that the selected style has been applied.
Success Criteria
- Visual result: the text shows the selected underline style.
- Next action available: you can continue changing font size, color, or other formatting.
Tips While Using
- Common mistake: clicking the main button applies the default underline style, so use the drop-down arrow when you need a different style.
3. Add underline from the Format Cells dialog
Entry path: Home tab → font settings arrow → Underline drop-down menu
- Select the target cell or text.
- Click the font settings arrow on the Home tab.
- Find the Underline drop-down menu in the dialog box.
- Choose the style you want and click OK.
Success Criteria
- Visual result: the target content shows an underline after you return to the sheet.
- Next action available: you can continue adjusting other font settings in the same dialog.
Tips While Using
- Common mistake: if you close the dialog without clicking OK, the setting will not be applied.
4. Add underline from the right-click cell format menu
Entry path: Right-click menu → Format Cells → Font tab → Underline drop-down menu
- Select the target cell and right-click it.
- Select Format Cells.
- Open the Font tab.
- Choose an underline style from the Underline drop-down menu and click OK.
Success Criteria
- Visual result: the text in the target cell shows the underline effect.
- Next action available: you can continue adjusting other cell-formatting options.
Tips While Using
- Common mistake: if you right-click outside the intended cell, the formatting may be applied to the wrong area.