How to Change Strikethrough Color in Excel Cells Easily

How-to basics · Updated November 20, 2026

Excel does not let you set a strikethrough line to a different color from the text. You can change the font color, which also changes the strikethrough, or add a separate colored line shape over the text if only the line should be a different color. The steps below explain both approaches for Excel for Microsoft 365 on Windows.

Changing the font color is the simplest option and keeps the effect attached to the cell’s text. A drawn line offers more control over color and thickness, but it is a separate object that may need repositioning if the worksheet changes.

What You’ll Need

  • Excel for Microsoft 365 on Windows, or a version of Excel with cell font formatting and worksheet shapes.
  • A workbook and the cell or cells you want to format. If you use a line shape, make sure the text is visible at a useful zoom level so you can position the line accurately.
  • For a colored line independent of the font color, plan to use a shape. Excel has no separate strikethrough-color setting in the Format Cells dialog.

Step-by-Step

  1. Select the cell or text to format. Click a cell to apply formatting to all of its contents. To strike through only part of a cell’s text, double-click the cell or click it and press F2, then drag across the characters in the formula bar or in the cell to select them. Partial-text formatting is not available for formula results in the same way as for manually entered text; if the cell contains a formula, format the whole cell or use a visual workaround. To format several cells, select the full range first. Hold Ctrl while clicking non-adjacent cells on Windows if you need to select separate cells.
  2. Open the cell formatting options. On Windows, press Ctrl+1 to open Format Cells. You can also right-click the selected cell and choose Format Cells. In the dialog, open the Font tab. On a Mac, Command+1 generally opens Format Cells; if your keyboard or Excel version uses a different shortcut, use the Format Cells command from the menu or context menu instead.
  3. Choose the font color you want. In the Font tab, open the Color palette and select a theme or standard color. This changes the text color, not just the strike line. You can also choose a font color from Home > Font Color on the ribbon. If you want to retain the current text color while changing only the strikethrough, do not apply this step; Excel does not offer that independent formatting option.
  4. Turn on strikethrough. Still on the Font tab, select the Strikethrough checkbox. Click OK to apply the formatting. The strikethrough will use the same color as the text. In many desktop versions, Ctrl+5 on Windows toggles strikethrough for the selected cell or cells; the Format Cells method is more explicit and is useful when changing font color at the same time.
  5. Check the result and adjust if needed. Confirm that the whole intended cell or text selection is crossed out. If the line is difficult to see, choose a more contrasting font color, increase the font size, or use a heavier typeface. These changes affect the text too, because the text and strikethrough share their color setting. Use Undo if you changed the wrong range, then select the correct cells and repeat the formatting steps.
  6. For a differently colored line, insert a shape instead. Select Insert > Shapes > Line. Move the pointer to the start of the text and drag across it to draw a line at the desired height. Select the line, open the Shape Format tab, choose Shape Outline, and select a color. Use Shape Outline > Weight to make the line thicker or thinner. The ribbon tab may appear only after the shape is selected. If you need the text itself to remain a different color, leave its font color unchanged and use the line shape as the visual strike.
  7. Position and maintain the shape carefully. Zoom in before placing the line, then zoom back out to check how it looks in the normal worksheet view. If the line is selected, use the arrow keys for small positional adjustments where supported, or drag it into place. A shape is not part of the cell’s text formatting: editing the text, changing row height or column width, sorting, or filtering can leave it in the wrong place. Save the workbook and review the line after making layout changes.
  8. Save and check another view if the file will be shared. Save the workbook as an Excel file. If another person will open it in Excel for the web or on a Mac, check the appearance there as well. Standard cell strikethrough and font color are more dependable than a precisely aligned overlay, whose position can look different after zoom or layout changes.

Common Mistakes

Expecting a separate strike-color control. The Format Cells dialog offers a font color and a strikethrough checkbox, but no color picker for the line alone. Choosing a different font color changes both the characters and the strike-through. If the text must keep its existing color, use a line shape or redesign the status display rather than repeatedly searching the Font tab for a missing option.

Applying the formatting to the wrong selection. If you select a range, Excel applies the formatting to every selected cell. If only some words in one manually entered cell should be crossed out, edit the cell and select those characters before opening Format Cells. A single click on the cell formats the whole cell’s contents, not an individual word.

