Strike Out in Excel: A Practical How-To Guide
Learn practical methods to strike out in Excel using font strikethrough, conditional formatting, and formulas. This step-by-step guide helps you mark completed items clearly while preserving data integrity.
By applying a strikethrough style or conditional formatting, you can strike out text in Excel to mark completed tasks, finished items, or canceled entries. This guide shows how to apply a font strike, use conditional formatting to strike out dynamically, and set up formulas that trigger the format based on cell values.
What strike out means in Excel
In Excel, striking out text is a visual cue indicating completion, cancellation, or removal from consideration. The classic method is a font strikethrough; more advanced users automate this with conditional formatting or formulas. According to XLS Library, adopting consistent strikeout conventions improves readability and audit trails, especially in task lists and project trackers. Key ideas include applying strikethrough to mark done items, using color cues to enhance scannability, and preserving the original data for traceability. This approach helps teams communicate status without deleting information, supporting accountability and clear documentation of changes over time.
Quick method: font strikethrough (static text)
The simplest way to strike out is a direct edit. Select the cells, then go to Home > Font and choose Strikethrough, or press Ctrl+5 to toggle the effect. This method changes only the chosen text and remains in the workbook unless you remove it. For checklists and task descriptions, apply the strike to the relevant column so completed items stand out at a glance. Maintain consistent font size and alignment to preserve readability across your sheet.
Dynamic strike with Conditional Formatting
Conditional formatting lets you apply a strike automatically when a condition is true. Steps: select the target range, go to Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Example: =Status2="Done" (adjust cell references to your sheet). Click Format, switch to the Font tab, check Strikethrough, and choose a color if desired. Confirm, then copy or apply the rule to other cells as needed. Now, changing a status from Not Done to Done will trigger the strike without manual edits.
Practical example: checklists and task lists
Imagine a project tracker with a Description column and a Status column. Status uses words like Not Started, In Progress, and Done. By applying a conditional formatting rule to the Description column tied to the Status column (e.g., =$Status2="Done"), you automatically strike out completed items. This keeps your data intact in the Description column while providing a clear visual cue for completed work. Use a second rule to color the text or background for additional emphasis.
Accessibility and readability considerations
Strikeouts can impact readability, especially when printing or sharing in grayscale. Consider combining strikethrough with a subtle color cue or a separate status column to convey the same information. Always test how your sheet prints and share a short legend so readers understand the convention. If your workbook is used by others, document the rule logic and status terms in a dedicated sheet or README tab.
Common pitfalls and how to avoid them
One common pitfall is applying Strikethrough to entire rows unintentionally. Always select precise ranges and verify the rule's scope before applying. Another pitfall is relying on manual changes that are later overwritten by bulk edits. Use conditional formatting for dynamic behavior and keep manual edits restricted to controlled exceptions. Finally, remember that strikethrough does not change the underlying data; ensure any downstream formulas are not affected by the formatting.
Authority sources
For additional guidance, consult official documentation and expert sources. Microsoft Support provides step by step instructions on formatting in Excel, while Learn Microsoft Docs covers advanced formatting and conditional formatting topics. These resources help you align your approach with best practices and accessibility considerations.
Ready-to-use templates and templates
Create a small starter workbook to practice strike out in Excel: a Status column with common states, a Description column for text, and a conditional formatting rule that ties the two together. Save a copy as a template so new projects can reuse the same setup. As you grow, you can adapt the rules to more complex datasets, like lists with multiple subitems or nested checklists.
Tools & Materials
- Excel or Microsoft 365(Any modern version with formatting options)
- Sample workbook(Include at least a Status column and a Description column)
- Keyboard shortcuts cheat sheet(Ctrl+5 toggles strikethrough)
- Printer or PDF export(Test how strikeouts print or export)
Steps
Estimated time: 60-90 minutes
- 1
Prepare your workbook
Create a Status column (e.g., Not Started, In Progress, Done) and a Description column that will receive the strikeout formatting. Ensure your sheet has a clearly defined header row and consistent data types.
Tip: Label statuses with minimal variance to keep rules simple. - 2
Apply a manual font strike to sample
Select a cell in the Description column, apply Strikethrough from the Font menu, and verify the visual result. This confirms the appearance you want before automating it.
Tip: Use a small sample range to test, then expand to the full column. - 3
Create a dynamic status column
Populate the Status column with values like Done or Completed. This column will drive the conditional formatting rule.
Tip: Keep statuses consistent to avoid rule mismatches. - 4
Set up conditional formatting
Select the Description range, go to Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Enter =Status2="Done" (adjust as needed), then format with Strikethrough and your preferred color.
Tip: Ensure the rule applies to the correct range and uses absolute references where appropriate. - 5
Copy the rule to other cells
Use the Fill Handle or Format Painter to apply the rule across the entire Description column. Validate consistency across rows with varying statuses.
Tip: Apply to non-contiguous ranges individually if needed. - 6
Test and save
Change statuses to Done and confirm the strike appears automatically. Save your workbook as a template if you plan to reuse this setup.
Tip: Always test on a backup copy before distributing to a team.
People Also Ask
What is the fastest way to strike out text in Excel?
The quickest method is to use the keyboard shortcut Ctrl+5 to toggle strikethrough on the selected text. For larger ranges, use the Font dialog's Strikethrough option. Conditional formatting provides automation for future changes.
Use Ctrl plus five to toggle strikethrough, or apply conditional formatting for automatic changes.
Can I strike out text automatically based on a checkbox?
Yes. Create a checkbox or a TRUE/FALSE cell, then set a conditional formatting rule that applies Strikethrough when the linked cell evaluates to TRUE. This keeps the data clean while visualizing status automatically.
Yes. Link a checkbox to a conditional formatting rule that applies a strike when checked.
Does strikethrough affect printing or exporting?
Strikethrough is a font effect and prints like any other text. If you print in grayscale, you may want an additional cue like color or a separate status column to ensure legibility.
It prints like other text, but consider color cues for grayscale printing.
Can I strike out numbers or dates?
Strikethrough can be applied to any text in a cell. Numeric values or dates will strike through like text if formatted, but consider whether the visual fits your data type and reporting needs.
Yes, you can strike through numbers or dates if you apply the formatting.
Is it possible to strike out data with formulas?
Formulas cannot apply font formatting by themselves. Use a helper column with a status and tie formatting to that status with conditional formatting for dynamic results.
Formulas can't change formatting directly; use a status-driven rule instead.
What is the difference between the font strike and conditional formatting?
Font strike is a manual or static change that affects only the selected text. Conditional formatting applies formatting automatically when a rule is met, which is ideal for dynamic task tracking.
Font strike is manual; conditional formatting automates the effect when a rule is true.
Watch Video
The Essentials
- Apply font strikethrough for static marks.
- Use conditional formatting to automate strikeouts.
- Keep a clear legend and consistent statuses for readability.
- Test changes on copies before deployment.
