How to Apply Strikethrough in Excel: The Complete Formatting Guide

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.

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.

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 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.

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.

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.

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.