To put strikethrough in Excel for Microsoft 365 on Windows, select the cell or cells and press Ctrl+5; press the same shortcut again to remove it. You can also use the Font settings or the Strikethrough button on the Home tab. Strikethrough changes how cell text looks—it does not delete the text or change its value.
Use it to mark a task complete, show an item that is no longer current, or indicate a price that has been replaced. You need an Excel workbook and the cells you want to format. The steps below cover the Windows desktop app first, with notes for Mac and Excel for the web where the controls differ.
What You’ll Need
- Excel for Microsoft 365 on Windows, or Excel for Mac or the web if you are following the platform notes.
- A workbook containing the cell or text you want to mark. Save a copy first if you are about to make broad changes to a shared or important sheet.
- Permission to edit the sheet. A protected worksheet may prevent formatting changes unless you have the appropriate access.
Step-by-Step
- Select the target cell or range. Click a cell to strike through all of its displayed text. To format several cells, drag across them, or click the first cell and Shift-click the last. You can also select a whole row or column by clicking its heading. If you select multiple cells, the formatting applies to each selected cell, including blank cells in the range.
- Use the Windows shortcut. Press Ctrl+5. The selected cell text should now have a line through it. This shortcut toggles the formatting: pressing Ctrl+5 again removes the line. Check that you have selected the intended range before using the shortcut, especially if the workbook contains important data.
- Or use the Home ribbon. With the cells selected, open the Home tab and look in the Font group for the Strikethrough button, shown as letters with a line through them. Click it to apply the effect. Depending on the ribbon width, you may need to expand the Font group or open its additional options to see the control.
- Or use Format Cells for a clear checkbox option. Select the cells and press Ctrl+1 to open Format Cells. Choose the Font tab, select the Strikethrough checkbox under Effects, and click OK. To remove the effect, reopen the same dialog, clear the checkbox, and click OK. This is useful when you want to inspect the current setting rather than toggle it without seeing its state.
- Check the result in the worksheet. Click another cell or press Enter to leave the selection. Confirm the line appears through the intended text and that the cell value is still present. If the line is hard to see, widen the column or increase the zoom temporarily; the formatting itself does not require changing the font size.
To strike through only part of a cell’s text: double-click the cell, or select it and press F2, to edit the cell contents. Use the mouse or keyboard to select just the characters you want to format, then apply strikethrough using the Font dialog or the appropriate shortcut. Press Enter to commit the edit. This character-level formatting works for text entered directly in a cell; it does not let you format only part of the displayed result of a formula.
On a Mac: select the cell or text and use Command+Shift+X to toggle strikethrough in Excel for Mac. You can also use the Home tab’s Font controls or open Format Cells from the Format menu and select the Font tab. Keyboard shortcuts can vary with the Mac keyboard layout and Excel version, so use the menu or ribbon control if the shortcut is intercepted by macOS or does not work.
In Excel for the web: select the cell, open the Home tab, and click the Strikethrough control in the Font area. If the compact ribbon hides it, expand the ribbon or open the additional Font options. The browser may reserve some keyboard shortcuts, so the on-screen control is the dependable method. The available commands can vary slightly with the web interface and account.
Common Mistakes
- Selecting the wrong range. Excel applies formatting to the current selection, not necessarily just the cell you last edited. Look at the selection outline before pressing Ctrl+5. If an entire row or column is selected, every cell in it may receive the effect.
- Expecting the shortcut to delete or cross out only the value’s meaning. Strikethrough is visual formatting. It does not clear a cell, exclude a number from a calculation, or mark a record as deleted for formulas. If a calculation should ignore an item, use an appropriate data or formula rule as well as any visual marking.
- Pressing Ctrl+5 in the wrong context. The shortcut toggles formatting for the selected cells or selected characters. If you are typing in a cell, the keystroke may be handled differently depending on the editing state. Finish the edit, select the cell, and try again, or use the ribbon.
- Applying formatting to formula output and expecting partial control. You can strike through the entire cell that displays a formula result. However, Excel cannot apply character formatting to only part of a formula’s calculated result using ordinary cell formatting. If partial formatting is essential, consider changing how the information is displayed or entered.
- Using color or a line shape as a substitute without considering the difference. A manually drawn line can shift when rows or columns change and does not behave like text formatting. The built-in effect is usually more stable and can be toggled or cleared through Font settings.
- Assuming formatting changes the source data. A strikethrough does not update a status field or communicate a structured state to other users and tools. For workflows, keep a separate status column such as Complete or Retired, and use strikethrough only as a visual cue.
Tips
- Use the shortcut for repeated edits. Ctrl+5 is quick when you are marking individual cells or small ranges. For a larger selection, pause to verify the highlighted area first, then apply the shortcut once.
- Keep a consistent convention. Decide what strikethrough means in your workbook—for example, completed tasks or discontinued items—and explain it in a note or legend. Avoid using it for several unrelated meanings on the same sheet.
- Pair the appearance with a status value. A separate status column helps people filter, sort, and understand the data, while strikethrough provides a quick visual signal. It also helps when someone views the workbook in a system that does not display the formatting clearly.
- Use Format Cells when checking existing formatting. Ctrl+5 is a toggle, so you may not know the current state at a glance. The Font tab in Format Cells shows whether the Strikethrough box is selected for the active cell or selection.
- Copy formatting carefully. Copying and pasting a formatted cell can carry strikethrough along with other formatting. If you need the value but not the appearance, use Paste Special and choose a values-only option, or clear the formatting in the destination.
- Know how to remove it. Select the affected cells and press Ctrl+5 again, or clear the Strikethrough checkbox in Format Cells. Avoid using Clear All unless you also want to remove other cell contents, comments, and formatting; use the specific formatting control instead.
Troubleshooting
Ctrl+5 does nothing: First click a worksheet cell so Excel has focus, then try the shortcut again. Check that you are using the number 5 key, not relying on a numeric keypad key that may behave differently on your keyboard. If you are editing a cell, press Enter or Esc to leave edit mode, select the cell, and retry. On Mac or in a browser, use the platform-specific shortcut or the Home ribbon button instead.
The line appears on the wrong cells: Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then select the intended cells and reapply the formatting. Undo is useful for a recent accidental action, but if other edits have happened since, use Format Cells to inspect and correct the affected range instead of undoing unrelated work.
The shortcut removes strikethrough instead of adding it: That means the selected cells already had the effect. Press Ctrl+5 once more to restore it, or open Format Cells and check the Strikethrough box. The shortcut is a toggle, not a one-way apply command.
The ribbon button is missing: Maximize the Excel window or expand the ribbon, because a narrow window can hide commands in the Font group. You can also open Format Cells with Ctrl+1 on Windows and use the checkbox on the Font tab. In Excel for the web, expand the Home ribbon or look in its additional Font options.
You cannot change the formatting: The worksheet may be protected, the workbook may be read-only, or you may have view-only access. Check the Review tab for sheet-protection controls, ask the workbook owner for editing permission, or save an editable copy if policy allows. Do not remove protection on a shared file unless you are authorized to do so.
The line is difficult to see or seems absent: Confirm that the cell contains visible text and that the cell is not displaying a blank formula result. Try selecting the cell and checking Format Cells > Font to see whether Strikethrough is enabled. Also check the font color, cell fill, zoom, and column width; these can affect visibility without changing the strikethrough setting.
Frequently Asked Questions
What is the shortcut for strikethrough in Excel?
In Excel for Microsoft 365 on Windows, select the cell or range and press Ctrl+5. The shortcut toggles strikethrough on or off. On Mac, Command+Shift+X is the usual equivalent; use the ribbon if the shortcut does not work in your setup.
How do I remove strikethrough in Excel?
Select the affected cell or cells and press Ctrl+5 on Windows. If the formatting state is unclear, open Format Cells with Ctrl+1, go to Font, clear the Strikethrough checkbox, and click OK. Removing the effect leaves the cell’s value intact.
Can I strikethrough only some words in a cell?
Yes, when the cell contains text entered directly. Edit the cell, select the specific characters, and apply strikethrough to that selection. You cannot apply character-level formatting to just part of the displayed result produced by a formula through normal cell formatting.
Does strikethrough affect formulas or calculations?
No. It changes the visual appearance only. A crossed-out number remains in the cell and is still included in formulas such as SUM unless the formula or data is changed to exclude it.
Can I use strikethrough in Excel for the web?
Yes. Select the cell and use the Strikethrough control on the Home tab, expanding the ribbon or Font options if needed. Browser shortcuts can conflict with Excel shortcuts, so the ribbon is a reliable alternative.
Can conditional formatting apply strikethrough automatically?
Excel’s standard conditional-formatting rule editor does not offer strikethrough as a font effect. It can format things such as font color, fill, and borders. For a rule-driven strikethrough effect, a VBA solution or another workbook design may be needed; consider whether a status column and a visible color cue would meet the same need.
Related
- Insert an Image in an Excel Comment Box or Note
- How to Insert an Image in Excel From a Link in Microsoft 365
- How to Insert an Image in an Excel Cell and Make It Fit
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Access Database Import from Excel: Steps and TipsTo import an Excel worksheet into Microsoft Access for Microsoft 365 on Windows, open the database, choose External…
- Column J Number in Excel: How to Find and Use It EasilyColumn J is column number 10 in Microsoft Excel. Excel counts columns from A as 1, so the…
- 2 Criteria Conditional Formatting in Excel: Two MethodsIn Excel for Microsoft 365 on Windows, select the cells to format, choose Home > Conditional Formatting >…
- How to Calculate a Percentage of a Number in ExcelTo get a percentage of a number in Excel, multiply the number by the percentage: enter the number…
- How to Freeze an Entire Row in Excel While ScrollingTo keep the first row visible while you scroll, select View > Freeze Panes > Freeze Top Row.…
- Excel Compare Two Sheets Side by Side: Practical MethodsTo view two Excel sheets beside each other, open both views, then choose View > View Side by…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.