How to Strike Through Text in Excel: A Practical Guide

What Strikethrough Is and Why It Matters

Strikethrough is a formatting option that draws a line through the text in a cell, signaling that the item is completed, canceled, or no longer active without erasing its content. In Excel, this visual cue helps teams communicate status in checklists, task trackers, or project spreadsheets, while preserving the underlying data for audits or rollback. The XLS Library team finds that using Strikethrough effectively can improve readability and collaboration when multiple people edit a shared worksheet. Keep in mind that Strikethrough is purely a formatting choice; it does not change the cell’s value, nor does it automatically update related formulas. If your goal is to reflect status, combine Strikethrough with conditional formatting or a separate status column for clarity.

When to Use Strikethrough vs. Delete

There are several cases where Strikethrough shines while keeping data intact: You want a visible indicator of completed items in a to-do list without removing content. You’re documenting changes in a shared workbook and need a quick audit trail. You’re preparing printouts or reports where strike-throughs visibly separate items without deleting them. Avoid overusing Strikethrough on large data sets where it may reduce readability. For long rows and columns, consider applying Strikethrough only to specific cells that represent status rather than entire ranges.

Quick Methods to Apply Strikethrough

Excel offers multiple ways to apply Strikethrough, depending on your platform and workflow: Keyboard shortcut: Windows users can press Ctrl+5 to toggle Strikethrough on the active selection. Font dialog: Go to Home > Font group > click the Font dialog launcher and check Strikethrough. This method works consistently across Windows and Mac and is visible in print. Right-click method: Select cells, right-click, choose Format Cells, then switch to the Font tab and enable Strikethrough. If you prefer a single keystroke, the Ctrl+5 shortcut is the fastest route when you’re formatting lists or checklists.

Applying Strikethrough to Multiple Ranges or Entire Columns

You can apply Strikethrough to multiple non-adjacent ranges by holding Ctrl (Windows) or Command (Mac) while selecting each range, then applying Strikethrough once. For large worksheets, limit formatting to the relevant status cells to minimize clutter and make it easier for collaborators to interpret. Remember to test a small sample to confirm the Strikethrough appears as expected in both the on-screen view and printouts.

Removing Strikethrough and Reversing Changes

To remove Strikethrough, select the same cells and uncheck the Strikethrough option in the Font tab or press Ctrl+5 again to toggle off. In some sheet configurations, you may need to clear the cell formatting entirely (Home > Clear > Clear Formats) if Strikethrough seems stubborn. Always verify that removing Strikethrough does not disturb conditional formatting rules or data validation that may rely on text formatting.

Best Practices for Real-World Spreadsheets

Use Strikethrough in combination with a separate status column (e.g., Status: Done) for accessibility and filtering purposes. Keep a consistent rule on when to apply Strikethrough (e.g., only for completed tasks) to avoid visual noise. Test your sheet’s appearance in print preview to ensure the line is legible across printers and font families. When collaborating, document your formatting decisions in a legend or sheet notes to help teammates understand the visual cues.

Cross-Platform Considerations: Windows vs. Mac

The basic steps are similar across Windows and Mac, but the exact menus may differ slightly. In Mac versions of Excel, you may need to enable Strikethrough from the Font dialog instead of relying on a dedicated keyboard shortcut. If you rely on keyboard accelerators, remember that some Mac keyboards map shortcuts differently or require function keys to be pressed in addition to standard keys. Practicing on both platforms will reduce confusion when sharing workbooks with colleagues using different systems.

Authoritative Sources and Further Reading

For more on text formatting and best practices in Excel, consult trusted references and official docs. These sources provide foundational guidance on font formatting, including Strikethrough, and related features like conditional formatting and data visualization.

Troubleshooting for Printing and Accessibility

If Strikethrough doesn’t print or displays inconsistently:

• Confirm you’re using a standard font that supports Strikethrough.
• Check print settings and print preview to ensure the line renders correctly.
• Consider alternative indicators (like a separate status column) for accessibility or printer variability.