Excel Strikethrough Shortcut: How to Cross Out Text

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select the cell or cells you want to mark and press Ctrl+5 to apply strikethrough; press it again to remove the line. On a Mac, use Command+Shift+X. Strikethrough adds a line through cell text without deleting or changing its value, making it useful for marking completed tasks or outdated entries.

What You’ll Need

  • A workbook open in Excel, with the cells or text you want to format.
  • A keyboard. The shortcut depends on whether you are using Windows or a Mac.
  • If you use Excel for the web, access to the Home ribbon; browser keyboard shortcuts can sometimes affect which shortcut works.

You do not need to enable a setting or install an add-in. The strikethrough command is a font-formatting option, so it changes how selected content looks rather than the underlying number, date, or text. The formatting is saved with the workbook when you save it.

Step-by-Step

  1. Open the workbook and identify the target. Find the cell, group of cells, or text you want to cross out. If you are marking a task complete, for example, click the cell containing the task name. You can also select a value, such as an old price, without deleting it.
  2. Select the cell or cells. Click one cell to format its contents. To format a continuous range, click the first cell and drag across the range, or click the first cell and hold Shift while selecting the last. To choose separate cells, hold Ctrl while clicking each cell on Windows; on a Mac, hold Command while clicking. The shortcut applies to the current selection, so check that it does not include headings or other cells you did not intend to change.
  3. Use the keyboard shortcut for your computer. On Windows, press Ctrl+5 (hold Ctrl and tap the 5 key). On a Mac using the Excel desktop app, press Command+Shift+X. Use the number-row 5 key if the numeric keypad or keyboard layout makes the shortcut unclear. You generally do not need to hold Shift on Windows.
  4. Check the result. A horizontal line should appear through the text or value in the selected cell or cells. The cell remains in place, and its contents are still available for formulas, sorting, copying, and editing. Strikethrough is a visual font effect, not a status value that Excel can automatically interpret as “done.”
  5. Press the shortcut again to remove it. Keep the same cell or range selected and press Ctrl+5 on Windows or Command+Shift+X on a Mac again. The shortcut toggles the effect: it adds strikethrough when it is off and removes it when it is on. If you have selected cells with mixed formatting, inspect the result after toggling, because the selection may contain both struck-through and regular text.
  6. For Excel for the web, use the ribbon if the shortcut is intercepted. Select the cell or cells, open the Home tab, and choose the Strikethrough button in the Font group if it is shown. Keyboard behavior in a browser can depend on the browser and keyboard layout. If Ctrl+5 switches browser tabs or does something unexpected, use the ribbon rather than repeatedly pressing the shortcut.
  7. Save the workbook. Save as usual when you want the formatting change retained. Strikethrough is part of the cell’s formatting and will normally remain when the workbook is reopened or shared in a compatible spreadsheet app.

To cross out only part of a cell’s text: select the cell, then press F2 or click in the formula bar to edit its contents. Select the characters you want to format inside the cell or formula bar, then use the shortcut. If selecting characters in the cell is awkward, the formula bar may be easier. Partial formatting is for text in a cell; you cannot apply a separate strikethrough to just one portion of a formula’s calculated result in the same way. For a formula result, formatting generally applies to the cell display as a whole.

You can also use the Format Cells dialog when you prefer a visible setting or need to confirm the formatting state. Select the cell or range, press Ctrl+1 on Windows, open the Font tab, select the Strikethrough checkbox, and choose OK. On a Mac, open Format > Cells and use the Font options in the dialog. This dialog is also useful if the keyboard shortcut is unavailable or conflicts with another command.

Common Mistakes

  • Pressing the wrong key combination. The Windows shortcut is Ctrl+5, not Ctrl+Shift+5. Shift is part of the Mac shortcut, but not the standard Windows one. On keyboards where the 5 key also types another character with Shift, avoid adding Shift on Windows.
  • Formatting the wrong selection. If a whole row, column, or large range is selected, the effect can apply much more broadly than intended. Click a single cell first if you only want to cross out one entry, then check the selection border before using the shortcut.
  • Expecting the shortcut to delete or complete something. Strikethrough changes appearance only. It does not remove a task, change a value to zero, mark a checkbox, or make a formula treat the row as completed. Use a separate status column or actual deletion when the underlying data needs to change.
  • Using a browser shortcut by accident. In Excel for the web, the browser may claim a key combination. If Ctrl+5 changes the active browser tab, it has not formatted the cell. Use the ribbon command or open the workbook in the desktop app.
  • Assuming the line is missing because the text is short. At some zoom levels, a thin line can be hard to see, especially over small text or a busy cell fill. Increase the zoom or inspect the Font settings rather than applying the command repeatedly.

