In Excel for Microsoft 365 on Windows, select a cell or range and press Ctrl+5 to apply or remove strikethrough. On a Mac, the shortcut is Command+Shift+X; you can also use the Strikethrough button on the Home tab.
Shortcut at a glance
The Windows shortcut is a quick way to cross out the contents of selected cells without deleting them. Select one cell, several cells, or a range, then press Ctrl+5. The shortcut applies the font effect to the selection; pressing it again can remove the effect. If the selection contains a mix of formatting, check the result because the active cell and selection state can affect what Excel applies.
- Excel for Microsoft 365 on Windows: Ctrl+5.
- Excel for Microsoft 365 on Mac: Command+Shift+X.
- Excel for the web: use Home > Strikethrough if the keyboard shortcut is intercepted by your browser or does not work in your setup.
On a Windows keyboard, press the 5 on the main number row while holding Ctrl. If you use a laptop, the number-row key may require a different physical action depending on the keyboard layout. The shortcut is not the same as deleting a row or clearing a cell: it changes the appearance of the cell’s content.
What strikethrough does in a spreadsheet
Strikethrough draws a horizontal line through text or numbers while leaving the underlying cell value in place. It is a font-formatting effect, similar to bold or italic, rather than an editing command. A crossed-out task remains available to formulas, sorting, filtering, copying, and other spreadsheet operations just as it was before.
That distinction is useful when a list needs to show progress without losing its history. For example, a project tracker might keep “Draft budget” in cell A2 and strike it through when the work is finished. The task is still there for reference, and a note in the next column can record who completed it or when. Strikethrough itself does not record completion, though; it is only a visual signal.
It also does not change the stored value. If a cell contains 125, applying strikethrough leaves the number 125 in the cell. A formula that refers to that cell still sees 125, and a total still includes it unless the formula’s logic says otherwise. This can surprise people who use the effect to mark canceled amounts: formatting a number as crossed out does not remove it from a sum.
Apply strikethrough to cells or selected text
For ordinary cell formatting, select the cell or cells first, then use the shortcut. Excel applies the effect to the content in those cells. You do not need to enter edit mode to cross out an entire cell’s contents.
To cross out only part of a text entry, select the characters rather than just the cell. One way is to double-click the cell or select it and press F2, then drag across the desired characters. You can also click in the formula bar and select the relevant text there. With the characters highlighted, apply the strikethrough command. For example, if a cell contains “Send draft; approve final,” you can strike “Send draft” while leaving the rest readable.
- Click the cell containing the text.
- Enter in-cell editing by double-clicking the text or pressing F2.
- Select the characters to format. Avoid selecting only the cell if you intend to format a portion of its text.
- Use Ctrl+5 on Windows, or the applicable Mac shortcut, and then confirm the result.
Partial-character formatting is a rich-text feature, so it applies to text stored in the cell. It does not let you format only a few characters of a formula’s displayed result. If a cell contains a formula, applying strikethrough to the cell formats the displayed result as a whole; it does not change the formula or selectively cross out part of its output.
Use the ribbon or Format Cells dialog
If you do not want to memorize a shortcut, select the cells and choose Home > Strikethrough in the Font group. The button is represented by “ab” with a line through it in many Excel layouts. In a narrower window, the Font group may be compacted, so you might need to expand the group or widen the Excel window to see the control.
You can also open the full formatting dialog. On Windows, select the cells and press Ctrl+1, then open the Font tab and select the Strikethrough effect. Click OK to apply it. This is helpful when you are already adjusting several font properties or want to inspect the current formatting. On Mac, use the Format Cells dialog from the ribbon or menu; the precise menu arrangement can vary with the Excel interface version.
The ribbon and dialog are useful alternatives when working through a remote desktop, on a keyboard with an unusual layout, or in an environment where a shortcut is assigned to something else. They also make the formatting effect easier to find for someone who rarely uses Excel.
Excel for the web and browser shortcuts
Excel for the web has a Home-tab Strikethrough command, so the ribbon is a reliable fallback when you are working in a browser. Keyboard shortcuts can behave differently in web apps because the browser may reserve certain key combinations for its own commands. If Ctrl+5 switches browser tabs, does nothing, or produces an unexpected result, use the ribbon rather than assuming the workbook has changed.
Before sharing a workbook, check that the formatting appears as intended in the version your collaborators use. The strikethrough effect is standard cell formatting, but the exact keyboard interaction may differ across Windows, Mac, and browser environments. The visual command on the ribbon avoids needing to remember a platform-specific key combination.
Common problems and how to fix them
- The shortcut seems to do nothing: Confirm that Excel has focus and that a cell is selected. If you are editing text, make sure the intended characters are highlighted. Try the Home-tab button to determine whether the issue is the shortcut or the selection.
- The browser changes tabs: In Excel for the web, use Home > Strikethrough. Browser-reserved shortcuts can take precedence over an in-page command.
- The entire cell is crossed out: You selected the cell rather than a portion of its text. Edit the cell and select only the characters you want to format.
- The number still appears in a total: Strikethrough does not exclude a value from calculations. Change the formula or data structure if the number should no longer count.
- The effect is hard to see: Check the zoom level, font size, and display contrast. You can also open Format Cells to inspect whether Strikethrough is selected.
If a workbook uses a protected sheet, formatting may be restricted by the sheet’s protection settings. In that case, Excel may prevent a formatting change even when the shortcut is correct. Ask the workbook owner about the protection settings rather than repeatedly trying other key combinations.
When to use strikethrough—and when not to
Strikethrough works well for informal status tracking, revisions, and visible audit trails where readers should still be able to see the original entry. It can help distinguish completed items from open ones in a small checklist, or show a proposed deletion in a draft while preserving the wording for review.
For a larger tracker, relying on formatting alone can make the data difficult to filter or summarize. Consider adding a Status column with values such as “Open,” “In progress,” and “Done.” That gives each record an explicit state that can be filtered, counted, or used in a report. You can still use strikethrough as a visual cue, but the status value carries the information in a form that spreadsheet tools can work with.
For deleted or invalid data, use the appropriate data-editing action instead of crossing it out. For canceled transactions, for example, retaining the value and marking its status may be appropriate for a record, but a crossed-out number alone does not make it clear whether it should be included in a calculation. Decide what the data should mean, then make the formula and status fields reflect that meaning.
Frequently Asked Questions
What is the strikethrough shortcut in Excel for Windows?
Press Ctrl+5 after selecting the cell or range. It applies or removes the strikethrough font effect; it does not delete the contents.
What is the strikethrough shortcut in Excel for Mac?
In Excel for Mac, use Command+Shift+X. If that combination is unavailable or behaves differently in your setup, select the cells and use Home > Strikethrough.
Can I strikethrough only one word in an Excel cell?
Yes. Edit the cell, select the word’s characters, and apply the formatting. Selecting the cell without selecting its text applies the effect to the cell content as a whole.
Does strikethrough remove a value from a formula?
No. It changes how the value looks, not the value itself. Formulas continue to use the cell contents unless their own logic excludes them.
How do I remove strikethrough formatting?
Select the formatted cell or text and use the same shortcut again, or choose Home > Strikethrough. In Format Cells, clear the Strikethrough option and confirm.
Can Excel automatically cross out completed tasks?
You can use conditional formatting for a rule-based visual effect, such as formatting a task when its Status cell says “Done.” The status value remains the dependable record; formatting is only its visual presentation.
Related
- Keyboard Shortcut to Jump Tabs in Excel
- Excel Tab Rename Shortcut: Windows and Mac Steps
- Excel Keyboard Shortcuts to Resize Rows and Columns
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Solver Add-In: How It Works and How to Use ItExcel Solver is an optimization add-in that finds values for selected cells to maximize, minimize, or reach a…
- Text Excel File: How to Open, Import, and Save DataTo open a text file in Excel for Microsoft 365 on Windows, use Data > Get Data >…
- How to Freeze Two Columns in Excel While ScrollingTo keep columns A and B visible while you scroll horizontally in Excel for Microsoft 365 on Windows,…
- How to Schedule an Email in Outlook to Send It LaterTo schedule an email in Outlook, write your message, choose a future delivery time, and select Send. The…
- Excel Shortcut to Rename a Sheet in Windows and MacIn Excel for Microsoft 365 on Windows, press Alt, then H, O, and R to rename the active…
- Excel Dropdown List Box: Create, Edit, and TroubleshootIn Excel, a dropdown list box usually means an in-cell dropdown created with Data Validation: select a cell,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.