Learning how to apply strikethrough text in Excel is one of those small productivity wins that quietly transforms how you manage spreadsheets every single day. Whether you are tracking completed tasks on a to-do list, marking discontinued products in an inventory sheet, or showing original prices next to discounted figures, the strikethrough format gives readers an instant visual cue. In 2026, with Microsoft 365 updates rolling out monthly, the strikethrough feature remains one of the most underused formatting tools, even though it sits one keyboard shortcut away.

The strikethrough effect draws a horizontal line through the middle of any text in a cell, signaling that the value is cancelled, completed, outdated, or no longer applicable. Unlike deleting the data outright, strikethrough preserves the original content for audit trails, historical comparison, and reversibility. Project managers, accountants, teachers, and small business owners all rely on this format to communicate status without rewriting entire datasets or building complex visual dashboards from scratch.

This guide walks you through every method for applying strikethrough in Excel across Windows, Mac, web, and mobile versions. You will learn the universal keyboard shortcut Ctrl+5, how to access strikethrough through the Format Cells dialog, how to add a one-click button to your Quick Access Toolbar, and how to trigger automatic strikethrough using conditional formatting tied to checkbox values. Each technique fits a different workflow, so you can pick the one that matches your habits.

Beyond the basics, we will cover advanced scenarios that intermediate users wrestle with constantly. These include applying strikethrough to partial text inside a cell, combining strikethrough with cell fill colors to create kanban-style trackers, using VBA macros to toggle strikethrough across selections, and copying strikethrough formatting between workbooks. Each scenario includes a real example with clear steps, plus troubleshooting tips for the moments when Excel refuses to cooperate.

We will also tackle a question that confuses many spreadsheet users: how does strikethrough behave when you export to PDF, paste into Outlook emails, or upload to Google Sheets and SharePoint? The answer depends on which Excel version you started with and which destination application you used. By the end of this article, you will know exactly which combinations preserve the formatting and which ones quietly strip it away during conversion or transfer.

Finally, this guide includes a printable checklist, a stat-driven breakdown of how strikethrough fits into broader Excel formatting workflows, and ten common questions with detailed answers. Whether you are a complete beginner who just opened Excel for the first time, or an experienced analyst building dashboards for executives, you will find practical techniques here that you can apply today. Let us start with the fastest method and work our way toward the more advanced automation features built into modern Excel.

If you want to test your overall Excel formatting knowledge after reading, the practice quizzes linked throughout this guide cover formatting, formulas, and functions in bite-sized question sets. Many readers use them as warmups before certification exams or job interviews where Excel proficiency is screened in the first round.

The Format Cells dialog is the most reliable method for applying strikethrough when you need additional control over font styling at the same time. To open it, select your cells, then press Ctrl+1 on Windows or Cmd+1 on Mac. The Format Cells window appears with six tabs. Click the Font tab, where you will see a list of effects including Strikethrough, Superscript, and Subscript. Tick the Strikethrough box, then click OK to apply the formatting to every selected cell.

This method shines when you want to combine strikethrough with color changes, font swaps, or size adjustments in a single operation. For example, marking discontinued inventory items often calls for strikethrough plus a gray font color so the rows visually fade into the background without disappearing entirely. The Format Cells dialog lets you set all three properties simultaneously, which saves you from making three separate trips to the ribbon menus and risking inconsistent formatting across hundreds of rows.

You can also apply strikethrough to only part of the text inside a cell, which the ribbon shortcut cannot easily do for partial selections. Double-click into the cell to enter edit mode, highlight just the characters you want to cross out using your mouse or Shift+arrow keys, then press Ctrl+1. The Font tab opens with only the highlighted characters affected. This trick works wonders for invoices where you display the original price alongside a sale price within the same cell text.

For users who format spreadsheets daily, the dialog method becomes tedious. That is where building a custom cell style pays off. Click Home, then Cell Styles, then New Cell Style. Name it something descriptive like Completed Task or Discontinued Item, then click Format and apply strikethrough, your preferred color, and any fill background. Save the style. Now you can apply the entire formatting bundle with two clicks from the Cell Styles gallery on any cell in the workbook.

Custom cell styles also travel with the workbook, so when you email a file to a colleague, the styles appear in their Cell Styles gallery automatically. This consistency matters in team environments where multiple analysts edit the same financial model and you want every cancelled line item to look identical regardless of who marked it. The styles persist across sessions and survive saves to xlsx, xlsm, and xlsb file formats without any data loss or visual degradation.