Tips

  • Use it as a visual cue, not your only record of status. If you need to filter for completed tasks, count them, or report progress, add a Status column with values such as “Done” and “Open.” You can still use strikethrough as an extra visual signal.
  • Apply it to a range in one go. Select all relevant cells before using Ctrl+5 or the Mac equivalent. This is faster than formatting each row separately, but confirm the range carefully when the worksheet contains neighboring data.
  • Combine it with a clear workflow. For a simple checklist, keep the task description in one column and a completion status in another. That way, readers can understand the mark and filter the list without relying on visual formatting alone.
  • Use Format Cells to verify a cell’s setting. If you are unsure whether strikethrough is active, open the Font tab in the Format Cells dialog. A checked option indicates the effect is applied to the selected cell; a mixed selection may not display a single clear state.
  • Remember that formatting can be copied. Copying a struck-through cell can also copy its formatting, depending on how you paste. If you want only the value or text elsewhere, use Paste Special or choose a values-only paste option rather than a regular paste.
  • Consider accessibility and print readability. A line through text may be hard for some readers to distinguish from an edit mark, and it does not explain why an entry is crossed out. Use a status label or note when the meaning matters, and check print preview if the worksheet will be printed.

Troubleshooting

Nothing happens when you press Ctrl+5. Confirm that Excel, rather than another window, is active and that a cell or text selection has focus. Try the Font tab in Format Cells instead: select the cell, press Ctrl+1, choose Font, check Strikethrough, and select OK. If you are editing text in a cell, make sure the text selection—not another application or dialog—has focus before trying a character-level change.

The shortcut changes browser tabs. This can happen in a web browser that uses Ctrl+5 to jump to a tab. Use Home > Strikethrough in Excel for the web, or open the workbook in desktop Excel and use Ctrl+5. Do not keep pressing the key combination if the browser is responding instead of the worksheet.

The Mac shortcut does not work. Check that you are using Excel for Mac and press Command+Shift+X together. Keyboard layouts and system settings can affect shortcuts. As a dependable alternative, open Format > Cells, go to Font, and select Strikethrough. If the command is unavailable while editing, finish editing the cell, select the cell, and apply the effect to the cell contents.

Only some cells changed. Check whether the intended cells were all selected before you pressed the shortcut. Undo with Ctrl+Z on Windows or Command+Z on Mac if the change affected the wrong range, then select the correct cells and try again. Undo is appropriate for ordinary formatting actions; if you have made other changes since, inspect them before undoing so you do not reverse unrelated work.

The line appears on only part of the text, or on all of it. A cell selection targets the cell’s formatting, while selecting characters during cell editing targets only that text where partial formatting is supported. Press Esc if you entered an edit mode by mistake, select the cell itself, and apply the shortcut again if you want the entire cell’s contents formatted. For a formula result, apply the effect to the cell rather than trying to format characters produced by the formula.

The effect remains after you press the shortcut again. First click the affected cell or select the affected range again; the shortcut only acts on the current selection. If the selection includes a mix of formats, use the Format Cells dialog to set the Strikethrough checkbox explicitly. Confirm with OK, then check the cell. If a conditional formatting rule or a pasted format is involved, inspect the formatting rules or remove unwanted formatting as a separate step.

Frequently Asked Questions

What is the strikethrough shortcut in Excel for Windows?
In Excel for Microsoft 365 on Windows, select the cell or range and press Ctrl+5. Press Ctrl+5 again to toggle the effect off.

What is the strikethrough shortcut in Excel for Mac?
In the Excel desktop app for Mac, select the cell or range and press Command+Shift+X. If it does not work with your keyboard setup, use Format > Cells and choose Strikethrough on the Font tab.

Does strikethrough delete the cell’s contents?
No. It changes the text’s appearance only. The value remains in the cell and can still be used in formulas, copied, or edited.

Can I strikethrough only a few words in a cell?
For ordinary text, edit the cell, select the characters you want to mark, and apply the effect. Selecting a cell and using the shortcut formats the cell contents; formula-generated text does not support formatting just one portion of its displayed result in the same way.

Can Excel filter rows by strikethrough?
Strikethrough alone is not a dependable task-status field for filtering or calculations. Add a separate column with a status such as Done or Open if you need to sort, filter, count, or report those entries.

Can I use the shortcut in Excel for the web?
It may depend on the browser and keyboard setup. If Ctrl+5 is intercepted by the browser, select the cells and use the Strikethrough command on the Home tab instead.

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.