Introduction
Microsoft Excel is a powerful spreadsheet application that offers a wide range of features for data analysis and manipulation. One of the most basic yet useful features is the ability to cross out text, which can be helpful for highlighting errors, indicating deleted text, or simply adding emphasis.
How to Cross Out Text in Excel
Crossing out text in Excel is incredibly easy:
1. Select the text you want to cross out.
2. Click the “Font” group on the Home tab.
3. Find the “Strikethrough” button (a letter “S” with a line through it) and click it.
The selected text will now be crossed out.
Using Strikethrough for Different Purposes
- Highlighting errors: Cross out incorrect data to flag it as invalid or needing revision.
- Indicating deleted text: Strikethrough deleted text to make it clear that it has been removed, while still retaining it as part of the document.
- Adding emphasis: Strikethrough can add emphasis to specific words or phrases, similar to using bold or italic.
Additional Options
- Keyboard shortcut: Press “Ctrl + 5” (Windows) or “Command + Shift + X” (Mac) to quickly apply strikethrough.
- Conditional formatting: Use conditional formatting to automatically cross out text that meets certain criteria, such as负值或空单元格。
Cross Out Text in VBA
You can also cross out text using VBA:
Sub CrossOutText()
Dim rng As Range
Set rng = Selection
rng.Font.Strikethrough = True
End Sub
Combining Strikethrough with Other Formatting
Strikethrough can be combined with other formatting options, such as bold, italic, and color, to create various effects:
- Bold and strikethrough: Bold and strikethrough a mistake to highlight it as a serious error.
- Italic and strikethrough: Italic and strikethrough a note to indicate that it is still valid but is no longer relevant.
- Color and strikethrough: Color and strikethrough text to distinguish it from the rest of the document.
Limitations
While strikethrough is a useful feature, it does have some limitations:
- Printing: Strikethrough text may not print as expected, especially on non-Excel printers.
- Accessibility: Screen readers may not interpret strikethrough text correctly, making it less accessible for visually impaired users.
FAQ
How do I quickly cross out text in Excel?
Use the “Strikethrough” button on the Home tab or press “Ctrl + 5” (Windows) or “Command + Shift + X” (Mac).
What is the VBA code to cross out text?
Use the following VBA code:
Sub CrossOutText()
Dim rng As Range
Set rng = Selection
rng.Font.Strikethrough = True
End Sub
Can I combine strikethrough with other formatting options?
Yes, you can combine strikethrough with bold, italic, color, and other formatting options.
Does strikethrough printing work on all printers?
No, strikethrough may not print as expected on non-Excel printers.
Is strikethrough accessible for visually impaired users?
Screen readers may not interpret strikethrough text correctly, making it less accessible.