One detail worth noting is that strikethrough applied through Format Cells behaves exactly like strikethrough applied through Ctrl+5 or the ribbon button. There is no difference in how Excel stores the property internally. The choice of method comes down purely to workflow preference and which other formatting you intend to apply simultaneously. Both methods work identically when you later use the Find and Replace feature with format-based searches to locate every cell that has strikethrough applied across an entire sheet.

If you frequently need to copy strikethrough formatting from one cell to many others, the Format Painter tool on the Home ribbon is your best friend. Click a cell that already has strikethrough, click the paintbrush icon, then click any other cell to copy the format. Double-clicking the paintbrush locks it on, letting you click multiple destination cells in succession before pressing Escape to release it and return to normal cursor mode.

Conditional formatting transforms strikethrough from a manual action into an automatic visual response. Instead of pressing Ctrl+5 every time you complete a task, you can configure Excel to apply strikethrough automatically when a checkbox is checked, a status column contains the word Done, or a date falls before today. This automation is the single biggest productivity multiplier in any task list, project tracker, or inventory sheet that uses strikethrough as a status indicator across dozens or hundreds of rows.

To set this up, first add a status column next to your data. In Excel 365 and 2024, you can insert true checkboxes directly through the Insert menu by choosing Checkbox. Earlier versions require you to use form control checkboxes from the Developer tab, or simply type the letters Y and N into a column. Whichever approach you pick, the next step is the same: select the data range you want to format, then open Home, Conditional Formatting, New Rule, and choose Use a formula to determine which cells to format.

In the formula box, enter something like =$D2=TRUE if column D contains your checkboxes, or =$D2="Done" if it contains text status values. Click the Format button, switch to the Font tab, tick Strikethrough, optionally change the font color to gray, and click OK twice. The conditional formatting rule applies instantly to every row where the condition is true. Adding new rows with the same status will trigger the strikethrough automatically without any further manual intervention required from you.

This pattern works beautifully for to-do lists, project punch lists, sales pipelines, and inventory aging reports. For a more sophisticated tracker, you can stack multiple conditional rules together. One rule applies strikethrough when status equals Done, a second rule applies red font when a deadline passes without completion, and a third rule highlights overdue rows with a yellow background. Excel evaluates the rules in order, so manage priority carefully through the Conditional Formatting Manager dialog to avoid unexpected visual conflicts.

Date-based strikethrough is another powerful pattern. Suppose you have a list of subscriptions or contracts with end dates. You want every expired item to display with strikethrough automatically as time passes. Create a conditional rule with the formula =$E2<TODAY(), apply strikethrough formatting, and Excel will refresh the visual every time you open the workbook or press F9 to recalculate. No manual updates required, no missed expirations, and no need to write any VBA code or macros to maintain the automation over time.</p>

For users coming from environments where they relied heavily on tools like vlookup excel formulas to flag matching records, conditional formatting with strikethrough is the visual counterpart. You can even combine the two by using a VLOOKUP or XLOOKUP inside the conditional formatting formula. For example, =VLOOKUP($A2,CompletedList,1,FALSE) inside the rule applies strikethrough whenever the row identifier appears in a separate list of completed items. This bridges data validation and visual presentation in one elegant rule.

Finally, remember that conditional formatting rules travel with the workbook but can occasionally break when you copy data across sheets or workbooks. Always test the rules in the destination after major restructuring. Use Conditional Formatting, Manage Rules to inspect the applied range and formula. If the rule is no longer applying to new rows you added later, simply edit the Applies to range and extend it to cover the full data area including any new content rows.

Advanced users often need to toggle strikethrough across multiple selections at once, apply it conditionally based on complex logic, or build it into recurring report templates. Visual Basic for Applications, known as VBA, opens up these possibilities. You can write a short macro that toggles strikethrough on the current selection, assign it to a custom ribbon button or keyboard shortcut, and use it across any workbook on your machine without retyping the logic each time you need it for a new project.

The simplest macro looks like this. Open the Visual Basic Editor with Alt+F11, insert a new module, and paste a procedure that reads Sub ToggleStrike, then Selection.Font.Strikethrough = Not Selection.Font.Strikethrough, then End Sub. Save the workbook as xlsm to preserve macros. Assign the macro to a custom shortcut by opening the Macros dialog with Alt+F8, selecting your macro, clicking Options, and choosing a letter like Q. Now Ctrl+Q toggles strikethrough across any noncontiguous selection instantly.

