In Excel for Microsoft 365 on Windows, select the cell or range and press Ctrl+5 to apply strikethrough; press the same keys again to remove it. The line changes the text’s appearance, but it does not delete the value or affect calculations.
The Windows shortcut and what it does
Ctrl+5 is Excel’s built-in keyboard shortcut for toggling strikethrough formatting. Select one cell, a group of cells, or an entire row or column, then press the shortcut. The text in the selected cells appears with a line through it. Press Ctrl+5 again to switch the formatting off.
The shortcut applies formatting to cells, not an instruction to remove their contents. If a crossed-out entry contains a number, Excel still treats that number as present. A formula such as SUM can continue to include it, and sorting or filtering will not automatically treat it as completed or excluded. Strikethrough is a visual cue, not a data-status feature.
For example, if a task list has “Order labels” in A2, selecting A2 and pressing Ctrl+5 draws a line through the task. The text remains in A2, so you can still edit it, search for it, or refer to it in a formula. If the task should no longer count toward a total, change the underlying data or formula logic rather than relying on the line.
Apply strikethrough from the ribbon
If you cannot remember the shortcut, or prefer using the mouse, the Format Cells dialog provides a clear alternative in the Windows desktop app:
- Select the cell or cells you want to format.
- On the Home tab, open the Font dialog box using the small dialog box launcher at the lower-right corner of the Font group.
- In the Effects section, select Strikethrough, then choose OK.
You can also open Format Cells by right-clicking the selection and choosing Format Cells. In the dialog, use the Font tab and select the Strikethrough effect. To remove it, reopen the same dialog, clear the checkbox, and confirm. The Home tab’s Font group may also show a strikethrough button, depending on the ribbon layout and window size; the dialog is the dependable route when the button is not visible.
The dialog is useful when you want to inspect formatting rather than toggle it quickly. It also lets you combine strikethrough with other font settings, such as font style or color, in one place. The shortcut is usually faster for routine edits; the dialog is easier to explain to someone unfamiliar with Excel’s key combinations.
Format a range, row, or column
Before pressing Ctrl+5, check the selection outline. Excel applies the effect to the selected cells, so the same shortcut can format one entry or many. To select a contiguous range, drag across it or click the first cell, hold Shift, and click the last. For separate cells, hold Ctrl while selecting additional cells, then use the shortcut. On a large sheet, you can click a row number or column letter to select the full row or column.
Consider a project tracker with status notes in B2:B30. If you select the entire range and press Ctrl+5, every cell in that range receives the effect—including blank cells, which may matter if you later enter text there. To strike through only completed items, select just those task cells. A quick check of the selection helps prevent formatting unrelated notes or headings by mistake.
Strikethrough belongs to the cell’s formatting. Copying a formatted cell normally copies its formatting too, while Paste Special can be used when you want to control what is copied. If you copy the text into another application, whether the line carries over depends on the destination and paste method.
Strike through only part of a cell’s text
Ctrl+5 is most straightforward when you want to format the contents of entire cells. Sometimes a cell contains a sentence where only one word or phrase should be crossed out. For partial text formatting, edit the cell, select the specific characters, and apply Strikethrough through the font-formatting controls. One approach is to double-click the cell, highlight the characters in the cell, then use the Font dialog to select the effect.
Partial formatting is different from formatting the whole cell: the effect is attached to selected characters within the cell’s text. It is suited to a short note such as “Draft: old wording; revised wording,” but it is awkward to maintain across a large table. If a workbook needs to track which words or phrases are obsolete, separate fields or a revision-history column are often easier to search and manage than character-level styling.
Use a conditional formatting rule for changing data
Manual strikethrough stays as you set it until you change the formatting. If the crossed-out appearance should respond automatically to a status value, consider conditional formatting. For example, a task list might have task names in column A and statuses such as Done or Open in column B. A rule can format the task name when its corresponding status is Done.
To create a rule in Excel for Microsoft 365 on Windows, select the task-name cells, choose Home > Conditional Formatting > New Rule, and choose the rule type that lets you use a formula to determine which cells to format. Enter a formula that refers to the status cell for the first selected row, then choose Format, open the Font tab, and select Strikethrough. The rule’s formula and range must match the layout; for example, a rule for A2:A20 that checks B2 can use a relative row reference so Excel evaluates the status in column B for each task.
This approach makes the visual mark follow the status instead of requiring someone to remember to format a task manually. If the status changes from Done back to Open, the conditional format no longer applies. Conditional formatting does not erase the task or change its value. Take care when editing rules: the Applies to range determines which cells receive the appearance, and an incorrect range can strike through headings or unrelated entries.
Use ordinary formatting when you want a lasting, hand-applied mark. Use conditional formatting when the appearance should be driven by data and update as that data changes. If readers need to understand the status without relying on font styling, keep the explicit status field as well.
Windows, Mac, and Excel for the web
The shortcut in this article is for Excel’s Windows desktop app. In Excel for Microsoft 365 on Mac, the usual equivalent is Command+Shift+X. Keyboard mappings can vary with the app version, keyboard layout, or system settings, so if that combination does not work, use the Font controls on the Home tab or open the Format Cells dialog and select Strikethrough.
Excel for the web runs in a browser, where keyboard shortcuts can interact with browser commands or differ from desktop shortcuts. If Ctrl+5 does not produce the formatting you expect, use the Home tab’s Strikethrough control if it is shown, or open the available font-formatting options. The ribbon is also the simplest option when you are working on a device with a different keyboard layout. The workbook’s visual formatting remains the key result; the exact route to apply it can depend on the app.
Common shortcut problems
If Ctrl+5 appears to do nothing, first confirm that Excel has focus and that you have selected a cell or range. A cell may be in edit mode, with the insertion point inside its text; finish editing or cancel the edit before trying a cell-level shortcut. On some keyboards, the number row and numeric keypad behave differently, and laptop function or modifier settings can also affect key combinations.
Check these points before assuming the workbook is broken:
- Click the worksheet cell area, select the intended cells, and try Ctrl+5 again.
- Use the Font dialog to see whether Strikethrough is already enabled or to apply it directly.
- Confirm that you are in Excel rather than another program that handles the same keys differently.
- If using Excel for the web or Mac, try the app’s ribbon controls or the platform-specific route instead.
- Check whether a cell’s appearance is controlled by conditional formatting; a rule can override or reapply visual formatting based on its conditions.
One confusing case is mixed formatting. A selection can contain cells with different font effects, so a single toggle may not make the whole selection look the way you expect. Select a smaller range and inspect the Font dialog when the result is unclear. Also remember that a cell’s font color, fill, or other effects can make a strikethrough hard to see even when it is applied.
Strikethrough compared with deleting or hiding data
Strikethrough is useful when the original entry should remain visible—for example, a completed checklist item, a superseded estimate, or a line removed during review. Deleting a cell removes its contents, while clearing formatting removes visual styling but leaves the contents. Hiding a row or filtering it out changes what is displayed, but does not mean the data has been deleted.
Choose the method that matches the purpose. For a completed task, keep the text and add a status such as Done; strikethrough can provide an extra visual cue. For a discarded value that should not be used, remove or replace it and check any formulas that refer to it. For a historical record, keep the old and new values in separate columns or a change log. This distinction avoids a common misconception: a line through a number does not make Excel ignore that number.
Frequently Asked Questions
What is the quick key for strikethrough in Excel?
In Excel for Microsoft 365 on Windows, select the cell or range and press Ctrl+5. The shortcut applies strikethrough or removes it. On Mac, the usual equivalent is Command+Shift+X.
Does strikethrough delete a cell’s contents?
No. It changes how the cell text looks, but the value remains in the worksheet. Formulas can still use the value, and you can edit or copy it as before.
How do I remove strikethrough in Excel?
Select the affected cell or range and press Ctrl+5 again in Windows Excel. Alternatively, open Format Cells, go to the Font tab, clear Strikethrough, and choose OK.
Can I strikethrough only one word in a cell?
Yes. Edit the cell, select the characters you want to format, then use the font-formatting controls to turn on Strikethrough. The standard shortcut is intended for quick cell formatting; the dialog gives you a way to apply the effect to selected text.
Will Excel exclude a crossed-out number from a total?
No. Formatting alone does not change the value or how a formula treats it. If a number should no longer count, change the data or adjust the formula’s criteria; do not rely on strikethrough to alter calculations.
Can strikethrough appear automatically when a task is marked Done?
Yes. A conditional formatting rule can apply the effect based on a status cell. Set the rule’s range and condition carefully, and keep the status value itself because the line is only a visual indicator.
Related
- Microsoft Excel Timesheet Template: Free Options
- Microsoft Excel Budget Tracking Template: How to Use It
- Microsoft Excel Time Tracking Template: Setup and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Format Cells Shortcut: Quick Keys for Windows and MacIn Excel for Microsoft 365 on Windows, press Ctrl+1 to open the Format Cells dialog for the selected…
- Interpolate in Excel: Does Solver Help?You can interpolate in Excel with a worksheet formula; you do not need Solver for ordinary interpolation. Excel…
- Protect a Sheet in Excel From Viewing: What Actually WorksTo keep a worksheet out of casual view in Excel for Microsoft 365 on Windows, hide its tab,…
- How to Create Name Labels in Word: A Step-by-Step GuideTo create a sheet of name labels in Microsoft Word, go to Mailings > Start Mail Merge >…
- Excel Box Plot With Data Points: How to Show Every ValueYes. In Excel for Microsoft 365 on Windows, select the box-and-whisker chart, open Format Data Series, and under…
- How to Add Page Numbers to Different Sections in WordTo add page numbers to sections in Word, insert a section break where the numbering or layout should…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.