Using a border as if it were a strikethrough. A colored cell border can make a horizontal rule, but it sits at an edge of the cell rather than through the text. It may be useful as a status marker, but it is not a true strike line. Choose a shape if the line must visibly pass through the characters.

Assuming a drawn line will move with the text. A line shape sits above the worksheet grid; it does not automatically track the exact letters or follow text that changes length. If the text or layout changes, inspect and reposition the shape. For frequently updated lists, normal strikethrough formatting is often more reliable, even though it cannot have a separate color.

Tips

  • Use color for a clear purpose. A colored strike can distinguish a completed item or a correction, but do not rely on color alone to communicate meaning. Keep labels such as Done or Removed where they help readers who cannot distinguish the colors.
  • Keep the line consistent. For several cells, duplicate a formatted line shape rather than drawing each one with a different thickness. Select the shape and copy and paste it, then position the copy over the next entry. Check each line after moving it; text lengths and row heights can vary.
  • Consider a separate status column. If the goal is to mark tasks complete, a Status column, checkbox, or clearly labeled completion value can be easier to sort, filter, and maintain than shapes positioned over text. You can still apply ordinary strikethrough to completed entries if the visual cue is useful.
  • Use cell formatting for routine edits. The native strikethrough setting follows the cell when it is moved or sorted as part of a range. A shape may not stay aligned with the matching record. Prefer the native effect when reliability matters more than a distinct line color.
  • Check the selected range before using shortcuts. Ctrl+5 toggles strikethrough on Windows, so pressing it again can remove the effect. It does not provide a color choice. On Mac, shortcut behavior can differ by keyboard and Excel release; use Format Cells if the shortcut does not work as expected.

Troubleshooting

The text changes color, but the strike does too. That is expected. Excel formats the strikethrough with the font color and cannot assign the two separate colors. Undo the font-color change if you need to restore the original text color, then use Insert > Shapes > Line and format its outline as described above.

The strikethrough checkbox is unavailable or the change will not stick. Check whether the sheet or workbook is protected. Protection can restrict formatting; if you have permission, use Review > Unprotect Sheet, make the change, and protect the sheet again if required. In a shared or read-only workbook, you may need an editable copy. Also confirm that you selected a cell rather than a shape or another object.

The line shape is hard to see or is misplaced. Select the line and use Shape Format > Shape Outline to check its color and weight. Zoom in to reposition it, then inspect it at the normal zoom. If the row or column dimensions changed, move the line again. Consider placing the line in a dedicated status area instead of crossing text if the sheet layout changes often.

The text looks crossed out but does not print as expected. Check Print Preview and confirm the shape is on the worksheet area being printed. If the line is a shape, make sure it lies within the print area and is not hidden behind another object. If the cell itself is formatted, verify that strikethrough is checked in Format Cells > Font. Printed size and page scaling can affect how thin lines appear, so increase the shape weight if necessary.

Frequently Asked Questions

Can I change only the strikethrough color in Excel?
No. Excel does not provide a separate color setting for the strikethrough. Its color follows the font color. A line shape is the practical visual workaround when the strike must differ from the text.

Will changing the font color change the strikethrough color too?
Yes. The text and its strikethrough use the same font color. Select the cell, choose the font color, and enable Strikethrough in Format Cells > Font to change both together.

Can I strikethrough only one word in a cell?
For manually entered text, edit the cell, select the word or characters, and apply Strikethrough through Format Cells > Font. A formula-generated result generally cannot have only part of its displayed text formatted this way; format the full cell or use a separate visual element.

Does conditional formatting let me set a separate strike-line color?
No. Conditional formatting can apply font formatting, including strikethrough in supported desktop Excel versions, but it does not provide an independent strikethrough color. Any applied strike follows the font color.

Will a colored line shape stay aligned when I sort or filter?
Do not rely on that. A shape is a separate worksheet object, and its position may not follow the matching text through sorting, filtering, or layout edits. Use cell formatting or a separate status column for lists that change frequently.

Can I do this in Excel for the web or on a Mac?
Excel for the web and Excel for Mac have cell font formatting, although ribbon layouts and shortcuts can differ. Look for the Strikethrough and Font Color controls or open the cell-formatting options. Shape tools are available in desktop Excel; check the web version’s Insert options if you plan to create or edit an overlay there. In all versions, the strikethrough color follows the font color.

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.