Strikethrough in Excel: Keyboard Shortcut and How to Use It

How-to basics · Updated November 20, 2026

To apply or remove strikethrough in Excel for Microsoft 365 on Windows, select the cell or cells and press Ctrl+5. The shortcut toggles a line through the selected cell’s contents, so pressing it again removes the line. You do not need to change the cell value or add a formula; this is a formatting option.

What You’ll Need

  • Excel for Microsoft 365 on a Windows computer for the steps below. The Mac shortcut is included where it differs.
  • A workbook open in Excel, and the cell or text you want to mark. If the workbook is read-only or protected, you may need permission to change its formatting.

Step-by-Step

  1. Open the worksheet. Open the workbook and go to the sheet containing the item you want to mark. Strikethrough is useful for showing a completed task, a discontinued product, or an entry that should remain visible but no longer applies. It changes how content looks; it does not delete the content.
  2. Select the target cell or cells. Click one cell to mark its contents. To format a range, drag across the cells or click the first cell, hold Shift, and click the last cell. To select separate cells, hold Ctrl while clicking each one. Check the selection before applying the shortcut, especially if the sheet contains important data nearby.
  3. Press the shortcut. On Windows, press Ctrl+5 together. Use the number 5 on the regular number row or numeric keypad; the number-row key is the simplest choice if your keyboard has a separate keypad. Do not hold Shift unless your keyboard requires it to type the character 5. Excel applies strikethrough to the selected cell contents.
  4. Check the result. Look at the selected cell or cells and confirm that a line now crosses the text or number. If the cells were already formatted with strikethrough, the same shortcut removes it. The shortcut is a toggle, not a one-way apply command, so check the current appearance before pressing it a second time.
  5. Apply it to only part of a cell’s text, if needed. Click the cell, then press F2 to edit it in place. Use the arrow keys with Shift to select the characters you want to format, or select the text in the formula bar. Press Ctrl+5 while that text is selected. Partial-text formatting is more precise than formatting the whole cell; check that only the intended characters have the line. If the shortcut exits editing or does not format the selection in your Excel setup, use the Format Cells method in Troubleshooting.
  6. Use the Mac equivalent when working in Excel for Mac. Select the cell or text, then press Command+Shift+X. Mac keyboards and Excel settings can vary, so if that key combination is intercepted or does nothing, use the Font options in the Format Cells dialog instead. The Windows Ctrl+5 shortcut is not the Mac shortcut.
  7. Continue working or save your workbook. After checking the formatting, click another cell or press an arrow key to leave the selection. Save with Ctrl+S on Windows, or Command+S on Mac. Saving preserves the formatting along with the rest of the workbook.

For a ribbon-based alternative in desktop Excel, select the cells, open Home, and click the small dialog launcher in the Font group. In the Format Cells dialog, choose the Font tab, select Strikethrough under Effects, and click OK. This is handy when you cannot remember the shortcut or want to confirm the setting directly.

Common Mistakes

  • Pressing the wrong number combination. The Windows shortcut is Ctrl+5, not Ctrl+Shift+5. Ctrl+Shift+5 is associated with number formatting in Excel, so it can change how a value is displayed rather than strike it through.
  • Selecting the wrong cells. Excel formats the current selection. If a whole row, column, or range is highlighted, the shortcut may affect more cells than intended. Click a single cell to reset the selection before trying again.
  • Assuming strikethrough deletes or excludes data. It is visual formatting only. The value remains in the cell, can still be used in calculations, and may still appear in sorting, filtering, or exports.
  • Pressing the toggle twice. Pressing Ctrl+5 a second time removes the formatting. If the line disappears, the shortcut is working; it has simply toggled the setting off.
  • Using Windows instructions on a Mac or in a browser. Mac uses a different shortcut. In Excel for the web, browser or operating-system shortcuts may take priority, so use the ribbon’s Font options if Ctrl+5 does not reach Excel.

