Excel strikethrough lets you cross out text inside a cell to mark it as completed, outdated, or rejected without deleting content. This visual cue keeps data readable while clearly signaling status changes.
You can apply strikethrough using keyboard shortcuts, the ribbon, or through custom formulas and VBA, making it useful for task tracking, to-do lists, and audit reviews.
| Method | Steps | Use Case | Shortcut |
|---|---|---|---|
| Ribbon | Select cell > Home > Strikethrough icon | Quick visual formatting | N/A |
| Keyboard | Ctrl+5 (Windows) or Command+Shift+X (Mac) | Fast repetitive marking | Ctrl+5 / Command+Shift+X |
| Custom Number Format | Format Cells > Custom > Type: [strike]0 | Auto-strike based on value | N/A |
| VBA | Macro with ActiveCell.Font.Strikethrough = True | Bulk or conditional automation | N/A |
Applying Strikethrough via the Ribbon
The Home ribbon in Excel gives direct access to the Strikethrough tool for manual formatting.
Select the target cell or range, then click the Strikethrough command to toggle a crossed line through the text.
Using Keyboard Shortcuts
Keyboard shortcuts let you apply strikethrough instantly without lifting your hands from the typing position.
On Windows, use Ctrl+5; on Mac, use Command+Shift+X to quickly switch crossed text on or off.
Custom Number Format for Conditional Strikethrough
You can automate strikethrough so cells update based on their values or formulas by using a custom format rule.
Open Format Cells, choose Custom, and enter a code such as [strike]0 so that specific patterns trigger the line automatically.
VBA Automation for Bulk Strikethrough
For large datasets or recurring tasks, VBA scripts can apply or toggle strikethrough across many cells with one run.
A simple macro like ActiveCell.Font.Strikethrough = True can be expanded into loops and conditions for full workflow control.
Key Takeaways for Using Excel Strikethrough Effectively
- Use the Home ribbon or Ctrl+5 / Command+Shift+X for fast manual formatting.
- Leverage custom number formats to create automatic, rule-based strikethrough.
- Apply VBA macros when you need consistent strikethrough across large sheets.
- Remember that strikethrough is visual only and does not alter underlying data.
- Check print settings if you want to control whether crossed-out text appears on paper.
FAQ
Reader questions
Does applying strikethrough in Excel change the cell value or data?
No, strikethrough only changes the visual appearance of text; the underlying cell value remains unchanged.
Can I use conditional formatting to automatically add strikethrough?
Yes, by creating a custom rule with a formula and setting the format to Strikethrough, Excel can automatically cross out cells when conditions are met.
Will strikethrough appear when I print my Excel sheet?
Yes, strikethrough is printed by default unless you modify the page setup or the printer driver settings to hide font effects.
Can I remove strikethrough from multiple cells at once?
Yes, select all affected cells and click the Strikethrough command again or press the shortcut to batch clear the formatting.