To apply strikethrough in Excel for Microsoft 365 on Windows, select the cell or cells and press Ctrl+5; press it again to remove the effect. You can also open Format Cells with Ctrl+1, choose the Font tab, and turn on or off the Strikethrough checkbox.
What the Strikethrough Checkbox Does
The Strikethrough checkbox is a font-formatting option. It draws a horizontal line through text or numbers in a cell without deleting, replacing, or changing the underlying value. For example, a cell containing the text “Order shipped” still contains that text after you strike it through; the line is a visual cue, not a change to the cell’s data.
That distinction is useful when you want to show that a task is done, an item is obsolete, or a value has been superseded while keeping the original information available. Strikethrough is not the same as a checkbox you can click to mark a task complete, and it does not automatically respond to changes in a cell. For automatic formatting, use conditional formatting, described below.
Apply Strikethrough with the Keyboard or Ribbon
For a quick change, select one cell or a range and press Ctrl+5 on Windows. This shortcut toggles strikethrough: it applies the effect if it is off and removes it if it is already on. If a selection contains cells with mixed formatting, the result may depend on the selection’s current formatting state, so check the cells afterward.
To use the ribbon instead, select the cells and look in Home > Font for the Strikethrough command. In some window sizes or ribbon layouts, font commands may be compressed; opening the Format Cells dialog is a dependable alternative. Press Ctrl+1, select the Font tab, check Strikethrough, and choose OK.
- Windows shortcut: Ctrl+5.
- Mac shortcut: Command+Shift+X in Excel for Mac.
- Dialog method: Format Cells > Font > Strikethrough.
Keyboard shortcuts can be affected by keyboard layout, remote-desktop settings, or another application intercepting the key combination. If the shortcut does not work, use the dialog to confirm that the feature is available and apply it directly.
Find and Use the Strikethrough Checkbox
The checkbox is inside the cell-formatting dialog, rather than being a checkbox placed in the worksheet. Select the target cells, press Ctrl+1 on Windows, and open the Font tab. Under the font effects, select Strikethrough, then select OK. To clear it, reopen the same tab and clear the check mark.
The checkbox describes the formatting you are about to apply. It is not a separate setting for each character in the cell unless you first select text within the cell for partial formatting. If you open the dialog with a range selected, the chosen font effect is applied to that range. Be deliberate when selecting cells: choosing an entire column can change far more content than intended.
On a Mac, the dialog is available from the cell-formatting controls, and the keyboard shortcut differs as noted above. Excel for the web has a more compact interface and its ribbon commands can differ from desktop; use the available Home-tab font controls. If a command is not visible in your web version, opening the workbook in the desktop app gives access to the full Format Cells dialog.
Strike Through Only Part of a Cell’s Text
Excel desktop can format part of a text entry differently from the rest. Select the cell, enter edit mode by double-clicking it or pressing F2, and select the characters you want to change. Apply strikethrough to that text with the shortcut or the font-formatting controls. For instance, a cell could read “Call supplier; request quote” in appearance, with only “request quote” struck through.
Partial formatting is most useful for text typed directly into a cell. A cell that displays a formula result is not a reliable place to apply character-by-character formatting: the displayed text is generated from the formula, and the result may change when its inputs change. If you need separate formatting for different pieces of information, consider putting them in separate cells, where each part can be formatted and managed independently.
Automatically Strike Completed Tasks
To make task text strikethrough when a checkbox is selected, use conditional formatting. In versions of Microsoft 365 that support in-cell checkboxes, the checkbox cell contains a TRUE or FALSE value. Put checkboxes in A2:A20 and the corresponding task descriptions in B2:B20. Select B2:B20, then choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. With checkboxes in A2:A20 and task text in B2:B20, enter =A2=TRUE as the rule formula. It evaluates to TRUE for a checked box and FALSE for an unchecked one. Choose Format, select Strikethrough on the Font tab, and confirm the rule.
The relative row reference makes Excel check A2 for the formatting of B2, A3 for B3, and so on. If your checkboxes or task descriptions start in different rows or columns, adjust the reference to match the top row of the selected task range. The formatting changes as the checkbox value changes, but the task text itself remains intact.
Older worksheet checkbox controls are different from newer in-cell checkboxes. A Form Control checkbox may need to be linked to a worksheet cell before it produces a TRUE or FALSE value for a conditional-formatting rule. Right-click the control and use its formatting or control settings to identify its linked cell. Do not assume that every checkbox object is already linked to the cell beside it.
When Strikethrough Is Useful—and When It Is Not
Strikethrough works well as a lightweight status cue in lists, review sheets, and change logs. It lets a reader see both the original entry and the fact that it is no longer active. In a to-do list, for example, striking a completed task preserves the wording for reference; in a comparison sheet, it can indicate a discontinued option while leaving the row visible.
It is less suitable when a workbook needs a formal status that can be sorted, filtered, counted, or reported. A line through text is visual formatting, and Excel does not interpret it as “complete” in ordinary calculations. Keep a separate status column such as “Open” or “Done” when the status matters to summaries or workflows. You can then use conditional formatting to make completed rows appear struck through while retaining a clear, filterable status value.
For readability, do not rely on strikethrough as the only way to communicate an important status. Some readers may have difficulty distinguishing the line, and printed output or small screens can make it less obvious. Pair the formatting with a word, symbol, or dedicated status field when the meaning needs to be clear to everyone.
Remove It and Troubleshoot Formatting Problems
If text still looks struck through, select the affected cells and press Ctrl+5 on Windows, or clear the Strikethrough checkbox in Format Cells > Font. If the result is unexpected, check whether you selected the intended cells and whether only part of the cell text was formatted. A font effect can also be difficult to see at a small zoom level, so inspect the cell at a larger zoom or in the Font tab.
- The shortcut appears to do nothing: Try the Format Cells dialog. The keyboard layout, active edit mode, or another app may be interfering with the shortcut.
- The line returns after you remove it: Check Home > Conditional Formatting > Manage Rules. A rule may be applying strikethrough again when its condition is true.
- Only part of the text changes: The cell may contain character-level formatting. Select the entire cell, then apply or clear the effect for the whole entry.
- Newly entered text has the effect: The cell may have strikethrough formatting already, or you may be typing in a range with copied formatting. Clear the font effect or use Home > Clear > Clear Formats if you intend to remove all formatting from the selected cells.
Clearing formats removes more than strikethrough: it can also remove number formats, fills, borders, and other styling. Use the specific Font checkbox when you want to preserve the rest of the cell’s appearance.
Strikethrough Compared with Deleting or Hiding Data
Deleting a cell’s contents removes the value; strikethrough leaves it in place. Hiding a row or filtering it out changes what is currently displayed, while strikethrough leaves the entry visible. Those differences matter in shared workbooks: a struck-out item can still be found by searching, copied, included in formulas, or exported as data because its contents have not been removed.
If an entry is truly wrong and should not remain in the workbook, correct or delete the data rather than relying on visual formatting. If it is inactive but must be retained for audit or historical context, strikethrough can communicate that status, preferably alongside a date or status field. Formatting is not a substitute for data validation, access control, or a documented change history.
Frequently Asked Questions
Where is the strikethrough checkbox in Excel?
Press Ctrl+1 on Windows, open the Font tab, select Strikethrough, and choose OK. On a Mac, open the cell-formatting dialog from the ribbon or menu and use its Font options.
What is the Excel shortcut for strikethrough?
In Excel for Microsoft 365 on Windows, select the cell or text and press Ctrl+5. In Excel for Mac, the shortcut is Command+Shift+X. Use the Format Cells dialog if your keyboard or version behaves differently.
Does strikethrough delete the cell value?
No. It changes how the value looks, not the stored text or number. The content remains available to formulas, searches, copying, and other workbook operations.
Can Excel strike through a task automatically when I check a box?
Yes. Use a checkbox that supplies a TRUE or FALSE value, then create a conditional-formatting rule for the task cells and set its font to Strikethrough. Older Form Control checkboxes may need to be linked to a cell first.
Why does strikethrough keep coming back?
A conditional-formatting rule may be applying it again, or the cell may have copied formatting. Check the rules with Home > Conditional Formatting > Manage Rules, and inspect the Font tab for direct formatting.
Related
- Subscript in Excel: Shortcut and Formatting Steps
- Quick Forecast in Excel: Steps, Limits, and Practical Tips
- Excel Redo Shortcut: The Quick Key and When It Works
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Can’t Insert Row? Fix the Non-Empty Cells ErrorYes—Excel may refuse to insert a row when shifting cells down would push existing content or formatting past…
- Excel Scatter Plot: Select Data, Edit Series, and Fix AxesIn Excel for Microsoft 365 on Windows, select the columns containing your X and Y values, then choose…
- Excel Not Printing All Columns? Fix the Page SetupIf Excel is not printing all your columns, check the print area first, then set the worksheet to…
- Extract Year from Date in Excel: Fix Common ErrorsIf extracting a year from a date in Excel is not working, first check that the cell contains…
- Excel Filter Button Not Working? Fix Common CausesIf the Excel filter button is missing, greyed out, or not filtering the rows you expect, check that…
- Excel File Extension Repair Online: Fix Corrupt XLSXYes, you can repair a corrupt Excel file extension online using dedicated file repair websites, but the results…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.