How To Add A Strikethrough In Excel: The Complete Technical Guide

Applying a strikethrough in Microsoft Excel involves accessing the Format Cells menu, the Quick Access Toolbar, or utilizing keyboard shortcuts to apply character-level formatting without altering the underlying data value. This visual indicator is essential for project management, task tracking, and data auditing within spreadsheets, and it can be applied to individual characters or entire cell ranges.

Prerequisites for Excel Data Formatting

Before implementing strikethrough formatting, ensure your environment is configured for standard data manipulation. Excel strikethrough is a stylistic layer that sits above the raw data string; it does not change the cell value, meaning formulas that reference the cell will still calculate the original text as if it were clean.

• Essential Equipment: Microsoft Excel (Office 365, 2021, 2019, or web-based version).
• Mandatory Knowledge: Users should be familiar with selecting ranges, managing the Ribbon interface, and understanding basic cell property navigation.
• Estimated Duration: The process requires approximately 5 to 10 seconds per execution when using keyboard shortcuts, or 30 seconds for menu-driven navigation.
• Software Compatibility: While core features remain consistent, the web version of Excel may require a shift in navigation as it lacks the comprehensive Format Cells dialog box found in desktop versions.

Executing the Strikethrough Workflow

There are three primary methods for applying a strikethrough. Choose the method that best aligns with your current workflow intensity.

Step 1: The Keyboard Shortcut Method (Most Efficient)

The fastest way to apply a strikethrough is via the legacy keyboard shortcut, which remains the industry standard for power users.

1. Select the cell or specific range of cells you wish to modify.
2. If you only want to strike through specific words within a single cell, double-click the cell or press F2 to enter Edit mode, then highlight the specific text characters with your mouse.
3. Press the Control key plus the number 5 (Ctrl + 5) on your keyboard simultaneously.
4. The strikethrough will instantly render on the selected text. Pressing the shortcut again will toggle the effect off.

Pro-Tip: If you are using a laptop without a dedicated numeric keypad, ensure you use the number 5 located in the top row of your keyboard; the shortcut does not typically map to the numeric keypad 5 unless NumLock is properly toggled.

Step 2: The Format Cells Dialog Box

For users who require precise control over secondary formatting options, the Format Cells dialog is the authoritative interface.

1. Select the target cells, rows, or columns.
2. Right-click anywhere within the selected range and choose Format Cells from the context menu, or use the shortcut Ctrl + 1.
3. Navigate to the Font tab within the dialog window.
4. Locate the Effects section at the bottom of the tab.
5. Check the box labeled Strikethrough.
6. Click OK to commit the changes.

Warning: Using the Format Cells method for mass application can trigger significant recalculation lag if your workbook contains a high volume of complex array formulas or conditional formatting rules. Apply to the smallest necessary range to maintain spreadsheet performance.

Step 3: Customizing the Quick Access Toolbar

If you frequently strike through items, adding a dedicated button to the Quick Access Toolbar (QAT) minimizes navigation overhead.

1. Locate the small downward-pointing arrow at the far top-left of the Excel interface (the QAT).
2. Select More Commands from the dropdown menu.
3. In the Choose commands from dropdown, select All Commands.
4. Scroll down until you find Strikethrough.
5. Click Add to move it to the right-hand column, then click OK.
6. You now have a permanent icon at the top of your screen that applies the strikethrough effect with a single click.

Comparison of Formatting Methods

The following table outlines the efficiency and constraints of the different methods available for applying strikethrough in Microsoft Excel.

Troubleshooting Common Formatting Failures

Even experienced users encounter roadblocks when applying cell-level formatting. Below are the most frequent issues and their corresponding technical resolutions.

• Issue: Shortcut (Ctrl+5) Fails to Trigger.

  
  
  
  • Root Cause: Conflicting software shortcuts (such as screen recording or gaming overlays) often intercept global shortcuts.
  • Actionable Fix: Disable third-party background applications that use Ctrl+5, or use the QAT method as a reliable secondary trigger.

• Issue: Strikethrough Applied to Partial Text Disappears.

  
  
  
  • Root Cause: You may be clicking back into the cell and accidentally re-applying general formatting that resets font properties.
  • Actionable Fix: Ensure you are in Edit mode (F2) before re-selecting the specific characters, and avoid using the Format Painter after applying the strikethrough.

• Issue: Formatting Does Not Appear in Excel for Web.

  
  
  
  • Root Cause: The web version lacks the full Format Cells dialog box functionality for granular character-level strikethrough.
  • Actionable Fix: Open the workbook in the Desktop App version to apply character-specific strikethrough, then sync your changes back to the cloud.

Frequently Asked Questions

Can I use Conditional Formatting to apply a strikethrough automatically?

Yes. You can create a rule where, for example, if a cell in Column B contains the word "Done," the corresponding cell in Column A automatically receives a strikethrough. Use the Use a formula to determine which cells to format option in the Conditional Formatting menu to achieve this automation.

Does strikethrough affect mathematical calculations?

No. Strikethrough is a font-level style. It has no impact on the numerical value of the cell, so you can continue to use SUM, AVERAGE, or other functions on cells with strikethrough formatting without any data corruption.

Is there a strikethrough shortcut for Excel on macOS?

Yes, the command for Mac users is Command + Shift + X. This performs the same function as the Windows Ctrl + 5 shortcut and toggles the effect on or off.

Can I remove all strikethroughs at once in a large worksheet?

You can use the Find and Replace feature. Press Ctrl + F, click Options, then click the Format button to choose Strikethrough from the Font tab; once found, you can replace the formatting with a standard font style across the entire sheet.

Master the precision of your data presentation by incorporating these formatting techniques into your daily workflow. Download our advanced Excel shortcut cheat sheet to further optimize your productivity and reduce manual formatting time.