In Excel for Microsoft 365 on Windows, select a cell and press Ctrl+5 to apply strikethrough; press the same shortcut again to remove it. On a Mac, the usual shortcut is Command+Shift+X. Strikethrough changes how the text looks, but it does not delete the cell’s contents.
The Excel shortcut and what it does
Strikethrough draws a horizontal line through the characters in a cell. It is a font effect, similar to bold or italic, rather than a special status or a command to remove data. In the Windows desktop version of Excel, Ctrl+5 toggles the effect for the current selection. You can select one cell, several cells, or a range before using it.
The shortcut is useful when you want a quick visual mark—for example, to show that a task is complete, an item has been reviewed, or a draft entry is no longer current. The crossed-out value remains in the worksheet. Excel can still calculate with it, search for it, copy it, and include it in sorting or filtering just as before.
Use the number 5 key in the shortcut, not a command to delete or replace the cell. If Ctrl+5 appears to do nothing, check that Excel has focus, that the intended cells are selected, and that the worksheet is not in a mode that prevents the command. The troubleshooting section below covers common causes.
Apply or remove strikethrough step by step
For ordinary cell contents, the quickest method is simply to select the cell or range and press Ctrl+5. There is no confirmation dialog. Look at the text to see whether the line appeared. With the same cell still selected, pressing Ctrl+5 again removes the formatting.
- Click a cell, or drag across the cells you want to format. Use Ctrl-click to add separate cells to a selection on Windows.
- Press Ctrl+5.
- Check the selected text. To reverse the change, press Ctrl+5 again.
If the selection contains cells with different formatting, the result can depend on the active cell and the selection’s mixed formatting state. Inspect the cells after applying the shortcut rather than assuming every cell started in the same state. You can also use the Format Cells dialog when you want to see the setting directly.
Use the ribbon or Format Cells dialog
The ribbon provides a visual alternative, although the Strikethrough command is not one of the prominent buttons in the Home tab’s Font group. To open the detailed font settings in Excel for Windows, select the cells and press Ctrl+1. In the Format Cells dialog, open the Font tab, select the Strikethrough checkbox under Effects, and choose OK. Clear the checkbox to remove the effect.
You can reach the same dialog with the ribbon: go to Home, then click the small dialog box launcher at the lower-right corner of the Font group. Choose the Font tab and use the Strikethrough checkbox. This route is handy when you are already changing typeface, size, color, underline, or other font options and want to confirm which effects are enabled.
On Windows, Ctrl+1 is a shortcut to Format Cells, not a shortcut that toggles strikethrough on its own. That distinction matters: Ctrl+5 is the fast toggle, while Ctrl+1 opens a dialog where you choose the setting. The dialog is also useful for checking a cell when it is not obvious whether the line is caused by formatting or is part of a shape or image placed over the text.
Windows, Mac, and Excel for the web
Excel’s keyboard shortcuts differ by platform. In the Windows desktop application, use Ctrl+5. In Excel for Mac, the usual strikethrough shortcut is Command+Shift+X. Mac keyboards label the Command key with the ⌘ symbol. If a shortcut is intercepted by another app, keyboard utility, or a customized setting, use the Font tab in Format Cells instead.
In Excel for the web, Ctrl+5 is available in many browser and keyboard configurations, but browser shortcuts and the web app’s shortcut handling can affect what happens. If it does not work, select the cells and use the formatting controls on the Home tab, or open the cell-formatting options available in your version of the web app. Excel for the web does not have every desktop command in precisely the same place, and menus may vary as Microsoft updates the interface.
Do not assume that a shortcut documented for Windows has the same keys on a Mac. Likewise, remote desktop software and non-English keyboard layouts can change how a key combination is delivered. If you use Excel regularly on more than one platform, learning the relevant shortcut for each one—or using the dialog route as a consistent fallback—can save time.
Cross out only part of a cell’s text
Ctrl+5 normally formats the whole contents of each selected cell. To cross out only a word or a few characters in a text entry, edit the cell and select the specific characters first. Double-click the cell or select it and press F2 on Windows, place the insertion point in the text, and highlight the characters. Then apply the strikethrough formatting. You can also edit in the formula bar and select the relevant characters there.
For example, a cell containing Call Sam about the venue could have only the words about the venue crossed out if the plan changed but you want to preserve the rest of the note. Partial-character formatting is most suitable for text entered directly into a cell. Formula results are different: Excel formats a formula cell as a whole, and a formula cannot dynamically apply strikethrough to just selected characters of its returned text.
When editing, take care not to replace the cell’s contents accidentally. If you highlight text and type, the selected characters are replaced. Use the formatting shortcut without typing, then press Enter or click outside the cell to finish editing. If the selection is difficult to see, widen the formula bar or use the Format Cells dialog after selecting the cell.
When strikethrough is useful—and when it is not
Strikethrough is a visual convention, not a data-management feature. It can make a checklist easier to scan, indicate that a line in a draft has been rejected, or show that a spreadsheet entry has been reviewed. In a shared workbook, explain what the mark means if readers might interpret it differently. A crossed-out row could mean completed, cancelled, superseded, or simply corrected; Excel does not attach any of those meanings automatically.
For a task list, for example, you might cross out the words in a completed task while leaving its owner and due date visible. For an inventory sheet, crossing out an item does not change its quantity or remove it from a total. If you need calculations to exclude completed or cancelled records, use a separate status column and base the calculation or filter on that status. Do not rely on font appearance as the only record of whether a row should count.
Strikethrough may also be less clear for readers using assistive technology or for anyone viewing a printed copy with poor contrast. Consider adding a plain-text status such as Done, Cancelled, or Replaced in another column. That makes the meaning searchable and explicit, while strikethrough can remain a supplementary visual cue.
Common problems and quick fixes
- The shortcut does not respond: Click a worksheet cell so Excel is active, then try Ctrl+5 again. Confirm you are using the Windows desktop app and not a different spreadsheet program or a browser tab with focus elsewhere.
- The line is hard to see: Zoom in, check the text color and font size, and inspect the Font tab in Format Cells. A thin line can be difficult to notice in a small cell or on a display with low contrast.
- The whole cell changes instead of one word: That is expected when the cell is selected normally. Edit the cell, select the characters within the text, and apply the effect to that selection.
- The text remains in totals: Strikethrough does not exclude values from formulas. Add or use a status field and make the calculation depend on that field if the value should no longer be counted.
- The mark returns after editing: Check whether a cell style, copied formatting, or a conditional formatting rule is applying the appearance. Direct formatting and conditional formatting are separate mechanisms, so removing one may not remove the other.
To remove ordinary direct strikethrough formatting, select the cell and press the appropriate toggle again, or clear the Strikethrough checkbox in Format Cells. Avoid using Clear All as a quick fix unless you really intend to remove other contents and formatting too. If the line is caused by conditional formatting, review the rule through Home > Conditional Formatting > Manage Rules and adjust or delete the relevant rule instead.
Strikethrough versus deleting or hiding data
Crossing out text is not the same as deleting it. Pressing Delete or Backspace can clear cell contents, depending on the selection and Excel’s behavior; strikethrough leaves the value intact. Nor does the effect hide data. Anyone can still read, copy, search, or calculate with a crossed-out value. Use deletion only when the data should actually be removed, and use a separate status or archive process when you need to retain a record but distinguish it from active information.
It is also different from hiding a row or column. Hidden rows are not displayed in the usual worksheet view, while strikethrough remains visible on the text. Neither method by itself provides access control or protects sensitive information. If a workbook is shared, choose a clear data structure and appropriate sharing permissions rather than treating a visual format as a safeguard.
Frequently Asked Questions
What is the strikethrough shortcut in Excel for Windows?
Press Ctrl+5 with the cell or range selected. Press Ctrl+5 again to toggle the effect off.
What is the strikethrough shortcut in Excel for Mac?
The usual Mac shortcut is Command+Shift+X. If it is unavailable in your setup, use the Font tab in the Format Cells dialog.
Does strikethrough delete a value or remove it from a formula?
No. It changes the font appearance only. The cell’s value remains available to formulas, searches, and other workbook operations.
Can I cross out just one word in a cell?
Yes, for text entered directly in the cell. Edit the cell, select the characters you want to mark, and apply strikethrough. Selecting the cell normally applies the effect to the entire cell contents.
Why is Ctrl+5 not working in Excel?
Make sure Excel has keyboard focus and that you are using the Windows desktop app. A browser, remote session, keyboard layout, or another utility may interfere; the Format Cells dialog is a reliable visual alternative.
Related
- How to Unmerge Excel Files in Microsoft Excel
- Unmerge Cells in Excel: Keyboard Shortcuts and Steps
- How to Unmerge Cells in Excel and Keep Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Print Area Lines: How to Hide Them CorrectlyTo hide Excel’s dotted page-break lines without changing what prints, go to File > Options > Advanced, find…
- Excel Turn Off Circular Reference Warning?Excel has no separate setting that simply hides circular-reference warnings while continuing to flag circular formulas. To stop…
- How to Encrypt a Microsoft Excel File with a PasswordTo encrypt an Excel file in Microsoft 365 for Windows, open the workbook and choose File > Info…
- How to Delete a Full Page in Word: Step-by-StepTo delete a full page in Word, click anywhere on that page, open Go To, enter \page, and…
- Excel Consolidate Rows and Sum Data: A Practical GuideYes. To combine repeated labels and add their values in Excel, create a PivotTable and put the label…
- Excel Day Number: Serial Dates, Day of Month and YearIf A2 contains a valid Excel date such as June 15, 2024, and you want its day of…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.