Yes. In Excel for Microsoft 365 on Windows, select the cell or cells and press Ctrl+5 to apply strikethrough; press the same shortcut again to remove it. You can also open Format Cells with Ctrl+1 and select the Strikethrough option on the Font tab.
What strikethrough means in Excel
Strikethrough draws a horizontal line through text or numbers without deleting their contents. It changes the way a cell’s contents look, not the value stored in the cell. For example, crossing out an old task name can show that it is complete while preserving the task in the worksheet.
This distinction matters: strikethrough is not a deletion, a comment, or a special status that Excel understands automatically. A crossed-out item remains available to formulas, sorting, filtering, and search just as it was before. If a formula refers to a strikethrough value, the formatting alone does not change the formula’s result.
Excel applies strikethrough as a font format. It can affect the text in an entire cell, a selected range of cells, or a selected portion of text while editing a cell. The right method depends on whether you want a quick visual change, a repeatable rule, or only part of a cell crossed out.
Fastest method: use the keyboard shortcut
For a one-off change in desktop Excel on Windows, the shortcut is usually the quickest option:
- Select one cell or a range of cells. To format only a portion of a cell’s text, enter edit mode and select the characters first, as described below.
- Press Ctrl+5. The selected cell contents receive strikethrough.
- Press Ctrl+5 again on the same selection to toggle the formatting off.
The shortcut is a toggle, so it can both apply and remove the effect. If a selection contains cells with different formatting, using the shortcut can make the selection’s formatting more uniform. Check the result when working with a mixed range, especially if some cells already had strikethrough and others did not.
On Excel for Mac, the corresponding shortcut is generally Command+Shift+X. Keyboard shortcuts can vary with keyboard layout, Excel version, or other software that intercepts a key combination, so use the Format Cells method if the shortcut does not work. Windows users should use Ctrl+5, not the number 5 on the numeric keypad if that keyboard does not send the expected shortcut.
Use Format Cells for a visible setting
The Format Cells dialog is useful when you want to confirm the setting or cannot use the shortcut. On Windows, select the cell or range and press Ctrl+1. On a Mac, press Command+1 to open Format Cells. You can also open the dialog from the Font group on the Home tab by choosing its small dialog box launcher.
- Open the Font tab in the Format Cells dialog.
- Under Effects, check Strikethrough to apply it, or clear the checkbox to remove it.
- Choose OK to apply the change.
This route is handy when setting multiple font attributes at once, such as a font color and strikethrough. The checkbox reflects the selected cell or cells, but mixed formatting can make it unclear whether every cell has the same setting. If you need to format only one item in a complicated range, select that item separately and inspect the result.
Cross out only part of a cell’s text
Excel can format selected characters within a cell, rather than requiring the entire cell to be crossed out. This is useful for a note such as Replace old label with new label, when you want to cross out only the old label and leave the rest readable.
- Double-click the cell, or select it and press F2, to edit its contents.
- Drag across the characters you want to format in the cell, or use the arrow keys while holding Shift to select them.
- Press Ctrl+5 on Windows, or use Format Cells and turn on Strikethrough for the selected characters.
- Press Enter to finish editing the cell.
If you simply select the cell without entering edit mode, the shortcut affects the cell’s contents as a whole. Be careful not to replace or delete characters while selecting text; the formula bar can make long cell contents easier to inspect, but character-level editing still requires selecting the text itself. Partial formatting is a visual choice and does not split the cell into separate values.
Apply strikethrough automatically with conditional formatting
For a list that changes over time, conditional formatting can add strikethrough when a condition is met. For instance, a task list can show completed rows as crossed out based on a status column. Unlike manually applying the format, a conditional-formatting rule can update when the status changes.
Suppose task names are in A2:A100 and their statuses are in C2:C100. To cross out a task name whenever its row’s status is Done, select A2:A100 and choose Home > Conditional Formatting > New Rule. Choose Use a formula to determine which cells to format, then enter this rule:
=$C2="Done"
Choose Format, open the Font tab, check Strikethrough, and confirm the dialogs. The dollar sign fixes the status column at C while the row number adjusts for each task. The rule therefore checks C2 for the first selected task, C3 for the next, and so on. In this example, only the task-name cells in A2:A100 are formatted; selecting a wider range as the rule’s Applies To range would format more cells in each matching row.
Conditional formatting is useful when status is the source of truth, but it has practical limits. The effect depends on the rule and its range, and the underlying task text remains unchanged. If a row is no longer marked Done, its conditional strikethrough disappears. For a fixed record of what was crossed out at a particular time, manually applying formatting may be more appropriate. Review the rule’s Applies To range if new rows do not receive the formatting.
Excel for Mac and Excel for the web
Excel for Mac supports strikethrough through Format Cells, and its common shortcut is Command+Shift+X. The dialog can be opened with Command+1, then the Font tab and Strikethrough checkbox provide the same basic control. Menu placement and ribbon appearance can differ between Mac and Windows, but the underlying font effect is the same.
Excel for the web also supports strikethrough formatting. Select the cells and look for the Strikethrough command in the Font controls on the Home tab; the command may be grouped or less visible when the browser window is narrow. The web interface and keyboard handling can differ from desktop Excel, so use the visible ribbon command if a desktop shortcut is intercepted or unavailable. If you are editing a workbook in a browser and do not see the option, expand the ribbon or check the additional font controls.
When a workbook moves between desktop and web versions, the formatting generally remains part of the workbook. However, ribbon layout and shortcut behavior are interface details, not a guarantee that every browser, keyboard layout, or version presents the same controls in the same place.
When strikethrough is useful—and when it is not
Strikethrough is a compact visual cue for items that are completed, replaced, or no longer current but still worth keeping in view. Common examples include completed checklist entries, superseded draft wording, discontinued products in a planning sheet, or a price that has been replaced by a new one. Keeping the text visible can preserve context that would be lost if you deleted it.
It is less suitable as the only way to record important workflow information. A person looking at the sheet can recognize the crossed-out text, but a formula or data process does not treat it as completed. A filter for completed tasks should use a status value such as Done in a separate column, not depend on font formatting. This makes completion explicit and easier to count, sort, or report.
Consider readability, too. A line through small text can make a dense worksheet harder to scan, especially when combined with low-contrast font colors. For shared workbooks, a clear status column and a consistent formatting convention can help people understand what a crossed-out entry means without relying on guesswork.
Common problems and how to fix them
- Ctrl+5 appears to do nothing: Confirm that Excel has focus and that you selected the intended cell. Try the Format Cells dialog. A keyboard layout or another program may also intercept the shortcut.
- The line crosses out the whole cell: That is expected when the cell is selected normally. Enter edit mode and select the specific characters if only part of the text should be formatted.
- Some cells change and others do not: A range can contain mixed formatting, or a conditional-formatting rule may control the visible result. Inspect a cell individually and review Conditional Formatting rules.
- The effect returns after you remove it: Conditional formatting may be applying strikethrough again. Review the rules for the selected range and adjust or remove the relevant rule.
- Strikethrough does not affect a calculation: Formatting does not change a cell’s value. Use a status field or another data value when a formula needs to identify completed or obsolete records.
It is also worth checking that you are changing the correct workbook and range. If the worksheet is protected, Excel may prevent formatting changes depending on the protection settings. In that case, use an authorized unprotected sheet or ask the workbook owner to adjust the permissions rather than assuming the shortcut is broken.
Remove, copy, and manage the formatting
To remove strikethrough from a cell, select it and press Ctrl+5 on Windows or Command+Shift+X on Mac. You can also open Format Cells and clear the Strikethrough checkbox. If the line is controlled by conditional formatting, removing direct formatting may not change what you see; edit the rule or change the value that triggers it.
To reuse the same formatting elsewhere, copy the formatted cell and use Paste Special for formats, or use Format Painter on the Home tab. These methods can copy other formatting along with strikethrough, so inspect the destination if you only wanted the line effect. Format Painter is convenient for a small number of destinations; for repeated automatic formatting based on a status, a conditional-formatting rule is usually easier to maintain.
To clear every format from a cell, use Home > Clear > Clear Formats. This removes more than strikethrough: it also clears other cell formatting such as font choices, fills, borders, and number formats. Use it only when you intend to reset the cell’s appearance, not when you want to remove one effect and preserve the rest.
Frequently Asked Questions
What is the shortcut for strikethrough in Excel?
In Excel for Microsoft 365 on Windows, select the cell or text and press Ctrl+5. On Mac, the common shortcut is Command+Shift+X. The Format Cells dialog is an alternative if a shortcut does not work.
Can I strikethrough only one word in an Excel cell?
Yes. Enter edit mode in the cell, select the word or characters, then apply strikethrough. Selecting a cell without selecting text applies the effect to the cell’s contents as a whole.
Can Excel cross out a row automatically when I mark it complete?
Yes. Use conditional formatting with a rule based on a status cell, and set Strikethrough in the rule’s Font format. The rule changes the appearance when its condition is true; it does not change or delete the row’s data.
Does strikethrough delete a value or exclude it from formulas?
No. Strikethrough is visual formatting. The value remains in the cell and is still available to formulas, sorting, and filtering unless you separately change the data or the formula logic.
How do I remove strikethrough in Excel?
Select the formatted cell and use the same toggle shortcut—Ctrl+5 on Windows or Command+Shift+X on Mac—or clear Strikethrough in Format Cells. If conditional formatting controls it, change the rule or its trigger instead.
Related
- Billing Invoice Template Excel: Setup and Key Details
- Can You Convert Notepad to Excel? A Practical Guide
- Can You Auto Capitalize in Excel? Methods That Work
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Consolidate Data in Excel: Methods and StepsTo consolidate data in Excel for Microsoft 365 on Windows, choose Data > Consolidate, select a summary function…
- How to Insert a Citation Placeholder in WordTo insert a citation placeholder in Word for Microsoft 365 on Windows, place the cursor where the citation…
- VLOOKUP Google Sheets Tutorial: Formulas, Examples & FixesIn Google Sheets, VLOOKUP searches the first column of a table and returns a value from a column…
- How to Group Rows in Excel With Plus Signs at the TopTo put a plus sign above Excel’s column headings, select the columns you want to fold away, then…
- Excel Protect Sheet Greyed Out? Causes and FixesIn Excel for Microsoft 365 on Windows, Protect Sheet is usually greyed out because Excel cannot currently edit…
- Employee Work Schedule Template Excel: Free Setup GuideYes—free employee work schedule templates are available to use in Excel, and you can also create a simple…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.