The Excel strikethrough shortcut is the keyboard combination Ctrl+5 (Cmd+Shift+X on Mac) that applies strikethrough text formatting to selected cells, drawing a horizontal line through the cell content. Strikethrough formatting is commonly used in Excel to indicate completed tasks in checklists, deprecated items in lists, items that have been canceled or superseded, and various other scenarios where you want to mark content as no longer current while keeping it visible for reference. The shortcut is one of the more useful but lesser-known Excel keyboard shortcuts that can substantially speed up formatting work compared to navigating menus.

This guide walks through the Excel strikethrough shortcut including how to use it, when strikethrough formatting helps, how to apply through Format Cells dialog as alternative, conditional formatting based on completion status, troubleshooting common issues, and various other Excel formatting techniques that complement strikethrough. Information here applies to Excel 365, Excel 2019, Excel 2021, and Excel for the Web with notes where features differ. Most operations work consistently across Windows and macOS with minor menu placement variations between platforms commonly used today across various Excel versions and editions.

Strikethrough formatting in Excel works similarly to strikethrough in Word and other applications — visually marking text as superseded or canceled while keeping it readable. Excel adds a single horizontal line through the middle of cell content. The formatting applies to entire cells (not partial cell content typically though that's possible through specific approaches). Strikethrough can be combined with other formatting like bold, italic, color changes, or various other formatting that affects appearance. The visual effect supports specific use cases where you want to keep content visible but indicate it should no longer be considered current or active.

The Ctrl+5 keyboard shortcut is the fastest way to apply strikethrough in Excel. Select the cell or cells you want to format. Press Ctrl+5 (or Cmd+Shift+X on Mac). The strikethrough line appears through the cell content. The shortcut toggles — pressing again removes strikethrough. The shortcut applies to whatever cells are currently selected, supporting both single cell formatting and multi-cell range formatting equally. Master this shortcut for fast formatting work compared to navigating Format Cells dialog or ribbon menus that take more time per use across many formatting operations.

For users wanting to apply strikethrough through the Format Cells dialog rather than keyboard shortcut, several reasons may apply. Format Cells dialog supports applying strikethrough alongside multiple other formatting options in single dialog action. The dialog provides clearer visibility of all formatting options for those still learning Excel formatting. Some users prefer dialog-based work over keyboard shortcuts. To access: select cells, press Ctrl+1 (or right-click → Format Cells), click Font tab, check Strikethrough checkbox in Effects section, click OK. The dialog approach is slower for single-action strikethrough but useful when applying multiple formatting changes simultaneously through one dialog interaction.

For users wanting to apply strikethrough automatically based on conditions, conditional formatting provides the mechanism. Common scenario: cross out completed tasks in a task list when a Status column shows 'Done'. Setup: select task description cells. Click Home → Conditional Formatting → New Rule.

Choose 'Use a formula to determine which cells to format'. Enter formula like =$B2="Done" (where B contains status). Click Format → Font tab → check Strikethrough → click OK. Click OK to apply. Now task descriptions automatically receive strikethrough when corresponding status cell shows 'Done'. The conditional approach scales to large task lists where manually applying strikethrough would be tedious.

For users wanting to combine strikethrough with checkbox controls, modern Excel supports linked checkboxes triggering strikethrough automatically. Insert checkbox via Developer tab → Insert → Form Controls → Checkbox. Right-click checkbox → Format Control → Cell link → specify cell to receive TRUE/FALSE. Apply conditional formatting to associated cells: rule formula =$D2=TRUE (where D contains checkbox-linked cell), format with strikethrough. Now checking the checkbox automatically applies strikethrough to the associated row. The combination creates interactive task lists with visual feedback supporting checkable item completion. Excel 365 also includes native checkbox feature simplifying this further.

Common use cases for Excel strikethrough beyond simple task completion include several scenarios. Inventory management: strikethrough discontinued products keeping them visible for reference but indicating not current. Project planning: strikethrough completed milestones in project tracker. Schedule management: strikethrough canceled appointments or events. Pricing changes: strikethrough old prices alongside new prices. Personnel records: strikethrough former employees keeping historical reference. Each use case benefits from strikethrough's visual indication of supersession or completion without removing data entirely. The flexibility supports diverse organizational scenarios where indicating completed/canceled/old status visually helps communication across various business and personal documentation contexts.

For users dealing with the specific challenge of partial cell strikethrough (striking through some text within a cell but not all), Excel supports this through editing mode. Double-click cell to enter edit mode. Select specific text portion you want to strike through. Press Ctrl+5 to apply strikethrough only to selected text. Press Enter to accept changes.

The result is partial strikethrough within the cell. This approach is more complex than full-cell strikethrough but supports specific scenarios where you want to mark only specific words or phrases within longer text content. The capability is sometimes overlooked by Excel users who assume strikethrough only works at full-cell level.

For users encountering issues with strikethrough formatting, several common problems and solutions exist. Strikethrough not appearing despite shortcut press — verify cell isn't already striked through (toggle behavior). Strikethrough disappearing on edit — sometimes happens with certain Excel configurations; reapply if needed. Strikethrough not transferring to other applications — copy as picture preserves visual; copy as values doesn't include formatting. Strikethrough not visible at certain zoom levels — extremely high or low zoom may render differently. Each issue has specific solution; most issues resolve through standard formatting troubleshooting and aren't unique to strikethrough specifically beyond general Excel formatting behavior.

Format Painter provides efficient way to copy strikethrough formatting between cells. Click cell with desired strikethrough formatting. Click Format Painter button on Home tab (or Ctrl+Shift+C copy formatting + Ctrl+Shift+V paste formatting in some Excel versions). Click target cell or drag across target range. The strikethrough plus any other formatting from source cell applies to target.

For repeated formatting application, double-click Format Painter to lock it on — apply to multiple targets without re-clicking source each time. Press Esc when finished. Format Painter is one of Excel's productivity-multiplying tools beyond just strikethrough application — supports any formatting copy across cells efficiently.

For users wanting to combine strikethrough with checkboxes for interactive task lists, several setup approaches work. Excel 365's native checkbox feature: Insert → Checkboxes (newer Excel feature). Each checkbox cell stores TRUE when checked, FALSE when unchecked. Apply conditional formatting referencing the checkbox cell to apply strikethrough to associated content. The combination produces interactive task lists where checking off completed items automatically strikes through the task description. Older Excel versions use Form Controls or ActiveX checkboxes with linked cells achieving similar result through more setup steps. Each approach supports interactive worksheets that respond to user actions through visual feedback.

Comparing strikethrough to alternative formatting approaches reveals trade-offs. Bold or color changes provide alternative visual emphasis without strikethrough's specific 'completed' connotation. Cell shading provides background color emphasis. Borders provide structural emphasis. Italic provides subtle differentiation. Each formatting type serves specific purposes — strikethrough specifically connotes 'completed', 'canceled', or 'no longer applicable' meaning that other formatting doesn't carry. Choose formatting based on the specific meaning you want to communicate. Combine multiple formatting types for comprehensive emphasis when appropriate (e.g., strikethrough plus gray font color for completed items providing both formatting clues).

For users wanting to use strikethrough in shared workbooks, several considerations apply. Co-authoring through OneDrive/SharePoint generally supports strikethrough across users. Multiple users editing simultaneously can affect formatting if they're modifying same cells. Document formatting conventions for team understanding. Consider whether strikethrough should be applied through conditional formatting (consistent rule-based application) versus manual application (potentially inconsistent across users). Each consideration affects formatting consistency in collaborative environments. Most strikethrough usage works well in shared environments though edge cases occasionally arise affecting specific scenarios with simultaneous edits to same content.

For users wanting to use strikethrough effectively in templates and forms, several patterns help. Build templates with conditional strikethrough applied to relevant ranges so users get automatic strikethrough behavior. Document the strikethrough conventions in template instructions or notes. Test with sample data to verify rules work correctly across various scenarios. Lock conditional formatting rules with worksheet protection if needed to prevent users from accidentally modifying formatting logic. Each template design element supports user-friendly templates where strikethrough behavior is consistent and meaningful versus ad-hoc strikethrough that varies across users and situations.

For users transitioning between Excel and other applications, strikethrough concepts transfer with adjustments. Word uses Ctrl+D for Format Cells which has strikethrough option (different shortcut). Google Sheets uses Format → Text → Strikethrough or Alt+Shift+5 keyboard shortcut. PowerPoint uses Format → Font → Strikethrough through dialog. Each tool has its own specific implementation while the conceptual operation transfers. Excel's Ctrl+5 shortcut is one of the more efficient keyboard accesses across applications — taking advantage of it makes Excel formatting work faster than equivalent operations in some other applications.

Common workflows where strikethrough provides value across various Excel use cases. To-do lists: cross out completed items keeping list manageable while showing progress. Inventory updates: mark discontinued items without removing them. Pricing updates: show old vs new prices clearly. Schedule changes: indicate canceled events while keeping in calendar. Project tracking: cross out completed milestones. Editorial workflow: indicate revised content. Each workflow benefits from clear visual indication of completed/canceled/superseded status that strikethrough specifically communicates better than alternatives. Build strikethrough into your standard Excel formatting toolkit alongside bold, italic, and various other commonly-used formatting types.

For users wanting to verify strikethrough is actually applied (rather than just visual artifact), several approaches help. Click cell to inspect — Format Cells dialog (Ctrl+1) → Font tab will show whether Strikethrough checkbox is checked. View formula bar — strikethrough formatting visible in cell display but underlying value is unchanged. Find & Replace doesn't search formatting by default but Find Format option allows searching for cells with specific formatting including strikethrough. Each verification approach helps confirm formatting state when troubleshooting or auditing existing workbooks where strikethrough behavior should be consistent.

For users wanting strikethrough effects beyond standard Excel capabilities, several creative approaches work. Custom number formats can apply specific strikethrough-like effects in number display. Combination of cell shading plus standard strikethrough provides emphasized 'completed' look. Color-coding plus strikethrough (e.g., gray font + strikethrough) provides multiple visual cues. Some users have created VBA macros applying strikethrough plus other effects with single click for repetitive workflows. Each approach extends standard strikethrough into more sophisticated visual communication where simple line-through doesn't quite capture the meaning needed.

For users dealing with the specific scenario of needing strikethrough in printed worksheets, several considerations apply. Strikethrough prints by default in standard print operations. Print quality matters — high quality printers reproduce strikethrough cleanly; lower quality may make it less distinct. Color strikethrough (combining strikethrough with colored font) prints in color on color printers, grayscale on monochrome printers. Print preview shows actual print appearance before committing to physical printing. Each consideration affects how printed worksheets communicate strikethrough meaning to recipients receiving physical printouts versus on-screen viewing only.

The bottom line on Excel strikethrough shortcut: Ctrl+5 (Windows) or Cmd+Shift+X (Mac) provides fastest application of this useful formatting. The visual indication of completed, canceled, or superseded content supports various Excel use cases from task lists through inventory management. Combine with conditional formatting for automatic rule-based application. Combine with checkboxes for interactive task lists. Remember strikethrough is visual only — doesn't affect calculations or analysis. Build into your standard Excel formatting toolkit alongside other commonly-used formatting types for comprehensive worksheet communication beyond just data values displayed in cells.

For users dealing with specific challenges of using strikethrough across Excel versions, several considerations apply. Modern Excel (365, 2021) includes native checkbox feature simplifying interactive list creation. Older Excel versions (2019, 2016) require Form Controls or ActiveX checkboxes for similar interactivity. Excel for Web supports basic strikethrough but may have limited conditional formatting features. Mobile Excel apps support viewing strikethrough but limited application/modification capabilities. Match your usage to available Excel version capabilities — modern Excel supports more sophisticated strikethrough scenarios while older versions require more setup steps for similar results.

For users wanting to learn strikethrough as part of broader Excel formatting skills, several related techniques deserve attention. Underline (Ctrl+U): different visual emphasis. Bold (Ctrl+B): emphasis without strikethrough's 'completed' connotation. Italic (Ctrl+I): subtle differentiation. Font color: through Home tab Font Color dropdown. Cell color: through Home tab Fill Color. Borders: through Home tab Borders dropdown. Each formatting type serves specific purposes — strikethrough is one of many formatting options worth mastering for comprehensive Excel formatting capability supporting various worksheet communication scenarios across different document types.

For users wanting to use strikethrough creatively in dashboards and reports, several patterns help. Combine strikethrough with KPI indicators (red/green) for status communication. Use conditional strikethrough to automatically format completed projects or closed deals. Combine strikethrough with grayed-out fonts for obvious 'historical' indicators. Use strikethrough sparingly for maximum impact — overused strikethrough loses meaning. Each creative application extends standard strikethrough utility into sophisticated visual communication. Match application to specific dashboard purposes rather than applying strikethrough broadly without clear intent.

Looking forward, Excel strikethrough capability continues evolving with feature additions. Native checkbox feature in Excel 365 simplifies common task list scenarios. Dynamic array integration may support more sophisticated rule-based strikethrough. AI-assisted formatting through Copilot may suggest appropriate use of strikethrough in various scenarios. Stay current with Excel feature evolution if you do substantial formatting work — new capabilities can substantially improve workflows when adopted. Microsoft's Excel blog and official Excel updates document new features worth incorporating into your toolkit over time as substantial Excel work continues benefiting from periodic skill refreshes covering new capabilities.