Understanding the Context

What is Strikethrough in Excel?

Strikethrough is a text formatting effect that crosses out characters across a cell by running a horizontal line through them. It’s ideal for showing deleted, completed, or invalid data without removing it from the worksheet—making it discreet yet immediately noticeable.

Excel’s strikethrough feature is built into the Home tab under the Font section, enabling users to quickly apply this effect with just a few clicks.

Key Insights

How to Apply Strikethrough in Excel

Applying strikethrough is simple and accessible:

1. Select the cell(s) you want to format.
   
2. Navigate to the Home tab on the ribbon.
   
3. Click the Font group.
   
4. Click the Strikethrough icon (∕ icon, looks like a crossed-out line).
   
5. The selected text will instantly display with a strikethrough effect.

For quick access, you can also use shortcut key Alt + I, then E, then E (again for Strikethrough) on Windows, or use the Font dialog box for more options.

• Move Strikethrough Feature:
  The strikethrough function isn’t limited to a single cell—it can span multiple consecutive cells. Just select a range (e.g., A1 to C1), apply strikethrough, and the effect applies across all cells in the selection simultaneously.

• Strikethrough with Font Color:
  Pair strikethrough with a diluted font color (e.g., gray or faint red) for subtle visual cues. Go to Font Settings > Color dropdown and choose a light tone for better presentation.

• Using Conditional Formatting:
  Combine strikethrough with conditional rules. For example, highlight overdue tasks by making due dates expired, then apply strikethrough to those cells automatically—keeping data clean and actionable.