This guide includes 3 how-to topics: add strikethrough from the ribbon, add strikethrough from the Format Cells dialog, and add strikethrough from the right-click cell format menu; 3 are available without membership and 0 are membership-related.
How-to Index
| No. | Topic | Membership |
|---|---|---|
| 1 | 1. Add strikethrough from the ribbon button | Free |
| 2 | 2. Add strikethrough from the Format Cells dialog | Free |
| 3 | 3. Add strikethrough from the right-click cell format menu | Free |
How-to Guide
1. Add strikethrough from the ribbon button
Entry point: Home tab → Strikethrough button
- Select the cell where you want to add strikethrough, or enter the cell and select part of the text.
- Click the Strikethrough button on the Home tab.
- Check whether the selected text now shows a strikethrough line.
- To remove it, click Strikethrough again.
Success Criteria
- Interface result: A horizontal line appears through the selected text.
- What you can do next: You can continue typing, editing, or saving the spreadsheet.
Tips While Using
- Common mistake: If no cell or text is selected first, strikethrough may not be applied to the target content.
- Environment note: The visible result may differ depending on whether you selected part of the text or the whole cell content.
2. Add strikethrough from the Format Cells dialog
Entry point: Home tab → Font settings arrow → Strikethrough
- Select the cell or the text in the cell that you want to format.
- Click the font settings arrow on the Home tab.
- In the dialog box, find the font-related settings.
- Select the Strikethrough checkbox.
- Click OK to apply the setting.
Success Criteria
- Interface result: The target text displays with strikethrough formatting.
- What you can do next: You can continue adjusting font, size, or other text styles.
Tips While Using
- Common mistake: If you do not click OK, the setting will not be applied.
- Environment note: This method is useful when you want to adjust strikethrough together with other font settings.
3. Add strikethrough from the right-click cell format menu
Entry point: Right-click menu → Format Cells → Font tab → Strikethrough
- Select the target cell.
- Right-click the selection and choose Format Cells.
- Switch to the Font tab.
- Select the Strikethrough checkbox.
- Click OK to apply the setting.
Success Criteria
- Interface result: The text in the target cell shows strikethrough.
- What you can do next: You can continue setting borders, alignment, number formats, or other cell properties.
Tips While Using
- Common mistake: If you right-click outside the target cell, the menu may not open for the intended cell.
- Environment note: This method is suitable for users who prefer right-click formatting workflows.