Excel Strikethrough Shortcut: How to Remove It Quickly

How-to basics · Updated November 20, 2026

To remove strikethrough in Excel for Microsoft 365 on Windows, select the affected cell or range and press Ctrl+5. This shortcut toggles strikethrough on or off, so if the selected cells contain a mix of formatting, check the result and use the Format Cells dialog to make sure strikethrough is off. You do not need to change the cell’s contents.

What You’ll Need

  • An Excel workbook open in the desktop version of Microsoft Excel.
  • The cell, range, row, or column whose text appears crossed out. If you are unsure which cells are affected, you can select a larger range and inspect it before changing anything.
  • For the shortcut method, a Windows keyboard. Mac and Excel for the web instructions are included below.

Step-by-Step

  1. Select the cells with the crossed-out text. Click one cell to change just that cell. To select a continuous range, click and drag across it, or click the first cell, hold Shift, and click the last cell. To select several separate cells or ranges, hold Ctrl while clicking each one. You can also click a row number or column letter if you intend to change every cell in that row or column. Be careful with a whole-row or whole-column selection if other cells may have intentional formatting.
  2. Press Ctrl+5 once. Keep Ctrl held down, tap 5 on the number row of the keyboard, and then release both keys. On many Windows keyboards, Ctrl+5 works with the regular number-row key; if it does not, try the 5 on the numeric keypad or use the dialog method below. Do not press Ctrl and the plus key: that is a different Excel shortcut.
  3. Inspect the selected cells. The strikethrough line should disappear. The shortcut is a toggle: if a cell did not have strikethrough before, Ctrl+5 can apply it instead. If the selection had mixed formatting, the result may not be the same for every cell, so look over the full selection rather than assuming that one keystroke removed every line.
  4. Use Format Cells when you want to confirm the setting. With the target cells selected, press Ctrl+1 to open the Format Cells dialog. Choose the Font tab, find the Effects area, and clear the Strikethrough checkbox. Click OK. This explicitly turns the setting off for the selected cells instead of relying on a toggle. If the selection contains different font effects, the checkbox may not show a simple checked or unchecked state; select smaller groups or individual cells to inspect and correct them.
  5. Use the ribbon if you prefer not to use a shortcut. Select the cells, open the Home tab, and click the small dialog box launcher in the lower-right corner of the Font group. In the Format Cells dialog, go to Font, clear Strikethrough under Effects, and click OK. The ribbon does not provide a separate large strikethrough-off button; the Font dialog is the dependable place to turn the effect off directly.
  6. Save the workbook after checking the change. Press Ctrl+S, or choose File > Save. If the workbook is shared, check that you are editing the intended file and that your changes have synced before closing it.

On a Mac: Select the cells and press Command+Shift+X to toggle strikethrough in Excel for Mac. The Format Cells route is also available: open Format Cells, choose Font, clear Strikethrough, and confirm. Keyboard layouts and Excel versions can differ, so use the dialog if the Mac shortcut does not respond as expected.

In Excel for the web: Select the cells and try Ctrl+5 on Windows or Command+Shift+X on Mac. Browser and keyboard settings can affect shortcut handling. If the keys do not work, use the formatting controls on the Home tab or open the cell-formatting options available in your version of Excel for the web. Some desktop dialog controls may not be present in the web interface.

Common Mistakes

  • Pressing the toggle without checking the current state. Ctrl+5 does not mean remove only; it switches strikethrough. If you press it on text that is not crossed out, you add the effect. Use Format Cells and clear the checkbox when the intended result must be unambiguous.
  • Selecting the wrong cells. The shortcut acts on the current selection. If only one cell is active, only that cell changes; if an entire column is selected, the change may affect many cells. Check the highlighted selection before using the shortcut, especially in a shared or carefully formatted worksheet.
  • Confusing strikethrough with a border or line character. A line through text is usually a font effect, but a bottom border, a drawn line, or a character such as a hyphen can look similar. Ctrl+5 changes the font effect, not a border or a shape. If the line remains, inspect the cell border and nearby objects.
  • Using Clear All to fix one font effect. Home > Editing > Clear > Clear All removes much more than strikethrough, including other formatting and potentially cell contents. It is excessive for this task. Use the Font dialog to remove only the effect you want to change.
  • Assuming every crossed-out item is ordinary cell formatting. A conditional formatting rule can apply font effects when a condition is met. In that case, changing direct formatting may not remove the line while the rule remains active. Check the conditional formatting rules if strikethrough returns or persists.

