To disable strikethrough in Excel for Microsoft 365 on Windows, select the affected cell or range and press Ctrl+5; the shortcut toggles strikethrough off when it is on. For a more controlled change, open Format Cells with Ctrl+1, choose the Font tab, clear Strikethrough, and select OK. This removes the line without changing the cell’s other font settings. If the line comes back, check conditional formatting as well as the cell’s direct formatting.
What You’ll Need
- The Excel workbook and the cells, range, or text you want to fix. If the strikethrough is not obvious, note whether it appears in one cell or across a larger area.
- Permission to edit the workbook. If it is protected or opened as read-only, you may need the password or an editable copy before changing formatting.
- For a shared or important workbook, consider saving a copy first. The steps below change formatting, but a copy makes it easier to recover if you select the wrong range.
Step-by-Step
- Select the affected cells. Click a single cell with a line through its text. To fix several cells at once, drag across a contiguous range, or hold Ctrl while selecting separate cells or ranges. Check the highlighted selection before changing anything; applying a format to a whole row or column by mistake can affect many cells. If only some cells in a larger range are struck through, you can select the full range and use the Font dialog method, but inspect the result afterward.
- Try the Windows toggle shortcut. With the intended cells selected, press Ctrl+5. Strikethrough is a toggle: if it was applied to the selected text, the shortcut removes it; pressing the shortcut again adds it back. If you are unsure whether a selection contains a mixture of formatted and unformatted cells, use the Font dialog in the next step instead of relying on the toggle.
- Use Format Cells for a precise change. Select the cells and press Ctrl+1 to open the Format Cells dialog. Choose the Font tab, find Effects, and clear the Strikethrough checkbox. Click OK. This changes the strikethrough setting while leaving choices such as font name, size, color, bold, and italic as they were. If the checkbox appears shaded or indeterminate because the selection has mixed formatting, click it until it is visibly empty before confirming.
- Use the ribbon if you prefer menus. On the Home tab, open the Font dialog box using the small dialog launcher at the lower-right of the Font group. In the dialog, select Font, clear Strikethrough under Effects, and choose OK. The ribbon is useful when you do not remember the shortcut, and it exposes the same detailed font settings as the Format Cells dialog.
- Check whether only part of a cell is formatted. If the line crosses just a few characters rather than the whole cell’s text, double-click the cell or select it and press F2 to edit it. Highlight only the struck-through characters, then use Ctrl+5 or open the Font dialog and clear Strikethrough for that selected text. Press Enter to finish editing. Take care not to replace or delete the cell’s contents while selecting text.
- Verify the change. Click another cell, then return to the edited one and confirm the line has disappeared. If you changed a range, check a few cells at different points in it. Save the workbook with Ctrl+S once the result looks right. If the strikethrough remains or reappears, continue to Troubleshooting; a conditional formatting rule or a different selected range may be responsible.
- On Mac or Excel for the web, use the equivalent controls. In Excel for Mac, select the cells and press Command+Shift+X to toggle strikethrough, or open Format Cells with Command+1 and clear the setting on the Font tab. In Excel for the web, select the cells and use the Font settings on the Home tab; keyboard shortcuts can depend on the browser and operating system. If a shortcut is intercepted by the browser or does not work, use the formatting controls instead.
Common Mistakes
Pressing the toggle without checking the selection: Ctrl+5 does not mean “always remove.” It switches the formatting state, so using it on text that is not struck through can add a line. Select the target cells carefully, and use the Font dialog when the selection has a mixture of formats or when you need to verify that Strikethrough is cleared.
Clearing all formatting to remove one effect: Home > Editing > Clear > Clear Formats can remove strikethrough, but it also removes other formatting, including number formats, fills, borders, and font choices. Avoid it if you want to preserve the worksheet’s appearance. Clear only the Strikethrough setting in the Font tab instead.
Changing the cell instead of its characters: A cell can contain rich-text formatting, so only part of its text may be struck through. Selecting the cell and changing its font settings may affect the whole cell, not just the characters you meant to fix. Edit the cell and select the specific characters when the line is limited to part of the text.
Assuming the line is always direct formatting: When a rule applies the font effect, clearing direct formatting may not make the line disappear. Conditional formatting can apply a font style when its condition is true, and that rule may reapply strikethrough automatically. Check the rules before repeatedly changing the cell.
Tips
- Use the dialog for mixed ranges. If some selected cells have strikethrough and others do not, the Font tab helps you set the desired state explicitly. A blank checkbox means the selection is not set to strikethrough; a filled or shaded box indicates mixed settings in many Excel dialog versions.
- Keep other formatting intact. Removing the one checkmark is usually safer than using a brush, copying a different cell’s format, or clearing all formats. Those alternatives can unintentionally replace the target cell’s number format, fill, borders, or font.
- Use Format Painter only when appropriate. Copying the format from a clean cell with Format Painter may be convenient if you want to copy all of that cell’s formatting. It is not a good choice when the target cells have their own colors, borders, or number formats that must remain unchanged.
- Look for patterns. If many cells across a sheet have the line, identify whether they share a rule, style, or source before making a large edit. Fixing the cause can be faster and more consistent than clearing each cell individually.
- Save after checking. For a shared workbook, verify the change in the saved file and confirm that another user or an automatic rule is not restoring the formatting. If you are unsure, keep a backup before making sheet-wide changes.
Troubleshooting
The shortcut adds strikethrough instead of removing it. Ctrl+5 is a toggle. It may be adding the effect because the selected cell or text did not have strikethrough. Undo with Ctrl+Z if that was your last action, then open Format Cells and inspect the checkbox. On Mac, the shortcut is Command+Shift+X. Keyboard layouts and browser shortcuts can vary, so the dialog is the dependable alternative.
The line remains after you clear the checkbox. First make sure you selected the correct cell or characters and clicked OK. If the line still appears, open Home > Conditional Formatting > Manage Rules. In the rules manager, set the rules list to the relevant worksheet if necessary, select a rule that applies to the affected cells, and choose Edit Rule. Use its Format button to open the Font settings; if Strikethrough is selected there, clear it or adjust the rule. Be cautious when editing rules because a rule may be used by many cells.
The line disappears, then returns when a value changes. This strongly suggests a conditional formatting rule is applying it when a condition becomes true. In Manage Rules, check the affected range and the rule’s condition. You can edit the rule’s font format, change its condition, or remove the rule if it is no longer needed. Before deleting a rule, confirm what other cells it affects and whether its color, fill, or other formatting is still useful.
You cannot change the formatting. Look for a protection message or a read-only indicator. A protected worksheet may restrict formatting, and a shared or read-only file may not allow edits. Ask the workbook owner for access, request an unprotected copy, or save a copy where permitted. Avoid trying to bypass protection on a workbook you do not own.
Only some characters change, or the result looks inconsistent. Check whether the cell contains selected text in edit mode, whether multiple cells were selected, and whether a conditional rule applies to only part of the range. Exit edit mode with Esc if you did not intend to edit the cell, select the correct target, and apply the change again. For a large range, check a few sample cells after the change rather than assuming every cell had identical formatting.
Frequently Asked Questions
What is the shortcut to remove strikethrough in Excel?
On Windows, select the cell or text and press Ctrl+5. It toggles the effect, so it removes strikethrough only when the selected content currently has it. On Mac, use Command+Shift+X.
Can I remove strikethrough without changing the font or color?
Yes. Open Format Cells, go to the Font tab, and clear only the Strikethrough checkbox. Do not use Clear Formats if you need to preserve other formatting.
How do I remove strikethrough from several cells at once?
Select the cells or range, open Format Cells with Ctrl+1 on Windows, clear Strikethrough, and click OK. Check the selection first so you do not alter unrelated cells.
Why does strikethrough come back after I remove it?
A conditional formatting rule may be applying the effect again when its condition is met. Review Home > Conditional Formatting > Manage Rules and inspect rules that apply to those cells.
Can I remove strikethrough from only part of a cell?
Yes. Enter edit mode, select the specific characters, and clear their strikethrough formatting. Avoid changing the whole cell if the rest of its text should keep its existing style.
Does deleting the text also remove strikethrough?
Deleting the contents does not necessarily remove the cell’s formatting. If you type new content in the same cell, it may inherit the existing strikethrough. Clear the Font setting as well if the cell itself should no longer use that effect.
Related
- How to Delete Blank Lines in Excel Safely
- Delete Blank Rows in Excel Quickly: Safe Ways to Clean
- How to Delete Blank Cells in Excel Without Losing Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add a Watermark in Word to All PagesTo add a watermark to every page in Microsoft Word, open the document in the desktop app and…
- Excel Date and Time Shortcuts: Insert Both InstantlyIn Excel for Microsoft 365 on Windows, press Ctrl+; to insert the current date, or Ctrl+Shift+; to insert…
- How to Freeze Column Width in Excel and Stop ResizingTo keep a column’s width from being changed in Excel, set the width first, then protect the worksheet…
- Outlook View: Restore the Default Layout in WindowsIn classic Outlook for Windows, select the folder whose display you want to fix, then choose View >…
- How to Insert a Table of Contents in a Word DocumentTo insert a table of contents in Word, apply built-in heading styles to your section titles, click where…
- Excel Date to String: Format Dates as TextTo convert an Excel date to a text string, use the TEXT function: with a date in A2,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.