For team environments, consider building this macro into a Personal Macro Workbook stored in the XLSTART folder. The Personal Macro Workbook loads automatically every time Excel starts, making your custom shortcut available across every file you open without needing to enable macros in each individual workbook. This single setup change transforms strikethrough from a single-file convenience into a true personal productivity tool that follows you across every project for years to come.

Another advanced scenario involves syncing strikethrough state with external systems. Suppose you maintain a project tracker that mirrors tasks from a tool like Microsoft Planner, Asana, or Jira. You can use Power Query to refresh the task list with current status from the source, then a conditional formatting rule applies strikethrough automatically to any row marked as completed in the source system. This pattern keeps your Excel-based dashboard visually accurate without manual updates after every status change anywhere across the team.

Strikethrough also plays well with other Excel features that many people learn separately. For example, after learning how to merge cells in excel, you may discover that strikethrough still applies cleanly across merged ranges because Excel treats the merged group as a single visual unit. Similarly, when you freeze rows or columns to keep headers visible, strikethrough in the scrolling area remains crisp and readable because the formatting is stored per cell rather than per visible region of the worksheet display.

For accessibility-conscious workflows, remember that strikethrough alone does not communicate meaning to all users. Pair the formatting with a text indicator, an icon, or an Aria-friendly label when sharing files with colleagues who use screen readers. Excel allows you to add cell-level comments or notes that screen readers can announce, which gives blind or low-vision users the same status awareness that sighted users get from the visual strikethrough effect. This small extra step makes a meaningful difference for inclusive teams.

Finally, if you ever need to remove strikethrough from a large range, the fastest method is to select the range, press Ctrl+1 to open Format Cells, click Font, untick the Strikethrough box, and click OK. This forces every selected cell into a non-strikethrough state regardless of its previous status. For ranges with mixed formatting, the checkbox appears with a filled square instead of a check, indicating partial application. Clicking it once unifies the state across the entire selection in one operation.

To close out this guide, let us walk through practical tips that experienced Excel users rely on when strikethrough becomes a daily tool rather than an occasional novelty. The first tip is to commit to a single team-wide convention. Decide whether strikethrough means completed, cancelled, or discontinued, and document that meaning in a shared style guide. Mixing meanings across a workbook confuses readers and undermines the visual clarity that strikethrough is supposed to provide in the first place across your entire reporting workflow.

The second tip concerns visual density. Strikethrough works best on cells that already have a clean default font and color scheme. If your workbook uses bold text, multiple background colors, and dense borders, the horizontal strikethrough line gets visually lost in the noise. Reserve strikethrough for sheets with minimal other formatting, or pair it with a softer gray font color to draw attention away from struck rows without making them invisible to readers who need to scan the data for context.

Third, use strikethrough together with row grouping when you need to occasionally hide completed items without losing them. Apply strikethrough on completion, then select the completed rows and use Data, Group to collapse them into a single click-to-expand bar. This preserves the data and the formatting while reducing visual clutter on the main view. Users can expand the group whenever they need to audit completed work or revive a previously cancelled task that came back into scope unexpectedly.

Fourth, test your workbook in the destinations where readers will actually consume it. If you typically email PDF exports to executives, run a test export and confirm the strikethrough renders clearly in the PDF reader most readers use. If you share files through SharePoint or OneDrive, open the workbook in the browser preview to confirm the formatting survives the cloud render pipeline. These quick tests prevent the embarrassment of sending a file where critical status information silently fails to display correctly for your audience.

Fifth, consider when strikethrough is the wrong tool for the job. For binary status indicators on dashboards viewed by executives, a colored shape or icon from the Excel icon sets feature is often more impactful. Strikethrough excels at line-item lists and granular trackers but loses force when applied to summary cells where readers expect bold numerical indicators. Pick the formatting tool that matches the cognitive load you want to impose on the reader rather than defaulting to strikethrough out of habit.

Sixth, archive completed projects to a separate sheet rather than letting strikethrough accumulate indefinitely. After a project ends, copy the completed rows to an Archive sheet, then delete them from the active sheet. This keeps the active view fast, focused, and visually clean while preserving historical data for future reference. Pair this with a simple naming convention like Archive_2026_Q1 so older archives remain organized and quickly retrievable when you need them during quarterly business reviews or audits.

Finally, remember that mastering small formatting tricks like strikethrough adds up over a career. Excel is a tool that rewards investment in tiny efficiencies, because those efficiencies compound across thousands of hours of spreadsheet work. The two seconds you save with Ctrl+5 today become two hours per year, and ten hours over five years. Multiply that across your entire team and small habits like this one become real productivity wins worth the time it takes to learn and standardize them properly.