In Excel for Microsoft 365 on Windows, select the cell or range and press Ctrl+5 to apply strikethrough; press Ctrl+5 again to remove it. On a Mac, use Command+Shift+X. The shortcut changes the appearance of the selected content—it does not delete the cell’s value.
What the Strikethrough Shortcut Does
Strikethrough draws a horizontal line through the characters in a cell. It is a formatting effect, similar to bold or italic, and is often used to show that an item is complete, a price is no longer current, or a note should be treated as superseded. The text or number remains in the cell, and Excel can still use its value in calculations, searches, and formulas.
On Windows, Ctrl+5 toggles the effect for the selected cell or cells. If some selected cells already have strikethrough and others do not, applying the shortcut may leave the selection with mixed formatting, depending on the selection and Excel’s toggle behavior. Check the result if you are formatting a mixed range rather than a uniform group.
The shortcut is not the same as crossing out text with a line shape, adding a border, or deleting a value. It is character formatting stored in the cell’s formatting settings. This distinction matters when filtering, copying, printing, or using the data in another application.
Apply It to One Cell or a Range
- Click a cell, or drag across the cells you want to format. To select a whole row or column, click its row number or column letter.
- On Windows, press Ctrl+5. On a Mac, press Command+Shift+X.
- Look at the selected cells to confirm that the line appears through their contents.
You can also select a nonadjacent group by holding Ctrl while clicking separate cells on Windows, then apply the shortcut once. On a Mac, use the corresponding Command key to add separate cells to the selection. Be careful when using a shortcut on a large selection: it affects every selected cell, not just the cell that appears active.
If the selection includes blank cells, applying strikethrough may still set their font formatting. That may become visible if you later type in those cells. For a tidy worksheet, select only the cells that need the effect or clear the formatting from unused cells afterward.
Use the Ribbon or Format Cells Dialog
If you cannot remember the shortcut, or prefer to confirm the setting visually, use the Format Cells dialog. Select the cells, open the Home tab, and in the Font group select the small dialog box launcher. In the dialog, open the Font tab, select the Strikethrough checkbox, and choose OK. To remove the line, repeat the steps and clear the checkbox.
You can also right-click the selection and choose Format Cells, then use the Font tab. The dialog is useful when you want to check several font effects at once, or when a keyboard shortcut is unavailable. In the desktop version, Ctrl+1 on Windows opens Format Cells; on a Mac, Command+1 opens the corresponding formatting dialog. The exact dialog presentation can vary by platform.
Excel for the web has a more compact ribbon and may not expose the desktop dialog in the same way. If the shortcut does not work there, select the cells and look for the strikethrough control in the Home tab’s font options, or open the available font-formatting menu. Browser and keyboard settings can also affect shortcuts, so the ribbon is a dependable alternative.
Strikethrough Part of a Cell’s Text
Sometimes only a word or phrase should be crossed out while the rest of the cell remains unchanged. This is different from formatting the entire cell: Excel must be in text-editing mode, and only the characters you select should receive the effect.
- Double-click the cell, or select it and press F2, to edit its contents.
- Select the characters to format within the cell’s text. You can also edit the text in the formula bar and select the relevant characters there.
- Use the Font options or Format Cells dialog to apply strikethrough, then confirm the edit.
Partial-character formatting is not available in the same way for every kind of cell content. A formula cell displays a calculated result, so its displayed characters are not ordinary text that can be independently formatted through the formula result. If you need to cross out only part of a formula’s displayed result, consider changing the source data or using separate cells for the separate pieces of text.
For example, a cell containing the manually entered text Old plan / New plan could have only Old plan crossed out to make a revision clear. If the whole cell is selected before applying the format, however, both phrases will be struck through. Check that you have selected the characters rather than merely placing the cursor in the cell.
How to Remove Strikethrough
For a selected cell or range, press Ctrl+5 on Windows or Command+Shift+X on Mac again to toggle the formatting off. You can also reopen Format Cells and clear the Strikethrough checkbox. If the shortcut does not seem to remove the line, verify that you selected the cell that actually contains the formatting and that the line is not coming from a different source, such as a drawn shape or a conditional format.
Clearing all formatting is another option, but it removes more than strikethrough. On the Home tab, use Clear in the Editing group and choose Clear Formats to remove formatting from the selected cells while keeping their contents. This can also remove number formats, fills, borders, and other font effects, so it is usually too broad if the only goal is to remove one line-through effect.
Shortcut Problems and Common Confusions
- Ctrl+5 does something unexpected: Confirm that you are using the number 5 key, not a different key combination. If your keyboard layout or hardware intercepts the shortcut, use Format Cells instead.
- The line does not show: Make sure the intended cell or text is selected, and inspect its Font settings. A small cell, narrow column, or display scaling can make formatting harder to notice.
- The whole cell changed: That is expected if the cell itself was selected. To format only part of manually entered text, enter edit mode and select the characters first.
- The line returns after changing a value: Check whether conditional formatting is applying the effect based on a rule. A conditional format can change the appearance when a cell meets specified criteria.
- You thought the value was deleted: Strikethrough is visual only. The underlying value remains available to formulas and other spreadsheet operations.
It is also easy to confuse strikethrough with a horizontal border. A border sits along an edge of a cell, while strikethrough passes through the characters. If the line crosses the text but the font dialog shows the option is off, look for a shape layered over the worksheet or investigate conditional formatting.
When Strikethrough Is Useful—and Its Limits
Strikethrough works well for lightweight visual status marking in lists, draft schedules, meeting notes, or price comparisons. For example, a task list can retain completed items for context while making unfinished items easy to spot. In a change log, the old wording can remain visible while a replacement is added nearby.
It is not a substitute for a dedicated status field when a worksheet is used for tracking, reporting, or shared workflows. A status column with values such as Not started, In progress, and Complete is easier to filter, count, validate, and summarize than font formatting alone. Formulas generally evaluate cell values rather than whether a word is struck through, so a formula will not automatically treat a crossed-out task as completed.
Strikethrough can also be less clear for readers using assistive technology or viewing a printed page at small scale. When the meaning is important, include an explicit label such as Complete or Superseded instead of relying only on the line. That keeps the information understandable if formatting is lost during copying, export, or conversion.
Frequently Asked Questions
What is the shortcut for strikethrough in Excel?
On Windows, select the cell or cells and press Ctrl+5. On a Mac, use Command+Shift+X. If the shortcut is unavailable, use the Font tab in Format Cells.
Does Ctrl+5 delete the cell contents?
No. It toggles strikethrough formatting. The content remains in the cell and can still be used by formulas.
How do I strikethrough only part of a cell?
Edit the cell, select the characters you want to format, and use the Font options to apply strikethrough. Selecting the cell without selecting its text formats the entire cell’s contents.
Can Excel automatically cross out completed tasks?
Yes. You can use conditional formatting with a rule based on a status value and set the rule’s font effect to strikethrough where that option is available. A separate status column is often clearer and easier to filter than manually applying formatting.
Why does strikethrough remain after I clear the cell?
Cell formatting can remain after you delete a value. Select the cell and turn strikethrough off in Format Cells, or use Home > Clear > Clear Formats if you intend to remove all formatting, not just the line.
Related
- Microsoft Excel Zoom Options: Change Worksheet View
- Microsoft Excel Zoom Out: Ways to Shrink the View
- Microsoft Excel vs Apple Numbers: Which Should You Use?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Prevent Duplicates in Google Sheets: 3 Reliable MethodsTo prevent duplicate entries in Google Sheets, select the cells where new values will go, open Data >…
- Excel Workbook History: View, Compare, and Restore VersionsTo view Excel workbook history, open a workbook saved in OneDrive or SharePoint and choose File > Info…
- Excel Column Letters: How to Find or Convert Them EasilyIn Excel, a column letter is the label at the top of a worksheet column: A is the…
- Excel Text on a New Line in the Same Cell: A GuideYes. In Excel for Microsoft 365 on Windows, edit the cell, place the cursor where the next line…
- Excel Hide Columns Toggle Button: Options That WorkExcel for Microsoft 365 on Windows does not include a built-in ribbon button that alternates between hiding and…
- How to Merge Cells in Google Sheets Without Losing DataTo merge cells in Google Sheets, select the adjoining cells, then choose Format > Merge cells and pick…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.