How to strikethrough text in Excel

Quick answer: To use strikethrough in Excel, select the cells and press Ctrl+5. If the shortcut does nothing, go to Home > Font, select the small arrow in the corner of the group to open Format Cells, select the Strikethrough check box under Effects and select OK. To cross out only a word, double-click the cell or press F2, select the characters, and apply the same format.

Applies to: Excel for Microsoft 365 and recent desktop versions on Windows. Microsoft’s Format text in cells page lists Excel 2024 and Excel 2021 for Windows and Mac; the Format Cells dialog it describes should look the same in Excel 2019 and 2016. Mac and the web get a short section near the end.

Method 1: Press Ctrl+5

On Windows, Ctrl+5 toggles strikethrough on the selected cells. Microsoft’s Keyboard shortcuts in Excel list gives Ctrl+5 to apply or remove strikethrough formatting. If your keyboard doesn’t respond to it, fall back to Method 2.

  1. Select a cell, a range, a whole row or a whole column.
  2. Hold Ctrl and press 5 in the number row above the letters, not on the numeric keypad.
  3. Press Ctrl+5 again to take the line off.

Strikethrough is a font format, like bold. It changes how the text looks and nothing else: the value stays in the cell, and formulas that refer to it keep using it. If you want crossed-out items left out of a total, you need a status column and a formula that checks it, not the format itself.

Method 2: Use the Format Cells dialog

This is the route Microsoft documents for the desktop app, and it works whether or not the shortcut does.

  1. Select the cells you want to cross out.
  2. On the Home tab, find the Font group and select the Dialog Box Launcher, the small arrow at its lower-right corner. Ctrl+1 opens the same dialog, according to Microsoft’s Excel shortcut list; switch to the Font tab if another tab opens.
  3. Under Effects, select the Strikethrough check box.
  4. Select OK.

The Effects area is also where Microsoft puts superscript and subscript, so the dialog is worth knowing for those as well. The preview box in the dialog shows the result before you confirm.

Method 3: Strike through part of a cell

Selecting a cell and applying strikethrough crosses out everything in it. To strike out one word in a longer note, format the characters instead of the cell:

  1. Double-click the cell, or select it and press F2, to start editing.
  2. Drag across the characters you want crossed out, or hold Shift and use the arrow keys.
  3. Press Ctrl+5, or press Ctrl+1 and select the Strikethrough check box in the dialog that opens. While you’re editing, that dialog should show only font options.
  4. Press Enter to finish.

This only works on typed text. A cell that holds a formula, or a number, can’t carry mixed formatting, so the whole result is crossed out or none of it. The Microsoft pages used here don’t cover character-level formatting, so check the result on your own sheet.

Method 4: Add a Strikethrough button to the Quick Access Toolbar

The ribbon doesn’t show a strikethrough button in the Font group, so if you’d rather click than use the keyboard, put one on the Quick Access Toolbar. Labels can vary slightly between versions:

  1. Go to File > Options > Quick Access Toolbar.
  2. In Choose commands from, pick All Commands (or Commands Not in the Ribbon).
  3. Scroll to Strikethrough, select it and select Add.
  4. Select OK. The button appears on the toolbar above or below the ribbon.

A Quick Access Toolbar button also gets an Alt key number, which gives you a second shortcut if Ctrl+5 is taken on your machine: press Alt and look for the number shown on the button.

Method 5: Strike through finished rows automatically

For a task list, conditional formatting can cross out a row once its status says it’s done, so you don’t format each row by hand. This example assumes tasks in A2:C50 and a status in column C; adjust the range and column to match your sheet.

  1. Select A2:C50, starting from row 2 so that A2 is the active cell.
  2. Go to Home > Conditional Formatting > New Rule.
  3. Choose Use a formula to determine which cells to format and enter the formula below.
  4. Select Format, open the Font tab, select the Strikethrough check box, then select OK twice.
=$C2="Done"

The dollar sign locks the column, so every cell in a row checks that row’s status. If you use checkboxes instead of a status word, the rule can test the cell the checkbox writes TRUE or FALSE to, for example =$C2=TRUE. How a checkbox stores its value depends on which kind you inserted, so check what the cell holds before writing the rule. To edit or delete the rule later, use Conditional Formatting > Manage Rules, the same place covered in How to remove duplicates in Excel.

How to remove strikethrough

Select the same cells and press Ctrl+5 again, or open Format Cells and clear the Strikethrough box. Microsoft’s Excel for the web page gives the same clear-the-box step. For part of a cell, edit it with F2 and select the crossed-out characters first.

If the line won’t go away, a conditional formatting rule may be adding it. Formatting set by a rule can’t be removed in Format Cells; check Conditional Formatting > Manage Rules for the selected cells. As a last resort, Home > Clear > Clear Formats removes strikethrough together with every other format on those cells, such as number formats and fill colors.

Excel for Mac and Excel for the web

Excel for Mac: Microsoft’s Format text in cells page lists Excel 2024 and 2021 for Mac, so the Format Cells route in Method 2 is the safe choice there. Command+Shift+X is the shortcut to try on a Mac, but it isn’t on the pages used for this guide; if it does nothing, use Format Cells.

Excel for the web: Microsoft’s page for the web version gives these steps: select the cells, go to Home > Font, select Font Settings to open Format Cells, select the Strikethrough check box and select OK. If Font Settings doesn’t appear in your version of the web app, open the workbook in the desktop app and use Method 1 or 2 there. Whether Ctrl+5 works in the browser isn’t stated there; it’s worth a try, but browser shortcuts can take precedence.

When strikethrough doesn’t work

Format Cells is the reliable fallback for each of these. The causes are possibilities to check, not a diagnosis.

What you seePossible causeWhat to try
Ctrl+5 does nothingYou pressed 5 on the numeric keypadUse the 5 in the number row
Ctrl+5 does nothing on a laptopThe number row needs Fn or a keyboard modeTry Fn+Ctrl+5, or use Format Cells
Another program reacts insteadA background app or hotkey tool uses Ctrl+5Close it, or add a Quick Access Toolbar button
Strikethrough option can’t be selectedThe sheet is protected or the cell is in edit modePress Enter or Esc; unprotect your sheet in Review
Line won’t clearA conditional formatting rule applies itEdit the rule in Manage Rules
Other keys misbehave tooA keyboard or Windows problemTest the keyboard outside Excel

A protected sheet blocks formatting unless its owner allowed it. If it’s your workbook, use Review > Unprotect Sheet and enter the password if one was set; if someone else protected it, ask them. Edit mode also switches off formatting buttons on the ribbon, as explained in Merge and Center not working in Excel. If other shortcuts or keys fail as well, start with Keyboard not working in Windows 11, and if the arrow keys scroll the sheet instead of moving the selection, see How to turn off Scroll Lock in Excel.

Sources

How we write our guides: read our editorial policy.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *