strikethrough in excel

February 22, 2026

Essential Guide to Using Strikethrough Formatting in Excel (A Complete Guide)

Excels split-second formatting tools often transform how we present and analyze data—and one of the most visually impactful features is strikethrough text. Whether you’re tracking task statuses, updating records, or visually distinguishing completed versus pending entries, strikethrough formatting in Excel helps improve clarity and readability. In this article, we’ll explore everything you need to know about applying, customizing, and effectively using strikethrough in Excel.

What is Strikethrough in Excel?

Strikethrough is a text formatting effect that crosses out characters across a cell by running a horizontal line through them. It’s ideal for showing deleted, completed, or invalid data without removing it from the worksheet—making it discreet yet immediately noticeable.

Excel’s strikethrough feature is built into the Home tab under the Font section, enabling users to quickly apply this effect with just a few clicks.

How to Apply Strikethrough in Excel

Applying strikethrough is simple and accessible:

Select the cell(s) you want to format.
Navigate to the Home tab on the ribbon.
Click the Font group.
Click the Strikethrough icon (∕ icon, looks like a crossed-out line).
The selected text will instantly display with a strikethrough effect.

For quick access, you can also use shortcut key Alt + I, then E, then E (again for Strikethrough) on Windows, or use the Font dialog box for more options.

Advanced Strikethrough: Formatting Options & Tips

Excel offers more than just the basic strikethrough line. These features boost versatility:

Move Strikethrough Feature: The strikethrough function isn’t limited to a single cell—it can span multiple consecutive cells. Just select a range (e.g., A1 to C1), apply strikethrough, and the effect applies across all cells in the selection simultaneously.
Strikethrough with Font Color: Pair strikethrough with a diluted font color (e.g., gray or faint red) for subtle visual cues. Go to Font Settings > Color dropdown and choose a light tone for better presentation.
Using Conditional Formatting: Combine strikethrough with conditional rules. For example, highlight overdue tasks by making due dates expired, then apply strikethrough to those cells automatically—keeping data clean and actionable.

Practical Uses of Strikethrough in Excel

Incorporating strikethrough into Excel workflows elevates data presentation. Here are some common use cases:

Tracking Task Descriptions: Mark completed steps in checklists or to-do lists by left-clicking strikethrough—keeping progress easy to follow without deleting text.
Debiting & Credit Recording: In financial tracking, show historical changes: original entries left strikethrough, new entries right-aligned beneath for clear before/after comparisons.
Status Indicators: Use in project management dashboards to blur outdated tasks or discontinued items visually, maintaining clean visual hierarchy.
Editable Logs & Audit Trails: Record changes with transparency—apply strikethrough to old values to signal removal, keeping audit trails clear and honest.

Strikethrough vs. Other Excel Text Effects

While strikethrough is powerful, Excel offers complementary typography tools:

Underline: Indicates emphasis or clickable links—strikethrough signals invalid or crossed-out content.
Bold/Italic: Emphasizes priority or action items but doesn’t remove meaning like strikethrough.
Color Changes: Enhance visibility but don’t cross out text—strikethrough adds negative space for clarity.

Using strikethrough thoughtfully prevents clutter while improving data communication.

Final Thoughts: Master Strikethrough for Professional Excel

Using strikethrough formatting in Excel is a simple yet effective way to enhance data readability and streamline workflows. Whether updating statuses, tracking changes, or cleaning up legacy data, this feature keeps important information visible without losing it.

Experiment with combining strikethrough with formatting, conditional rules, and multi-cell ranges to maximize its impact in reports, dashboards, and personal tracking tools. With practice, strikethrough becomes an intuitive part of your Excel mastery—elevating both efficiency and clarity.

FAQ: Strikethrough in Excel

Q: Can I apply strikethrough to multiple cells at once? A: Yes! Select a range of cells and apply strikethrough—all selected cells will show the effect.

Q: Is strikethrough permanent or temporary? A: Strikethrough is permanent formatting. Deleting the effect is as easy as removing the styling using the Home tab.

Q: Can I combine strikethrough with other effects? A: Absolutely. Try combining strikethrough with bold, color, or font size changes for stronger visual emphasis.

Q: How do I remove strikethrough? A: Select the cell(s) and click Strikethrough again in the Home tab or use the Font dialog box under Conditional Formatting → Font settings.

Ready to improve your Excel data presentation? Start using strikethrough today to make your worksheets clearer and more professional!**