To remove strikethrough from a number in Excel for Microsoft 365 on Windows, select the cell and press Ctrl+5 to toggle the effect off. For a range or a cell where the shortcut does not work, open Format Cells, go to Font, and clear the Strikethrough checkbox. These steps change the cell’s appearance, not the number stored in it.
Strikethrough is a font effect, so it can be applied to a single cell, selected characters, or a whole range. If it keeps coming back, a conditional-formatting rule may be applying it automatically. The guide below covers both ordinary formatting and that less obvious cause, while helping you avoid clearing other formats by accident.
What You’ll Need
- The Excel workbook containing the affected number or cells.
- Permission to edit the cells. If the worksheet is protected, you may need the password or help from the workbook owner.
- A clear idea of which cells should lose the effect. If several cells are affected, identify the intended range before changing formatting.
Step-by-Step
- Select the affected cell or range. Click the cell that contains the crossed-out number. To remove the effect from several adjacent cells, drag across them or click the first cell and Shift-click the last. For nonadjacent cells, hold Ctrl while selecting each cell on Windows. If the effect is on only part of text inside a cell, double-click the cell, select the affected characters in the formula bar or cell, and use the Font dialog method below; selecting a cell alone may affect the whole cell rather than just those characters.
- Try the keyboard shortcut for a quick change. With the cell or range selected, press Ctrl+5 on Windows. This shortcut toggles strikethrough, so it can turn the effect off when it is currently on, but it can also turn it on if it was off. On Excel for Mac, the strikethrough shortcut is Command+Shift+X. If the selection contains a mixture of formatting, or you are not certain what state the active cell is in, use the next step to inspect the checkbox instead.
- Open the Font settings. On Windows, right-click the selected cell or range and choose Format Cells. Select the Font tab. You can also open the dialog from the Home tab by clicking the small dialog box launcher in the lower-right corner of the Font group. On Mac, use Format > Cells and choose the Font tab. In Excel for the web, use the Home tab’s font controls if the Strikethrough command is available; the Ctrl+5 shortcut may also work, depending on your browser and keyboard.
- Clear Strikethrough and confirm. In the Format Cells dialog, find the Effects area on the Font tab and clear the checkbox next to Strikethrough. If the checkbox is already clear, this cell’s ordinary font settings are not the source of the visible line; continue to the conditional-formatting check. Click OK to apply the change. For a selected range, inspect the checkbox and apply the setting to the intended cells, taking care when the range has mixed formatting.
- Check the result in the worksheet. Click another cell so you can see the selected number normally. Confirm that the value is unchanged and that only the unwanted line has disappeared. If other formatting, such as bold text, color, borders, or the number of decimal places, also changed, undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then repeat using the Font dialog rather than clearing all formats.
- If the line remains, inspect conditional formatting. Select an affected cell, then choose Home > Conditional Formatting > Manage Rules. In the rules manager, set Show formatting rules for to This Worksheet if you need to see rules outside the current selection. Review rules whose Applies to range includes the cell. Select a likely rule and choose Edit Rule, then inspect its Format settings. If its Font settings apply strikethrough, change the rule’s format or remove that effect from the rule. Choose OK and Apply as needed, then check the cell again.
- Remove a rule only if that is what you intend. If a rule is no longer wanted at all, select it in Manage Rules and delete it. Alternatively, with the intended cells selected, use Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells. This can remove every conditional-formatting rule affecting those cells, not just strikethrough, so editing the particular rule is safer when its colors, fills, or other visual alerts are still useful.
Common Mistakes
Pressing Ctrl+5 without checking whether the effect is on. Ctrl+5 is a toggle, not a one-way remove command. If strikethrough is off already, pressing it applies the effect. When you are unsure, use Format Cells and make sure the Strikethrough checkbox is clear.
Using Clear Formats for a one-effect problem. Home > Clear > Clear Formats removes much more than strikethrough. It can discard number formats, font choices, fills, borders, and other direct formatting. A value displayed as currency or with a particular number of decimal places could suddenly look different. Use the Font tab checkbox to remove just the line.
Changing the wrong range. If a whole column or worksheet is selected, the change may affect many cells you did not intend to edit. Check the selection outline and the Name Box before applying the Font setting. For a large range, use the Name Box to enter a specific address, such as D4:D18, and press Enter to select it.
Deleting conditional formatting without checking its purpose. A rule may also highlight overdue items or flag values that need review. Deleting it can remove those helpful signals. Edit the rule’s Font settings when possible, and only clear or delete a whole rule when you are sure it is no longer needed.
Tips
- Use the Font dialog for precise control. It makes the current Strikethrough setting visible and avoids toggling the effect on by mistake. This is particularly useful when selected cells have different formatting.
- Check a small sample first. For a large worksheet, test the change on one affected cell. If it works and does not disturb other formatting, select the remaining intended cells and repeat.
- Keep data and display separate in your thinking. Removing strikethrough changes how a number looks; it does not recalculate, replace, or delete the number. If the displayed value itself is wrong, check the cell’s contents or formula separately.
- Use Find All for scattered cells. Press Ctrl+f on Windows, search for a distinctive value or text, and use Find All if appropriate to locate matching entries. Check the results carefully before applying a format change; matching a value does not necessarily mean every match should lose strikethrough.
- Save after checking a broad change. When you have updated many cells or edited a rule, inspect other parts of the sheet that rely on similar formatting. Save once the appearance and number display are correct.
Troubleshooting
The shortcut seems to do nothing. Click the worksheet cell first rather than a ribbon control, then try the shortcut again. If you are editing the cell’s contents, press Esc to leave edit mode before selecting the cell. On a laptop, check whether your keyboard requires an Fn key for the number-row key. The Format Cells dialog is a dependable alternative on desktop Excel.
The checkbox is clear, but the number still has a line. Check conditional formatting using Home > Conditional Formatting > Manage Rules. If no rule appears to explain it, confirm that you selected the correct cell and that the line is actually strikethrough rather than a border, an underline, or a line drawn over the worksheet. A border can be adjusted from Home > Borders, while a drawn shape can be selected and deleted separately.
The effect returns after you edit the number. This often points to a conditional-formatting rule whose condition is still true. Edit the rule so it no longer applies strikethrough, or change the condition if the rule itself is no longer appropriate. If a colleague or automated process reapplies formatting, check with the workbook owner before making a permanent change.
You cannot change the cell. A protected worksheet can prevent formatting changes. Look on the Review tab for Unprotect Sheet; if the sheet requires a password, ask the owner rather than trying to bypass protection. In a shared or read-only workbook, make an editable copy if you have permission, then make the change there.
You removed the line but also changed number appearance. Press Ctrl+Z on Windows or Command+Z on Mac immediately, then select the cells again and clear only the Strikethrough checkbox in Format Cells. Undo is preferable to manually restoring several formats, especially if the original number format is not obvious.
You are using Excel for the web. The web interface can differ from desktop Excel, and the ribbon may hide controls when the window is narrow. Expand the window or look in the Home tab’s font options. If you cannot reach the needed Font or rule settings in the web interface, open the workbook in the desktop app, make the change there, and save it back to the workbook.
Frequently Asked Questions
Does removing strikethrough change the number or formula?
No. Strikethrough is visual font formatting. Clearing it does not change the cell’s stored value, formula, or calculation. If a number changes after you remove the line, check whether another action or formula is responsible.
What is the fastest way to remove strikethrough from one number?
Select the cell and press Ctrl+5 on Windows, or Command+Shift+X on Mac. Because the shortcut toggles the setting, use Format Cells and clear its checkbox if you are unsure whether the effect is currently on.
Can I remove strikethrough from several cells at once?
Yes. Select the cells or range, then use the Font tab in Format Cells to clear Strikethrough. For cells in separate locations, select them together where possible, or repeat the change for each group. Verify the selection before applying it.
Why does only part of the text in a cell have strikethrough?
Cells can contain rich-text formatting, where only selected characters have a font effect. Enter edit mode by double-clicking the cell, select the affected characters, and clear Strikethrough in the Font settings. A whole-cell selection may not remove character-level formatting as intended.
Can I remove strikethrough but keep the cell’s other formatting?
Yes. Clear only the Strikethrough checkbox in Format Cells. Avoid Home > Clear > Clear Formats, which removes other direct formatting too. If conditional formatting applies the line, edit that rule’s font setting rather than deleting useful rule effects.
Will the shortcut work in Excel for the web?
It may, but browser and keyboard behavior can vary. Try Ctrl+5 after selecting the cell, then check the Home tab’s font options. For more complete rule management or if a formatting control is missing, open the workbook in desktop Excel.
Related
- How to Print in Microsoft Excel: A Step-by-Step Guide
- Password-Protect an Excel File So It Can’t Be Opened
- Protect an Excel Workbook From Opening with a Password
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 Create Envelope Labels in Word: A Practical GuideTo create address labels for envelopes in Word, open Mailings > Labels, choose the label product that matches…
- How to Schedule an Email in Outlook for a Later TimeTo schedule an email in Outlook, write your message, open the menu beside Send, choose Schedule send, and…
- How to Set an Out of Office in OutlookTo set an out-of-office email in Outlook, open Automatic replies, turn them on, write your message, and—if available—choose…
- Conditional Formatting Based on a Checkbox in ExcelYes. In Excel for Microsoft 365, conditional formatting can respond to a checked or unchecked box because a…
- Excel SUM: How to Exclude Hidden Rows and Filtered RowsYes. To sum visible rows while excluding both filtered-out rows and rows hidden manually, use SUBTOTAL with function…
- How to Get Rid of the Search Bar in ExcelTo hide Excel’s large Search box in Microsoft 365 for Windows, go to File > Options > General,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.