How to Delete Strikethrough in Excel in a Few Steps

How-to basics · Updated November 20, 2026

To delete strikethrough in Excel for Microsoft 365 on Windows, select the affected cell or range, press Ctrl+1, open the Font tab, clear the Strikethrough checkbox, and select OK. For a quick toggle, select cells with uniform formatting and press Ctrl+5. If the line returns, check for conditional formatting or a style that is applying it.

What You’ll Need

  • An Excel workbook with the affected cells. If the workbook is important, save a copy before making broad formatting changes.
  • Permission to edit the worksheet. A protected sheet may prevent you from changing font formatting.
  • A moment to identify whether the line crosses the whole cell value, only some characters, or appears only under certain conditions. The right fix depends on where the formatting comes from.

Step-by-Step

  1. Select the affected cells. Click one cell to remove its strikethrough, or drag across a range to select several cells. To select an entire column or row, click its letter or number heading. If only some cells in a large area are affected, select just those cells so you do not change formatting unnecessarily.
  2. Open Format Cells. On Windows, press Ctrl+1. You can also go to Home and select the small dialog box launcher in the lower-right corner of the Font group. The Format Cells window gives you direct control over the font effects applied to your selection.
  3. Open the Font tab. In Format Cells, select Font if it is not already open. Find the Effects section and locate the Strikethrough checkbox. This setting controls the line through cell text; it does not delete or alter the text itself.
  4. Clear Strikethrough. If the checkbox is checked, click it to remove the check mark. If it looks shaded or indeterminate, the selected cells do not all share the same setting. Click the box until it is visibly empty to make the selected cells consistently not struck through. If you are unsure, narrow the selection and repeat for a smaller group.
  5. Apply the change. Select OK. Look at the cells to confirm the line is gone. If you selected a range, inspect a few cells across it, especially if the range contained mixed formatting. The text and other font settings, such as bold or color, should remain unchanged.
  6. Try the keyboard toggle for a simple case. When all selected cells have the same strikethrough state, Ctrl+5 on Windows toggles the effect off or on. Select the cells first, then use the shortcut once and check the result. Because it is a toggle, using it again can put the line back. Avoid relying on it for a mixed selection; the Format Cells checkbox makes the intended setting clearer.
  7. Remove strikethrough from only part of a cell’s text. Double-click the cell, or select it and press F2, to edit its contents. Drag across the characters that have the line, then press Ctrl+1 and clear Strikethrough on the Font tab. Select OK and press Enter to finish editing. If the whole cell is formatted, you can instead select the cell normally and change its font effect.
  8. Check the source if the line remains. If clearing the checkbox does not remove the visible line, see whether conditional formatting or a cell style is applying it. A rule can reapply strikethrough when a value meets a condition, while a style can apply it to every cell using that style. The troubleshooting section below explains how to inspect both.
  9. Save the workbook. Press Ctrl+S after confirming the result. If you changed a large range, review the surrounding worksheet to make sure the correction did not affect cells you meant to leave alone.

Mac and web notes: In Excel for Mac, select the cells and use Command+1 to open Format Cells, then clear Strikethrough on the Font tab. The strikethrough toggle is Command+Shift+X on Mac; as on Windows, it toggles rather than exclusively removing the effect. Excel for the web has a more limited Format Cells interface, so use the available font-formatting controls on the Home tab or open the workbook in the desktop app if you cannot access the specific Font effects setting.

Common Mistakes

Using the toggle without checking the current state: Ctrl+5 does not mean “remove strikethrough”; it switches the setting. If the selected cells are already clear, the shortcut can add a line. Check the result immediately, and use the Format Cells dialog when you need to set the effect explicitly.

Clearing all formatting for a one-effect problem: Home > Editing > Clear > Clear Formats removes more than strikethrough. It can also remove number formats, fills, borders, font colors, and other formatting. Use it only when you want to reset all formatting in the selected cells and are prepared to restore any settings you need.

Selecting the wrong target: A line may cross only part of a cell’s text, or you may have selected a neighboring cell instead. For partial text, enter cell-edit mode and select the affected characters. For a whole cell, select the cell itself rather than placing the insertion point in the formula bar or another cell.

Assuming the line is always direct formatting: A conditional-formatting rule or style can make text look struck through even after you change the ordinary font setting. If the line comes back after recalculation, editing a value, or reopening the workbook, investigate those sources instead of repeatedly toggling the font effect.