Tips

  • Use strikethrough to show status without losing a record. For example, a project list can retain the names of completed tasks while visually distinguishing them from work that remains. If you later need to reverse the status, the original text is still there.
  • Format a batch in one action. Select all the intended cells first, then press Ctrl+5 once. This is quicker and more consistent than clicking each cell and applying the shortcut separately. For a large non-contiguous selection, review it carefully before formatting.
  • Keep meaning clear for other readers. A line through text may communicate completion to people who can see the formatting, but it is not a structured status field. For tracking or reporting, consider keeping a separate Status column as well, such as Open or Complete.
  • Use the Font dialog when you want a visible setting. The Format Cells dialog shows whether Strikethrough is selected and is easier to use when keyboard shortcuts are unfamiliar. The same dialog also lets you change other font properties without changing the cell’s value.
  • Remember that formatting can be copied. If you want the same look in other cells, use Format Painter on the Home tab or copy and paste formatting with Paste Special. Check the result, since copying formats may also copy other font, fill, border, or number-format settings depending on the method used.
  • Consider accessibility and printing. Strikethrough can be subtle on small text or in a low-quality printout. Pair it with a clear label or status value if readers must be able to identify the meaning reliably.

Troubleshooting

Ctrl+5 does nothing: First click a cell in the worksheet so Excel has focus, then try the shortcut again. If you are editing text, press Esc to leave edit mode, select the cell, and test the shortcut. Check whether another application, remote desktop layer, keyboard utility, or browser is capturing the key combination. On a laptop, try the number 5 on the top number row rather than relying on a function-layer or keypad combination.

The shortcut changes number formatting or types a character: Make sure you pressed Ctrl+5 without Shift. If your keyboard layout makes the number-row key awkward to use, avoid experimenting on important data; select the cell and use Home > Font dialog launcher > Font tab > Strikethrough instead. Click OK and inspect the cell.

The whole cell is crossed out, but only some words should be: Undo immediately with Ctrl+Z if you just applied the formatting to the wrong selection. Then edit the cell with F2, select only the intended characters, and apply the shortcut. If that still does not work, select the text in the formula bar and open Format Cells with Ctrl+1; on the Font tab, set Strikethrough and confirm. The dialog may behave differently depending on whether a cell or only part of its text is selected, so verify the result before continuing.

You cannot change the formatting: Look for a message that the sheet or workbook is protected, or for a read-only indicator in the title bar. If the sheet is protected, you may need the owner or password to unprotect it. If the file is read-only, save an editable copy if you are authorized to do so. Also check whether the selected cells are part of a locked or restricted area.

It works on one cell but not several: Confirm that the cells you intend to change are all selected and that you are not in cell-edit mode. For a mixed selection, some cells may already have strikethrough, so the result can look inconsistent. Test one cell first, then apply the shortcut to the full range and inspect each part of the selection.

Frequently Asked Questions

What is the keyboard shortcut for strikethrough in Excel?
In Excel for Microsoft 365 on Windows, select the target cell or cells and press Ctrl+5. It toggles strikethrough on or off.

What is the strikethrough shortcut on Mac?
In Excel for Mac, select the cell or text and press Command+Shift+X. If your keyboard or settings intercept the combination, use the Font tab in the Format Cells dialog.

Can I strikethrough only part of the text in a cell?
Yes. Edit the cell with F2, select the characters you want to format, and apply the shortcut. You can also select text in the formula bar. Check the result to make sure the formatting did not apply to the entire cell.

Does strikethrough remove the value from formulas?
No. It changes the appearance, not the contents. A crossed-out number or text remains in the cell and can still be included in calculations. Remove or exclude the value separately if that is what you intend.

How do I remove strikethrough?
Select the formatted cell or text and press Ctrl+5 on Windows, or Command+Shift+X on Mac. Because the shortcut toggles the setting, it removes the line when strikethrough is currently on. You can also clear the Strikethrough checkbox in Format Cells.

Will the shortcut work in Excel for the web?
It may depend on the browser and keyboard handling. If Ctrl+5 switches browser tabs or does not format the selection, use Excel’s Home tab and Font controls, or open the workbook in the desktop app.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.