Strikethrough Excel helps you track changes, mark tasks as complete, and maintain a clear audit trail without losing data. This approach keeps spreadsheets clean while preserving historical context for reviewers and managers.
Below is a quick reference that maps common use cases to built-in tools, keyboard shortcuts, and formatting options you can apply immediately.
| Goal | Built-in Tool | Keyboard Shortcut | Best For |
|---|---|---|---|
| Visual strike through text | Format Cells > Font > Strikethrough | Ctrl+5 (Windows) / Command+5 (Mac) | Marking completed items |
| Undo accidental strike | Quick Access Toolbar > Undo | Ctrl+Z (Windows) / Command+Z (Mac) | Reversing changes fast |
| Conditional strike logic | Custom format with code ";";";@" | Ctrl+1 to open Format Cells | Automating marks based on values |
| Preserve original value | Use separate status column or comments | N/A | Audit compliance and reporting |
How to Apply Strikethrough in Excel
Applying a visual line through text is fast when you use the right menu and shortcut. The Format Cells dialog gives precise control, while the keyboard option speeds up repetitive work.
Open Format Cells with Ctrl+1, switch to the Font tab, and check Strikethrough. Confirm with OK to finalize the style on selected cells.
Using Conditional Formatting for Task Tracking
Set Rules Based on Cell Value
Combine custom number formats with conditional rules so completed tasks automatically show a line. Use a helper column with simple logical tests to drive the display.
Maintain Data Integrity
Keep the underlying value unchanged while the view shows a strike. This separation supports accurate calculations and clean reporting downstream.
Keyboard Shortcuts and Quick Access
Speed matters when you are reviewing long lists. The standard shortcut toggles a line through selected text, and you can add the command to the Quick Access Toolbar for one-click access.
Pin the Strikethrough action to the toolbar if you use it daily. This placement removes extra clicks and keeps your workflow focused on analysis rather than navigation.
Data Integrity and Audit Practices
Preserve Original Numbers
A visual line should rarely replace the source value. Store key metrics in separate columns so filters and formulas continue to reference clean data.
Document Your Method
Add a standard note or color code that explains when and why you apply a strike. Consistent documentation helps teammates interpret the sheet without asking.
Best Practices for Teamwide Adoption
Standardizing how your group uses lines prevents confusion and supports collaboration across departments.
- Define when a line indicates complete, reviewed, or obsolete.
- Use a consistent color for header and status cells to improve scanability.
- Keep raw numbers in separate columns to protect calculations.
- Add a short guide in the first sheet for new team members.
- Review formatting rules during monthly data quality checks.
FAQ
Reader questions
Will applying strikethrough change my formulas or calculations?
No, a line through text is only a display format. Cell values used in formulas remain untouched, so totals and references stay accurate.
Can I automate strikethrough based on a date or status column?
Yes, use conditional formatting with a formula or custom number format that reacts to cell values, so lines appear automatically when criteria are met.
How do I remove strikethrough from an entire sheet quickly?
Select all cells with Ctrl+A, open Find & Select, choose Go To Special, pick Formats, then clear the Strikethrough option in Format Cells.
Will exporting to CSV keep the strikethrough visual?
CSV files store values only, not font formats. Save as XLSX or PDF if you need the line to appear in shared documents.