Tips

  • Make a small test when the selection is large. If hundreds of cells are involved, try the shortcut on one known affected cell first. Confirm that it removes the line, then apply the same method to the intended range.
  • Use Ctrl+1 for a deliberate off setting. The dialog is especially useful when the selection may contain a mix of cells with and without strikethrough. Clear the checkbox rather than toggling blindly, and work through smaller selections if Excel shows a mixed state.
  • Use Undo if the shortcut goes the wrong way. Press Ctrl+Z immediately to reverse the most recent formatting change, then select the correct cells or use the Font dialog. Avoid making several unrelated edits before undoing, because Ctrl+Z reverses actions in sequence.
  • Check whether the line is part of the text itself. If the characters include a line-like symbol, deleting or editing the character may be necessary; a font-formatting command will not remove it. If the line is an inserted shape, select and delete that object instead.
  • Keep formatting intact where possible. The Font dialog lets you adjust strikethrough without clearing font color, size, bold, borders, or number formats. This is safer than applying a broad reset when only one visual effect is unwanted.

Troubleshooting

Ctrl+5 does nothing: First confirm that Excel has focus and that the intended cells are selected, rather than a text box or another application. Try the number-row 5 key. Laptop function layers usually are not needed for this shortcut, but keyboard utilities or remote desktop settings may intercept key combinations. Open Format Cells with Ctrl+1 and clear Strikethrough to bypass the shortcut.

The line disappears from some cells but appears on others: The shortcut toggles the setting and may produce different outcomes across a mixed selection. Undo if the result is undesirable. Select only the cells that currently have strikethrough, or use the Format Cells dialog on smaller groups and clear the checkbox. If you cannot identify the mixed cells easily, check them one at a time rather than applying the toggle repeatedly to the whole range.

The line remains after you clear Strikethrough: Check whether the appearance comes from conditional formatting. Select a problem cell, then go to Home > Conditional Formatting > Manage Rules. Set the rule display to the current selection or worksheet as appropriate, inspect rules that apply to that cell, and edit or remove the rule only if you intend to change its behavior. A rule can reapply formatting whenever its condition is true. Also check for a border, a drawn line, or a line-like character in the cell.

The line returns when you edit or reopen the workbook: A conditional formatting rule, a macro, or an external process may be applying the effect again. Review the workbook’s rules and any automation you know is used in the file. If the workbook is shared, another user or synced copy may also be restoring a version with the formatting. Save, close, and reopen the correct workbook to check whether the change persisted.

Only part of a cell’s text is crossed out: The formatting may have been applied to selected characters rather than the whole cell. Edit the cell, select the affected characters within the text, and use the font-formatting controls for that selection. If you select the whole cell instead, you may change the formatting of all its text. For a complicated entry, consider copying the original cell first so you can restore it if needed.

Frequently Asked Questions

What is the Excel shortcut to remove strikethrough?
On Windows, select the affected cell or cells and press Ctrl+5. It toggles strikethrough, so check the current formatting before using it. On Mac, the usual shortcut is Command+Shift+X.

Does Ctrl+5 delete the contents of a cell?
No. It changes the strikethrough font effect; it does not remove the cell’s value, formula, or text. Avoid confusing it with deletion or clearing commands.

Can I remove strikethrough from multiple cells at once?
Yes. Select the cells or range, then use Ctrl+5 if they are all currently struck through. If their formatting is mixed, use Format Cells and clear Strikethrough, checking smaller groups if necessary.

How do I remove strikethrough without a keyboard shortcut?
Select the cells, open Format Cells, choose the Font tab, clear Strikethrough under Effects, and click OK. In desktop Excel for Windows, Ctrl+1 opens that dialog; you can also reach it from the Font group on the Home tab.

Why does strikethrough come back after I remove it?
A conditional formatting rule may be applying it again when its condition is met. Check Home > Conditional Formatting > Manage Rules. A macro or another user’s changes can also restore formatting.

Will this shortcut work in Excel for the web?
Ctrl+5 commonly works in the web app on Windows, but browser shortcuts or settings may interfere. If it does not respond, use the Home tab’s formatting options. The available dialogs and controls can differ from desktop Excel.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.