Excel strikethrough is a formatting option that visually draws a line through the text in a cell, signaling completion, cancellation, or revision without deleting content. This simple yet powerful feature helps teams track changes, flag obsolete items, and maintain clarity across spreadsheets used for finance, inventory, project tracking, and reporting.
Using strikethrough consistently improves readability and auditability in shared workbooks, making it easier to distinguish active items from those that are obsolete or pending review. The following sections outline the main use cases, methods, and best practices for applying and managing strikethrough in Excel.
| Keyboard Shortcut | Menu Path | Quick Access Toolbar | When to Use |
|---|---|---|---|
| Ctrl+5 (Windows) / Command+Shift+X (Mac) | Home > Font > Strikethrough | Add Strikethrough button for one-click access | Toggle completion status, mark outdated entries, indicate cancelled tasks |
| Works on merged cells when text is aligned center horizontally | Format Cells > Font tab > Strikethrough checkbox | Customize the toolbar to keep strikethrough visible | Use in reports to show deprecated line items without removing historical context |
| Applies to the entire selected cell range | Conditional formatting can automate strikethrough based on rules | Combine with cell styles for consistent formatting across sheets | Highlight expired deadlines, shipped orders, or closed projects at a glance |
Applying Strikethrough Using Keyboard Shortcuts
Keyboard shortcuts provide the fastest way to add or remove strikethrough in Excel. Selecting the target cell or range and pressing Ctrl+5 (Windows) or Command+Shift+X (Mac) instantly toggles the format, saving time during data cleanup or status updates.
Before using the shortcut, ensure that the correct cells are selected, since the format applies to the entire active selection. This approach is ideal for quickly marking completed tasks, cancelled orders, or archived entries directly within large datasets.
Using the Home Ribbon and Font Dialog
The Home ribbon in Excel includes a dedicated Strikethrough button within the Font group. Clicking this button applies or removes the format in one step, making it accessible for users who prefer mouse-driven workflows.
For more control, users can open the Format Cells dialog by pressing Ctrl+1, then navigate to the Font tab and check the Strikethrough option. This method is helpful when setting multiple font properties at once or when building predefined cell styles that include strikethrough as part of a consistent visual scheme.
Adding Strikethrough to the Quick Access Toolbar
Customizing the Quick Access Toolbar with the Strikethrough button reduces reliance on ribbon navigation and streamlines repeated formatting tasks. Once added, the button remains available regardless of the ribbon tab currently displayed.
Users can right-click the Strikethrough button in the ribbon and choose Add to Quick Access Toolbar, or customize the toolbar through Excel options to include additional commands relevant to their workflow. This setup is especially useful in environments where teams frequently mark items as complete, canceled, or obsolete.
Best Practices and Compatibility Considerations
Maintaining consistency in how strikethrough is applied supports clearer communication across collaborators. Limiting decorative use and aligning the format with defined meanings, such as cancelled items or superseded figures, helps teams interpret data accurately without additional explanation.
Excel for Microsoft 365, Excel 2021, 2019, 2016, and most recent web versions support the same keyboard shortcut and formatting behavior. Being mindful of file export formats and external tools that consume Excel data ensures that strikethrough remains visually preserved and semantically meaningful downstream.
Optimizing Workflow with Strikethrough in Excel
- Use keyboard shortcuts Ctrl+5 (Windows) or Command+Shift+X (Mac) for rapid toggling during data cleanup.
- Add Strikethrough to the Quick Access Toolbar to streamline repetitive formatting tasks across sheets.
- Define clear rules with your team for when to apply strikethrough, such as marking cancelled orders or obsolete inventory.
- Combine strikethrough with cell styles or conditional formatting to automate visual updates based on status changes.
- Verify exported formats like CSV and PDF if downstream tools rely on the visual indication of cancelled or completed items.
FAQ
Reader questions
Will applying strikethrough change the cell value or affect calculations?
No, strikethrough is a purely visual format that alters the appearance of text without changing the cell value, formula, or number type, so all calculations and references remain unaffected.
Can I use conditional formatting to automate strikethrough for completed tasks?
Yes, by creating a conditional formatting rule that uses a formula such as =$B2=TRUE, you can automatically apply strikethrough when a corresponding checkbox or status column indicates completion.
Does strikethrough appear when I export the sheet to CSV or PDF?
CSV files do not preserve any formatting, so strikethrough will not appear in CSV exports. PDF exports typically retain the visual line, depending on how the sheet is printed or saved. Yes, you can apply strikethrough to a group of cells in one action by selecting them first. In merged cells, the format applies to the entire merged block, though exact line positioning may vary slightly depending on alignment settings.