Excel Strikethrough Shortcut: Windows, Mac, and More

How-to basics · Updated November 20, 2026

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. On a Mac, the shortcut is Command+Shift+X. The formatting crosses out the displayed text without deleting or changing the cell’s value.

The Excel strikethrough shortcut on Windows

Ctrl+5 is a toggle in the desktop version of Excel for Windows: it turns strikethrough on for selected cells that do not have it, and turns it off when the selection already has it. You can use the number 5 on the main keyboard row. Select a cell, a group of cells, or a range first, then press both keys together.

For example, if a task list has an item in B3 that is complete, click B3 and press Ctrl+5. Excel displays a line through the cell’s contents. If you later reopen the task, select B3 and press the shortcut again. The text remains the same throughout; only its font formatting changes.

You can also apply the shortcut to a nonadjacent selection. Hold Ctrl while clicking the cells you want to format, then press Ctrl+5. For a continuous range, drag across the cells or select the first cell, hold Shift, and select the last. Check the selection before using the shortcut, since every selected cell can be affected.

Apply strikethrough from the ribbon or Format Cells

If you do not want to memorize a shortcut, use the Font settings. Select the cells, open the Home tab, and click the Font dialog box launcher—the small diagonal arrow in the lower-right corner of the Font group. In the Format Cells dialog, open the Font tab, check Strikethrough under Effects, and choose OK. To remove the line, repeat the steps and clear the checkbox.

The dialog is useful when you want to confirm whether formatting is already applied or combine it with other font choices. For example, you can select a range and set strikethrough alongside a font color or bold formatting in one visit. In many desktop installations, Ctrl+1 opens Format Cells directly; then choose the Font tab and use the Strikethrough checkbox. The ribbon method is easier to find if your keyboard layout or shortcut behavior is unfamiliar.

  • One cell: select the cell, then use the shortcut or Font settings.
  • A full range: select all relevant cells first; the formatting applies across the selection.
  • Remove it: select the formatted cells and use the same toggle shortcut, or clear the checkbox in Format Cells.

Mac and Excel for the web differences

In Excel for Microsoft 365 on Mac, select the cell or range and press Command+Shift+X. The Windows shortcut Ctrl+5 is not the Mac equivalent. If a keyboard layout, remote desktop, or customized shortcut setup makes the combination inconvenient, use the Format Cells dialog instead. On Mac, Command+1 opens Format Cells in supported desktop versions; the Font tab contains the Strikethrough effect.

Excel for the web also supports strikethrough formatting, and Ctrl+5 may work in its browser interface. Browser shortcuts can compete with spreadsheet shortcuts, however; for example, some browsers use that key combination to switch to a particular tab. If the keystroke changes tabs or does nothing, use the ribbon’s Font controls or open the formatting options in the Home tab. Excel for the web’s available controls and shortcut behavior can vary with the browser and interface updates.

When someone else opens the workbook in desktop Excel, Mac Excel, or the web app, the strikethrough formatting is generally part of the workbook, even if they use a different shortcut to change it. The shortcut is an input method, not a separate kind of file content.

Formatting a whole cell versus selected text

Most often, strikethrough is applied to an entire cell or range. To cross out only part of a cell’s text—for example, one word in a note—enter edit mode by double-clicking the cell or selecting it and pressing F2 on Windows. Select the characters you want within the cell’s text, then use the available font-formatting controls. Rich-text formatting inside a cell is more limited and less convenient than formatting the whole cell, and keyboard behavior can depend on the platform. If you cannot select and format just the characters as intended, place the crossed-out phrase in its own cell.

This distinction matters in a schedule. If cell C4 contains Call supplier; confirm delivery; file invoice, applying strikethrough to C4 crosses out the whole entry. It does not identify which of those three actions is complete. Separate tasks into different rows or cells when you need to mark them individually. The shortcut works on the selection you make, so deciding the right unit of information first prevents accidental over-formatting.

What strikethrough changes—and what it does not

