How to Enable Strikethrough in Excel with Shortcuts

How-to basics · Updated November 20, 2026

To enable strikethrough in Excel for Microsoft 365 on Windows, select the cell or cells and press Ctrl+5. Press the same shortcut again to remove it. You can also open the Font settings and check Strikethrough. Strikethrough adds a line through text; it changes the cell’s appearance, not its value, so it is useful for marking completed items without deleting them.

What You’ll Need

  • Excel for Microsoft 365 on Windows, or another Excel version with cell formatting.
  • A workbook and the cell or range you want to format. If the workbook is read-only or you lack editing permission, you will need an editable copy or permission to make changes.
  • For a keyboard shortcut, a keyboard that can send Ctrl+5. On some laptops, the number row is easier to use than the numeric keypad.

Step-by-Step

  1. Open the workbook and identify the text. Open the Excel file, then find the cell, cells, or list entries you want to mark. Strikethrough is a font effect, so it works on text and numbers displayed in cells. It does not delete content or change a formula’s result.
  2. Select the target cell or range. Click one cell to format it. To format a continuous block, click the first cell and drag to the last, or click the first cell and hold Shift while clicking the last. To choose several separate cells on Windows, hold Ctrl as you click each one. Make sure the selection outline includes only the intended cells.
  3. Use the Windows shortcut. With the cells selected, press Ctrl+5. Excel applies strikethrough to the selected cells. You do not need to hold the keys for a long time; press them together once, then look at the cell text to confirm the line appears. If your keyboard has a numeric keypad, use the 5 on the main number row first, since keypad behavior can vary by keyboard and Num Lock setting.
  4. Use the Font dialog if you prefer menus. Select the cell or range, then press Ctrl+1 to open Format Cells. Choose the Font tab, find the Effects area, select the Strikethrough checkbox, and click OK. The line should now appear through the contents of each selected cell. This method is also useful when you want to check whether strikethrough is already enabled.
  5. Find the same setting from the ribbon. Select the target cells and open the Home tab. In the Font group, select the small dialog box launcher in the group’s lower-right corner. In Format Cells, choose Font, check Strikethrough under Effects, and select OK. The launcher may be easy to miss if the Excel window is narrow; maximize the window or expand the ribbon if needed.
  6. Check the result and save. Confirm that the line crosses the intended cell text, not neighboring entries. Save the workbook with Ctrl+S. If you applied the effect to the wrong selection, use Ctrl+Z promptly to undo the change, then select the correct cells and try again.

On Mac: In Excel for Mac, select the cells and use Command+Shift+X to toggle strikethrough. The menu-based route is to open Format Cells, choose Font, select Strikethrough, and confirm. Mac ribbon layouts can differ slightly by release, so use the Format Cells dialog if you cannot find the Font controls. In Excel for the web, try Ctrl+5 on Windows, or use the Font options on the Home tab if the shortcut is intercepted or unavailable.

Common Mistakes

  • Typing the shortcut while editing a cell. If you are entering or changing text inside a cell, Excel may treat keystrokes as part of that editing task rather than as a formatting command. Press Enter or Esc to leave edit mode, select the cell normally, and then use the shortcut. If you meant to format only the entire cell, check that the selection border is visible before applying the effect.
  • Selecting the wrong range. A drag can include an extra row or column, and a whole-column selection can affect cells you did not intend to mark. Review the highlighted area before pressing Ctrl+5. For a large range, click its first cell, hold Shift, and click its last cell rather than dragging past the edge.
  • Assuming strikethrough deletes or completes an item. The content remains in the cell, and formulas that refer to it still calculate from its value. If a task list needs a separate completion status for sorting or reporting, use a status column as well; a visual line alone does not tell Excel that the item is complete.
  • Expecting one toggle to make every selected cell look identical. Selected cells might already have different font effects. Check the result after applying the shortcut, especially with a mixed selection, and use Format Cells to inspect or set the desired effect directly.