Tips

  • Work on a small sample first. If the same unwanted effect appears throughout a large worksheet, test the fix on a few affected cells. Once you know it works and preserves the formatting you need, apply it to the rest.
  • Use Find to locate likely cells. Press Ctrl+f and search for a distinctive word or value, then inspect the matching cells. Find can help navigate to content, but it does not by itself identify every cell formatted with strikethrough.
  • Use Format Painter carefully. Copying a clean cell’s formatting with Home > Clipboard > Format Painter can remove the line, but it also copies other formatting. Use this when the source and destination cells should share the same complete appearance, not when you need to preserve different borders or number formats.
  • Keep a clean cell as a reference. If you often correct similar entries, keep an example with the desired formatting nearby. Compare its font settings before applying broad changes; do not assume two cells that look similar have identical formatting rules.
  • Separate content from appearance. Strikethrough changes how text is displayed, not the cell’s value. Removing it will not restore deleted data, change a formula result, or mark an item as complete or incomplete in another system.

Troubleshooting

The Strikethrough checkbox is empty, but a line is still visible. First check for a conditional-formatting rule. Select the affected cell and go to Home > Conditional Formatting > Manage Rules. In the rules window, set the display option to show rules for the current selection or worksheet, then inspect rules that apply to the cell. Select a relevant rule and choose Edit Rule to review its format, or remove or change the rule if it is not wanted. Removing a rule can affect every cell it applies to, so check its range before deleting it.

The line appears only for certain values. This strongly suggests conditional formatting. A rule may apply a font effect when a cell contains a particular word, date, or value. You can edit the rule’s formatting or adjust its condition or Applies to range. If the rule is intentional, changing the condition may be safer than removing it altogether.

The line returns after you edit a cell. Recheck conditional formatting, including rules that refer to another cell. Also look at the cell style: on the Home tab, inspect the Cell Styles gallery and see whether the selected cell uses a custom style. Applying a different style may alter several properties, so review the result rather than changing styles blindly. If the workbook is shared or generated from a template, another person or process may also be restoring the format.

You cannot change the formatting. The worksheet may be protected. On the Review tab, check whether the available command says Unprotect Sheet. If so, select it and enter the password if required; only do this if you are authorized and know the password. A protected workbook structure or restricted editing settings can also limit what you can change. Do not remove protection from a workbook unless you understand the consequences.

Ctrl+5 seems to do the opposite. That is expected when the selected text does not currently have strikethrough: the shortcut turns it on. Press it again to toggle it back off, or use Ctrl+1 and explicitly clear the checkbox. If shortcuts are intercepted by another application or behave differently on your keyboard, use the ribbon dialog instead.

Only some characters still have a line. Cell-level formatting and character-level formatting can coexist. Select the cell, enter edit mode, highlight the specific characters, and open the Font tab in Format Cells. For long text, make sure the selection covers the complete affected segment; otherwise, the remaining characters may keep their own formatting.

Frequently Asked Questions

What is the fastest way to remove strikethrough in Excel?
For cells that all have the same formatting, select them and press Ctrl+5 on Windows. It toggles strikethrough, so verify that the line disappeared. To explicitly clear the setting, use Ctrl+1, open Font, clear Strikethrough, and select OK.

Can I remove strikethrough from many cells at once?
Yes. Select the affected range and clear Strikethrough in Format Cells. If the selection contains both struck-through and unformatted cells, the checkbox may be indeterminate; make sure it ends visibly empty before applying the change. Check the range afterward for unintended changes.

Will removing strikethrough delete the cell’s contents?
No. Strikethrough is a font effect. Clearing it changes the display only; it does not erase the text, number, or formula in the cell.

Can I remove the line without changing bold, color, or number formatting?
Yes. Clear only the Strikethrough checkbox in Format Cells. Avoid Clear Formats, which removes multiple kinds of formatting at once.

Why does strikethrough appear again after I remove it?
A conditional-formatting rule or cell style may be applying the effect again. Inspect the rules for the affected selection and review the cell’s style. If a rule depends on cell values, the line may reappear whenever its condition becomes true.

Does the same shortcut work on Mac?
No. In Excel for Mac, the strikethrough toggle is Command+Shift+X. Command+1 opens Format Cells so you can clear the checkbox directly. Shortcuts can vary with keyboard settings, so the dialog is a reliable alternative.

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.