Strikethrough is a visual font effect. It does not erase content, replace a value with a blank, or tell Excel that a record is canceled. A cell containing the number 125 still contains 125 after the line is applied; formulas that refer to that cell continue to use its value. Sorting, filtering, calculations, and exports generally treat the underlying value as before unless a separate rule or process has been set up.

That makes the effect handy for human-readable lists, revisions, and status notes, but it is not a reliable data flag by itself. A formula cannot ordinarily determine that a cell is struck through using a regular worksheet function. If later calculations need to distinguish completed from pending items, add an explicit status column such as Open or Complete. You can still use strikethrough as a visual cue, while the status value gives filters and formulas something dependable to evaluate.

Strikethrough also should not be confused with deleting or clearing a cell. Pressing Delete removes cell contents, while Clear Formats removes formatting but preserves the value. If a crossed-out value is still affecting a total, that is expected: the visual line does not exclude it from arithmetic.

Common shortcut problems and fixes

If Ctrl+5 appears not to work in Windows Excel, first make sure Excel has focus and that the intended cells are selected. A shortcut will not format the expected range if the active window is another application or if the selection is inside a dialog. Also check whether you are editing text in a cell; press Esc or Enter to leave edit mode, then select the cell itself and try again.

  • The line appears on only some cells: the selection may have included cells with mixed formatting. Select the complete intended range and apply the toggle again, then inspect the result.
  • The shortcut changes a browser tab: use Excel’s ribbon controls in the web app, or switch to desktop Excel if you need dependable keyboard access.
  • Pressing it removes the line: that is normal toggle behavior. The selection already had strikethrough, so the shortcut turned it off.
  • You cannot tell whether it is on: open Format Cells and inspect the Strikethrough checkbox, or test the shortcut on one cell rather than a large range.

Be particularly careful with mixed selections: one group of cells may already be struck through while another group is not. A toggle applied to a mixed selection can produce a result that seems inconsistent at a glance. To standardize a range, use the Font dialog and explicitly set the checkbox state, rather than relying on a toggle without checking the starting formatting.

When to use a status column or conditional formatting instead

Strikethrough is a good choice when the purpose is simply to show readers that an item is finished or no longer current. For shared workbooks, a dedicated status column is often clearer. It can contain consistent entries such as Not started, In progress, and Complete, which colleagues can filter, sort, count, or use in formulas. That also avoids relying on color or font appearance to communicate the underlying state.

Conditional formatting can automatically change a cell’s appearance when a value meets a rule, but it is not the same as manually pressing the strikethrough shortcut. For example, a rule based on a status field can format a task row when its status says Complete. This is useful when many rows need consistent treatment or statuses change frequently. Set up the rule from Home > Conditional Formatting and choose a rule type that matches the data; confirm the resulting format includes the visual effect you want. For one-off updates, the shortcut is usually faster.

Choose based on what the workbook must do. For a personal checklist, strikethrough may be enough. For reporting, shared tracking, or totals that should exclude completed records, use a status value and build the necessary filters or calculations around it. Appearance helps people scan a sheet; explicit data helps Excel process it.

Frequently Asked Questions

What is the strikethrough shortcut in Excel for Windows?
Use Ctrl+5 after selecting the cell or cells. Press it again to toggle the effect off.

What is the strikethrough shortcut in Excel for Mac?
Use Command+Shift+X in Excel for Mac. The Windows Ctrl+5 shortcut is different.

Does strikethrough delete the cell value?
No. It changes how the value is displayed, but the content remains in the cell and can still be used in formulas.

How do I remove strikethrough in Excel?
Select the affected cells and press the same shortcut used to apply it. You can also clear the Strikethrough checkbox in Format Cells.

Can I cross out only one word in a cell?
It may be possible by editing the cell and selecting particular characters, but applying a font effect to only part of a cell is less straightforward than formatting the whole cell. Put separate phrases in separate cells when precise, reliable formatting matters.

Why does Ctrl+5 switch browser tabs instead?
Some browsers use that combination for tab navigation, which can interfere with Excel for the web. Use the ribbon’s formatting controls, or open the workbook in desktop Excel and use its shortcut.

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.