In Excel for Microsoft 365 on Windows, select the cell or cells and press Ctrl+5 to apply strikethrough; press the same shortcut again to remove it. You can also turn the formatting on in the Format Cells dialog. Strikethrough draws a line through text or numbers without deleting their contents, which is useful for marking completed tasks, superseded entries, or items that should remain visible for reference.
The steps below focus on Excel for Windows. The Mac shortcut and a note about Excel for the web are included where they differ. You do not need a formula or add-in: strikethrough is ordinary cell formatting.
What You’ll Need
- A workbook you can edit in Microsoft Excel. The instructions use the Microsoft 365 desktop app on Windows.
- The cells or text you want to mark. If the worksheet is protected, you may need permission to change its formatting.
- Optional: a keyboard, if you want to use the shortcut. You can apply the same formatting through the ribbon and Format Cells dialog instead.
Step-by-Step
- Select the target cell or range. Click a single cell to strike through all of its contents. To format a continuous range, click the first cell and drag across the rest, or click the first cell, hold Shift, and click the last one. To select separate cells, hold Ctrl while clicking each cell, then apply the formatting once. You can also select a whole row or column if every entry in it should be marked.
- Use the Windows shortcut. With the cell or cells selected, press Ctrl+5. Use the 5 on the main keyboard number row for the most reliable result. A line should appear across the characters in the selected cells. This shortcut toggles the setting: pressing it again removes the line. Check the selection before using the shortcut, especially if you have selected a large range.
- Apply strikethrough from Format Cells if you prefer the dialog. Select the cells, then press Ctrl+1 to open Format Cells. Choose the Font tab. Under Effects, select the Strikethrough checkbox, then click OK. The dialog is useful when you want to inspect or change several font settings in one place. The checkbox indicates whether the selected cells already have strikethrough.
- Use the ribbon as another route. Select the target cells and open the Home tab. In the Font group, click its small dialog launcher at the lower-right corner to open Format Cells, then choose Font > Effects > Strikethrough and click OK. In many Excel desktop layouts, the Font group does not show a dedicated strikethrough button by default, so the dialog launcher is the dependable ribbon route. If you have added a strikethrough command to the Quick Access Toolbar or customized the ribbon, you can use that button instead.
- Format only part of a cell when needed. If just a word or phrase should have a line through it, edit the cell by double-clicking it or selecting it and pressing F2. Select the specific characters, then use the Font options or the strikethrough command while that text is selected. Avoid selecting only the cell if you intend to format a few characters: cell-level formatting affects the whole cell. Press Enter to finish editing. If selecting characters inside the cell is awkward, use the formula bar to edit and select the text there.
- Check the result and keep the content intact. Click another cell and confirm that the line appears where intended. Strikethrough changes the appearance, not the value: formulas can still use the cell, and copying the cell may copy its formatting too. If you wanted to remove an entry from calculations or data processing, formatting alone will not do that.
- Use the Mac or web equivalent if you are not on Windows. In Excel for Mac, select the cells and press Command+Shift+X to toggle strikethrough. You can also open Format Cells and choose the Font tab and Strikethrough option. In Excel for the web, select the cells and look for the strikethrough control on the Home tab; if the ribbon is collapsed, expand it to see the font options. Browser and keyboard settings can affect shortcuts, so the ribbon control is a useful alternative.
Common Mistakes
- Using the wrong shortcut. On Windows, the strikethrough shortcut is Ctrl+5, not Ctrl+Shift+5. The latter may trigger another command or do nothing, depending on your keyboard and settings. On Mac, use Command+Shift+X instead.
- Assuming the shortcut deletes or completes a value. The text remains in the cell and remains available to calculations, filters, and other workbook features. If a task list needs a true completion status, consider maintaining a separate status column as well as visual formatting.
- Applying formatting to the wrong selection. If a whole column or a multi-cell range is selected, Ctrl+5 applies to that entire selection. Check the selection border or the Name Box before using the shortcut.
- Expecting a visible button in every ribbon layout. Excel desktop versions and customized ribbons may arrange commands differently. If you cannot find a strikethrough icon, open Format Cells from the Font group dialog launcher rather than searching unrelated menus.
- Confusing a line through text with a border. Strikethrough is a font effect. A bottom border or underline sits at the edge or below the characters and is not the same formatting.
- Using visual formatting as the only record of a change. A crossed-out value is still present. Someone viewing the workbook may overlook the line, and a formula will not automatically treat it as excluded. Keep a clear status field or update the underlying data when that distinction matters.
Tips
- Apply it to several items at once. Select all relevant cells first, including nonadjacent cells if necessary, then use the shortcut or Format Cells once. This is quicker and helps keep the formatting consistent.
- Use the toggle deliberately. Ctrl+5 switches the selected cells between strikethrough on and off; it is not an undo command. If a range contains a mix of formatted and unformatted cells, applying the shortcut may make the selection uniform rather than simply reversing every cell to its previous state. Inspect the result when working with mixed formatting.
- Keep task lists easy to scan. A crossed-out task can communicate completion, but consider pairing it with a status column such as “Done” or a check box if the list is shared. That makes the status clearer to readers using different display settings or assistive technology.
- Copy formats carefully. Copying a strikethrough cell can carry the effect into a destination cell. If you want the value but not its formatting, use Paste Special > Values or the paste option for values, rather than a normal paste.
- Consider print and screen readability. A thin line can be difficult to see at small zoom levels or in a printed copy. Check the worksheet at a practical zoom and use an additional cue, such as a status label, for information readers must not miss.
- Choose formatting that matches the purpose. Strikethrough is suitable for visible corrections and completed entries. For information that should no longer appear in a report, filtering or removing it may be more appropriate than leaving it crossed out.
Troubleshooting
Nothing happens when you press Ctrl+5. Confirm that Excel is the active window and that a cell or range is selected. Try the number-row 5 rather than a numeric keypad key, then test the Format Cells route: press Ctrl+1, open Font, select Strikethrough, and click OK. If you are using a laptop, a keyboard utility or browser may intercept a shortcut; the dialog avoids relying on it.
The line appears on the wrong cells. Immediately check the selection. If the change was just made, press Ctrl+Z to undo it, select the intended cells, and try again. If the worksheet has since been edited, undo may reverse more than the formatting change, so inspect the workbook before continuing.
The checkbox is unavailable or Excel will not change the formatting. The sheet may be protected, or the workbook may be opened with restricted editing. Check Review for sheet protection and ask the workbook owner for permission if needed. Do not remove protection unless you are authorized and understand its purpose.
The line is missing or looks different from what you expect. Open Format Cells and check whether Strikethrough is selected for the cell. Also look for conditional formatting that may be changing the displayed font, and check whether you are editing only part of the cell or formatting the entire cell. If the line is difficult to see, increase the zoom or inspect a print preview. In Excel for the web, expand the Home ribbon and use its formatting controls if a keyboard shortcut is intercepted.
You need to restore normal text. Select the affected cells and press Ctrl+5 again on Windows, or clear the Strikethrough checkbox in Format Cells. If a selection contains a mix of cells, verify the results individually or use the dialog to set the desired state deliberately.
Frequently Asked Questions
What is the keyboard shortcut for strikethrough in Excel?
In Excel for Microsoft 365 on Windows, select the cell or range and press Ctrl+5. Press it again to toggle the effect off. On Excel for Mac, the shortcut is Command+Shift+X.
Does strikethrough remove the cell’s value?
No. It changes only the way the content looks. The value remains in the workbook and can still be included in calculations, searches, and other operations. Delete or update the value if it should no longer be used.
Can I strike through only one word in a cell?
Yes. Edit the cell, select just the characters you want to format, and apply the font effect to that selection. If you select the cell without selecting text inside it, the effect applies to the whole cell.
Can I strikethrough text in Excel for the web?
Yes. Select the cell or cells and use the strikethrough control in the Home ribbon’s font options. If you cannot see it, expand the ribbon. Keyboard shortcuts can vary with browser and keyboard settings, so use the ribbon when the shortcut is unavailable.
Will strikethrough change how formulas calculate?
No. Excel formulas do not exclude a value just because it has strikethrough formatting. If a formula should ignore completed or cancelled items, store that status in a separate cell and build the formula around the status.
How do I remove strikethrough without clearing other formatting?
Select the affected cells and toggle the effect off with Ctrl+5 on Windows, or open Format Cells and clear the Strikethrough checkbox. Avoid using Clear All, which can remove other formatting and cell contents as well.
Related
- Excel Tab Rename Shortcut: Windows and Mac Quick Guide
- How to Rename an Excel File in Windows 11 Using Explorer
- Rename an Excel File on Windows 10: Step-by-Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Calendar: Create and Customize Your CalendarTo create a calendar in Google Sheets, enter a year and month, then use a date formula to…
- Google Sheets Duplicate Values: Find and Remove ThemYes, Google Sheets can find duplicate values, highlight them, and remove duplicate rows. In a browser, use Format…
- How to Change Short Date Format in Excel for DatesTo change how dates appear in Excel for Microsoft 365 on Windows, select the date cells, then choose…
- Google Sheets: Duplicate a Data Validation RuleTo duplicate a data validation rule in Google Sheets, copy a cell that already has the rule, select…
- Conditional Formatting to Highlight an Entire Row in ExcelYes. In Excel for Microsoft 365, select the data range, create a formula-based conditional-formatting rule, and use a…
- Google Sheets Scenario Filter: How to Rebuild ItGoogle Sheets does not have a built-in feature called Scenario Filter. To rebuild one, either create a filter…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.