# How to Apply Strikethrough in Excel: The Complete Formatting Guide

> Learn how to apply and remove strikethrough in Excel using keyboard shortcuts and the Format Cells dialog box to cross out text without deleting data.

- Canonical URL: https://coreiten.com/en/article/how-to-apply-strikethrough-in-excel-the-complete-formatting-guide
- Language: en
- Section: How To
- Author: Sami
- Published: 2026-06-30T04:01:41+03:00
- Modified: 2026-06-30T04:01:41+03:00
- Publisher: CoreITen (https://coreiten.com)
- Keywords: Strikethrough in Excel, Excel keyboard shortcuts, Format Cells dialog box, cross out text in Excel, remove strikethrough, partial strikethrough

---

Crossing out completed tasks or outdated values in a spreadsheet is a daily necessity, yet finding the strikethrough in Excel can be surprisingly frustrating. Unlike Microsoft Word, Excel hides this essential formatting tool away from the main ribbon. This forces many users to waste time searching through menus just to draw a simple line through their text.

This guide is designed for project managers, accountants, and everyday spreadsheet users who need to maintain accurate records. Applying a strikethrough allows you to visually mark data as obsolete or completed without permanently deleting the historical record, ensuring your audit trails remain intact.

### Method 1: Using Keyboard Shortcuts

1. **Select** the target cell or range of cells in your spreadsheet.
   *This ensures the formatting is applied exactly where you need it.*
2. **Press** the keyboard shortcut Ctrl + 5 on Windows, or Command + Shift + X on macOS.
   *This enables the fastest possible formatting, especially when processing multiple rows in quick succession.*

### Method 2: Using the Format Cells Dialog Box

1. **Highlight** the cell you want to format.
   *This isolates the specific data point for modification.*
2. **Navigate** to the Home tab and click the diagonal arrow icon in the lower-right corner of the Font section.
   *This opens the comprehensive formatting menu, which [Microsoft’s official support documentation](https://support.microsoft.com/en-us/office/apply-or-remove-strikethrough-text-formatting-3c0f7c0e-2e1e-4c3e-8a5e-1e1e1e1e1e1e) notes gives you the most control over text formatting options.*
3. **Check** the Strikethrough box located in the bottom-left corner of the Font tab, then click OK.
   *This applies the visual cross-out effect to numbers, text, currencies, or dates within the selected cell.*

### How to Apply Partial Strikethrough

1. **Double-click** the target cell to enter edit mode.
   *This allows you to interact with individual characters rather than the entire cell block.*
2. **Drag** your cursor to highlight only the specific text or numbers you want to cross out.
   *This ensures that only the outdated portion of a mixed-data cell is affected.*
3. **Apply** the Ctrl + 5 (Windows) or Command + Shift + X (Mac) shortcut.
   *This executes the partial strikethrough, leaving the rest of the cell's contents perfectly readable.*

### How to Remove Strikethrough Formatting

1. **Select** the cell containing the crossed-out text.
   *This targets the formatting you wish to revert.*
2. **Press** the same keyboard shortcut (Ctrl + 5 or Command + Shift + X) again.
   *This acts as a toggle switch, instantly removing the strikethrough and restoring the original text appearance.*

### The Hidden Value of Non-Destructive Formatting

While it might seem like a simple aesthetic choice, using strikethrough formatting is a fundamental practice for data integrity. Deleting outdated values entirely destroys the historical context of a spreadsheet, making it impossible to track changes or audit past decisions. By crossing out data instead, teams can maintain a transparent record of what was planned versus what was actually executed.

Furthermore, the ability to apply partial strikethrough elevates Excel from a rigid data grid to a dynamic tracking tool. When dealing with complex cells that contain mixed information - such as a project status update or a combined financial figure - isolating the exact outdated variable prevents the need to create entirely new columns just for corrections. This keeps your spreadsheets clean, accurate, and easy to read.

## Sources

- [addictivetips.com](https://www.addictivetips.com/microsoft-office/how-to-strikethrough-in-excel-everything-you-need-to-know/)