Excel Strikethrough: A Practical How-To Guide for Data
Learn how to apply and manage strikethrough formatting in Excel, with step-by-step instructions, conditional formatting, and printing tips for clear, professional spreadsheets.
You will learn how to apply strikethrough formatting in Excel across cells, rows, and tables, and when to use it to indicate completed items or deprecated data. The guide covers manual application, conditional formatting for dynamic changes, and best practices for consistent, printer-friendly results. It also highlights common pitfalls and tips for sharing workbooks with strikethrough visible.
What is Strikethrough in Excel?
In Excel, strikethrough is a simple text formatting option that draws a horizontal line through the characters in a cell. It is a visual cue, not a data change. This makes it useful for marking items as completed, archived, or deprecated without deleting the value. The feature applies to individual cells, ranges, rows, or columns and remains visible when you print or export the sheet, ensuring your status indicators carry over to others. According to XLS Library, strikethrough is a lightweight way to communicate status without altering data integrity, making it a staple in task lists and data-cleaning notes.
When to Use Strikethrough in Data Work
Strikethrough excels as a non-destructive status marker. Use it on task lists to show items that are finished, on inventory sheets to flag obsolete parts, or in project dashboards to indicate completed milestones while preserving the original values. It’s particularly helpful in collaborative work where teammates need a quick, visual cue without altering underlying data. Consistent usage across modules makes reports easier to scan and reduces ambiguity in status reporting.
How to Apply Strikethrough Manually in a Cell
To apply strikethrough, select the target cell or text in the cell, go to the Home tab, locate the Font group, and click the Strikethrough button. You can also open the Font dialog (Format Cells) and check the Strikethrough option. This approach keeps data intact while signaling a change in status. Verify the result by deselecting and reselecting the cell to ensure the line appears as expected.
Applying Strikethrough Across a Range or Table
When you need to mark many items at once, select the entire range, then apply Strikethrough from the Font group. If you need to apply the same formatting to a repeated pattern, use the Format Painter to copy the Strikethrough styling to adjacent ranges. Remember that the formatting is visual only—values in cells remain unchanged—so you can adjust individual entries later without data loss.
Conditional Strikethrough: Dynamic Formatting for Status Flags
Conditional formatting provides a dynamic approach to strikethrough. Create a rule such as “Format cells where this formula is true: StatusCell = 'Done'” and apply Strikethrough as the font effect. This keeps your sheet automatically updated as statuses change, reducing manual edits. Pair this with a compact legend to ensure readers understand the rule driving the visual cue.
Printing, Sharing, and Accessibility Considerations
Strikethrough should appear in printed copies if the worksheet is formatted for print. Always preview before sharing or exporting to PDF to ensure lines aren’t faint or misaligned due to font choices. Consider accessibility implications: some readers may rely on color alone for status cues; combine strikethrough with a text label or legend to maintain clarity in black-and-white prints.
Common Pitfalls and How to Avoid Them
A common mistake is overusing strikethrough, which can clutter a sheet and obscure critical data. Another pitfall is applying strikethrough manually in one area and relying on conditional formatting elsewhere, causing inconsistent visuals. Finally, remember that strikethrough does not delete data; if you need to preserve references, keep original values in a separate column or sheet.
Tools & Materials
- Excel installed on Windows or macOS(Office 365 or Office 2021+ supports Strikethrough in the Font options.)
- Practice workbook with sample data(Include a task list or status column to apply strikethrough.)
- Access to Home > Font group or Font dialog(Use Strikethrough to apply or remove formatting.)
- Printer or PDF export (optional)(Test printing to verify strikethrough visibility.)
Steps
Estimated time: 15-25 minutes
- 1
Select the target cells
Open your workbook and highlight the cells or text where you want the strikethrough to appear. Selecting a range ensures consistent formatting across all items.
Tip: Keep the original data in a separate column for reference. - 2
Open the Strikethrough option
Go to the Home tab and look in the Font group to find the Strikethrough button. If you don’t see it, open the Font dialog via Format Cells to access the Strikethrough option.
Tip: If the button is hidden, customize the toolbar to include Strikethrough. - 3
Apply the Strikethrough
Click Strikethrough to apply the line to the selected cells. The visual cue should appear immediately—confirm by deselecting and reselecting.
Tip: Avoid applying to cells where a strikethrough would mislead readers. - 4
Remove Strikethrough when needed
To remove, reselect the cells and click Strikethrough again or open the Font dialog and uncheck Strikethrough.
Tip: Use the same method consistently to avoid confusion. - 5
Set up conditional strikethrough
Create a conditional formatting rule that applies Strikethrough when a condition is met (e.g., Status = 'Done').
Tip: Use a dedicated Status column to feed rules rather than embedding logic in the data cells. - 6
Test printing and sharing
Preview the sheet with Print Preview or export to PDF to verify the strikethrough renders correctly in outputs.
Tip: If lines look faint, adjust font size or weight before finalizing.
People Also Ask
How do I apply strikethrough to multiple cells at once?
Select the range, then click the Strikethrough option in the Home tab or Font dialog to apply the formatting to all highlighted cells at once.
Select the cells you want, then choose Strikethrough from the Home tab to apply it to the whole range.
Can strikethrough be dynamic with data changes?
Yes. Use conditional formatting to automatically apply Strikethrough when a condition is met, such as a status column indicating completion.
Yes, you can automate it with conditional formatting so the strike appears as statuses update.
Will strikethrough print in hard copies?
Yes. Strikethrough will print along with the text. Always verify with Print Preview to ensure it appears as intended.
Yes, just check Print Preview to confirm it looks right in printouts.
What is the difference between strikethrough and delete?
Strikethrough is a visual cue that leaves data intact, while delete removes the data from the cell. Strikethrough is reversible and preserves history.
Strikethrough just hides the meaning visually, but delete removes the data entirely.
How do I remove strikethrough quickly?
Select the cells and click Strikethrough again or use the Font dialog to uncheck Strikethrough.
Just reselect and click Strikethrough again to remove it.
Can I apply strikethrough via a formula?
Formulas cannot apply formatting directly. Use conditional formatting or macros to automate visual changes.
No, formulas don’t apply formatting; use rules or macros instead.
Watch Video
The Essentials
- Apply strikethrough via Home > Font for quick edits
- Use conditional formatting for dynamic status changes
- Test print/view to ensure visibility
- Maintain a legend for status cues to aid readers
