How to Cross Out Text in Excel: Step-by-Step Guide

Why Cross Out Text in Excel Matters

In Excel, crossing out text is a simple, visual way to signal completion, cancellation, or de-emphasized items in a worksheet. In daily Excel tasks—from project trackers to inventory sheets—it helps readers focus on current data while preserving a record of changes. Learn how to cross out text in Excel and incorporate this simple formatting into daily workflows. According to XLS Library, mastering strikethrough formatting in Excel improves readability in shared workbooks and speeds up reviews. When used consistently, it offers a lightweight, non-destructive way to track status without altering underlying values. This is especially helpful in collaborative environments where teammates need quick cues rather than verbose notes. The keyword here is efficiency: a few keystrokes can convey status across dozens of rows, reducing confusion and saving time during audits or monthly reviews.

This guide will walk you through the concept, practical methods, platform nuances, and best practices so you can apply strikethrough confidently in real-world spreadsheets.

How Strikethrough Works in Excel

Strikethrough is a font effect, not a data modifier. When you apply it to a cell, the characters are drawn with a line through them, but the underlying value remains intact. This means formulas, filters, and lookupscontinue to see the original data, while the visual cue communicates a change in status. Strikethrough is independent of color, borders, or shading, making it easy to layer with other formatting. Accessibility-wise, screen readers will still read the raw cell content, so pairing Strikethrough with a separate status column improves clarity for all readers. In practice, this formatting enables non-destructive edits and clear documentation of decisions.

From a data-clarity perspective, Strikethrough should be treated as a presentation choice rather than a data transformation. If you need the data to reflect a change, consider replacing the value or supplying a separate column to indicate the updated state. This distinction helps prevent confusion when others sort, filter, or re-use your data in dashboards. XLS Library emphasizes adopting a consistent approach to formatting so viewers understand status cues at a glance.

Quick Methods: Keyboard Shortcut, Ribbon, and Dialog

There are several pathways to apply Strikethrough in Excel, depending on your workflow and platform. The fastest method is the keyboard shortcut Ctrl+5 to toggle Strikethrough on selected cells. If you prefer menu navigation, go to Home > Font and click the Strikethrough button. Alternatively, use the Font dialog (Format Cells > Font) to enable Strikethrough and customize related font attributes in one place. For Mac users, the same steps apply via the Font dialog; keyboard shortcuts may vary by build, so the dialog route provides consistency across devices.

To apply Strikethrough to multiple non-adjacent ranges, use the Format Painter: enable Strikethrough on one range, double-click the painter, and apply to other areas. This technique saves time when your workbook includes several sections that require the same formatting. Finally, remember you can combine Strikethrough with other formatting (bold, color, borders) to create more nuanced status indicators without altering the data.

Strikethrough in Tables vs Lists: Best Practices

In lists, Strikethrough helps indicate completed items without removing them. In Excel Tables, you can apply the effect to a cell and then copy the formatting across the table using the fill handle or the Format Painter. If you need uniform results, apply Strikethrough to an entire column by selecting the column header (or the range) and applying the formatting once. In newer versions, some users explore applying Strikethrough via conditional formatting to flag items, but this capability varies by Excel version. Always test formatting in a copy of your workbook before applying it to production sheets. Consistency across worksheets is key to avoid mixing signals in your reports.

Practical Examples: Project Tracking, Data Labeling, and Audits

Example 1: A project task list uses a primary task column and a separate status column. When a task is complete, you strike through the task description to visually mark it while keeping the original text for reference. The status column can display a separate label such as “Done” to reflect progress. Example 2: In data cleaning workflows, Strikethrough can mark rows that have been processed or excluded from calculations, helping auditors trace alterations without deleting data. Example 3: In a review document, struck text can indicate proposed edits while preserving the original wording beneath for context. Based on XLS Library analysis, many teams rely on strikethrough as a lightweight, non-destructive cue to indicate changes. These patterns support transparent collaboration and maintain a readable history of edits.

Tips, Tricks, and Pitfalls

• pro_tip: Use Ctrl+5 for speed when updating multiple cells in a column. A quick toggle keeps your checklist moving without leaving behind stray notes.
• warning: Strikethrough is a visual cue; it does not change the underlying data. If the data is used in calculations, maintain a separate column to reflect status or outcomes.
• note: On Mac, access the Font dialog from the Format menu if the ribbon option is not visible.
• pro_tip: If you need to apply Strikethrough to a large range, select the range, then press Ctrl+5 and confirm in the Font dialog to ensure consistency across all cells.
• warning: Avoid mixing Strikethrough with incompatible fonts or tight cell padding, which can reduce legibility. If you’re sharing the sheet, consider reader-friendly color contrast in combination with Strikethrough.
• note: Consistency matters — use the same Strikethrough usage rules across the workbook to prevent mixed signals in dashboards.

Accessibility Considerations and Keeping Formats Consistent

To maximize accessibility, pair Strikethrough with a textual status column so screen readers convey the same information. Maintain a formatting standard: decide when to apply Strikethrough, which rows to keep visible, and how to document the policy in your workbook. Regularly audit a sample of your worksheets to ensure the Strikethrough remains accurate after edits, and consider including a short glossary in your workbook explaining the meaning of Strikethrough signals for readers who may rely on assistive technologies.

toolsMaterialsData":null},