Tips

  • Use the shortcut for quick, reversible marking. Ctrl+5 is convenient when working through a short checklist. It toggles the effect, so pressing it again on a cell removes strikethrough. Avoid pressing it repeatedly without checking the result, particularly when multiple cells are selected.
  • Keep completion data separate from appearance. For a tracker that you need to filter, count, or summarize, consider adding a Status column with values such as Not started and Done. Strikethrough can then act as a visual cue, while the status value remains usable for sorting and reports.
  • Use a consistent convention in shared workbooks. Decide whether the line means completed, cancelled, or no longer current, and tell collaborators. Strikethrough is only a visual formatting choice; another person may not infer the same meaning without a key or status label.
  • Apply formatting to a whole range at once. When many cells need the same effect, select the range first and apply the setting once. This is generally quicker and more consistent than editing each cell individually. Save and inspect a few entries across the range to make sure the selection was correct.

Troubleshooting

  • Ctrl+5 does nothing: First confirm that Excel, rather than a cell’s text-editing cursor, has focus. Select a cell and try again. If your laptop requires a function or number-layer key to type 5, use that key combination, or use Ctrl+1 and the Font tab instead. A remote desktop, browser, or other utility may also capture a shortcut; the dialog method avoids relying on Ctrl+5.
  • The line is hard to see: Zoom in, widen the column, or check the cell in the formula bar and on the worksheet. A small font, narrow column, or display scaling can make a thin line difficult to notice. The Font tab in Format Cells can confirm whether Strikethrough is checked even when the effect is subtle.
  • Only some selected cells changed: Check whether you selected all intended cells and whether the sheet is protected. A protected worksheet can prevent formatting, depending on its permissions. If you have authorization, ask the workbook owner to allow formatting or provide an editable copy; do not remove protection without permission.
  • The setting is unavailable or the workbook will not keep it: Check whether the file is open in a read-only state, whether editing is enabled, and whether you have permission to save changes. Some shared or protected files restrict formatting. Save an editable copy if permitted, apply the effect there, and confirm that the file is saved in a format that preserves Excel cell formatting.
  • The effect appears to return after editing: If you make a change and strikethrough disappears, inspect the cell’s Font settings again and check whether another process or shared editor is changing its formatting. Reapply it through Format Cells, save, close and reopen the workbook, and see whether the change persists. If the workbook uses automation or is controlled by another person, ask its owner before changing those settings.

Frequently Asked Questions

What is the shortcut for strikethrough in Excel on Windows?
For Excel on Windows, select the cell or range and press Ctrl+5. Press it again to toggle the effect off. If the shortcut does not work, select the cells and use Format Cells > Font > Strikethrough.

How do I remove strikethrough in Excel?
Select the affected cell or cells and press Ctrl+5 again. Alternatively, open Format Cells, choose Font, clear the Strikethrough checkbox, and select OK. This removes the line but leaves the cell’s contents intact.

Can I strike through only part of the text in a cell?
Yes, Excel can apply font formatting to selected characters in a cell. Enter edit mode by double-clicking the cell or selecting it and pressing F2, select the characters, then use the available Font formatting controls. Because ribbon controls can behave differently while you are editing text, the safest approach is to select the characters first and use the Font dialog if the ribbon option is unavailable. Check the result before leaving the cell.

Can I apply strikethrough to several cells at once?
Yes. Select a continuous range, or select separate cells while holding Ctrl on Windows, then press Ctrl+5 or use the Font dialog. Confirm the highlighted selection before applying the effect so unrelated cells are not changed.

Does strikethrough change a cell’s value or formula?
No. It changes how the contents look, not what the cell contains. A number remains the same number, and formulas that use the cell continue to reference its value. Use a separate status field or change the data itself if you need Excel to treat an item differently.

What is the Mac shortcut for strikethrough?
In Excel for Mac, select the target cells and press Command+Shift+X. If that shortcut is unavailable in your version or conflicts with another command, use Format Cells and select Strikethrough on the Font tab.

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.