How To Strike Out On Excel: Master Text Formatting And Strikethrough Techniques
Striking out text in Microsoft Excel is an essential formatting technique used to visually cross out obsolete data, completed tasks, or revised numbers without deleting them. This comprehensive guide details keyboard shortcuts, ribbon navigation, conditional formatting rules, and macro automation to apply strikethroughs efficiently across all versions of Excel.
Prerequisites and Formatting Setup
Executing a strikethrough in Microsoft Excel requires understanding how cell formatting operates independently of underlying data values. Before applying visual strikeouts, users must ensure their environment is properly configured to handle text modifications.
- Essential Software: Microsoft Excel (Office 365, Excel 2021, Excel 2019, Excel 2016, or Excel for Mac).
- Prerequisites: Basic familiarity with cell selection, ribbon navigation, and keyboard shortcut combinations. No special add-ins or external software are required.
- Time Investment: Less than one minute for basic manual formatting; 5 to 10 minutes for automated conditional rules.
Step-by-Step Execution of Excel Strikethrough Methods
Step 1: Using the Universal Keyboard Shortcut
The fastest way to apply a strikethrough to any selected cell or text string is through the native keyboard shortcut. Select the target cell or range of cells containing the text you want to alter. For granular control over specific words within a single cell, double-click the cell and highlight only the desired characters using your cursor. Press Ctrl plus 5 on Windows, or Command plus Shift plus X on Mac. The selected text will immediately display a horizontal line running through the center of the characters.
Pro-Tip: If your numeric keypad is active and the shortcut fails, ensure you are using the primary number row above the alphabet keys rather than the numeric pad.
Step 2: Navigating the Format Cells Dialog Box
For users who prefer menu-driven navigation or need to apply strikethrough alongside other formatting attributes like fonts, borders, and fills, the Format Cells dialog box provides a centralized control panel. Highlight your target cells, right-click the selection, and choose Format Cells from the context menu, or use the shortcut Ctrl plus 1 on Windows or Command plus 1 on Mac. Navigate to the Font tab within the dialog box. Locate the Effects section in the lower right area of the tab and check the box labeled Strikethrough. Click the OK button to apply the change to your worksheet.
Step 3: Utilizing the Home Ribbon Interface
The Excel ribbon provides direct visual access to common formatting commands, making it useful for touchscreens or visual learners. Select the cells you wish to modify. Navigate to the Home tab on the top application ribbon. Locate the Font group, which houses styling tools like bold, italic, and underline. Click the small diagonal arrow icon located in the bottom-right corner of the Font group to open the Format Cells dialog window directly. From there, check the Strikethrough option and confirm by clicking OK.
Step 4: Applying Automatic Strikethroughs via Conditional Formatting
When managing dynamic project trackers or task lists, manual strikethroughs can become outdated quickly. You can configure Excel to apply a strikethrough automatically when a specific condition is met, such as changing a status column to complete. Select your data range. Go to the Home tab, click Conditional Formatting, and select New Rule. Choose the option to use a formula to determine which cells to format. Enter a formula pointing to your status cell, such as equal sign dollar sign B2 equals quotation mark Complete quotation mark. Click the Format button, select the Font tab, check Strikethrough, and click OK twice to activate the dynamic rule.
Grey Out Cells In Excel Conditional Formatting
Comparison of Excel Strikethrough Methods
| Method | Execution Speed | Scope | Best Use Case |
|---|---|---|---|
| Keyboard Shortcut (Ctrl + 5) | Immediate (Under 2 seconds) | Entire cell or highlighted text string | Quick manual edits and daily task list management. |
| Format Cells Menu (Ctrl + 1) | Fast (3 to 5 seconds) | Entire cell | Combined styling changes including borders, fonts, and fills. |
| Ribbon Launch Dialog | Moderate (5+ seconds) | Entire cell | Users unfamiliar with keyboard shortcuts. |
| Conditional Formatting | Automated | Dynamic ranges based on criteria | Project management dashboards and automated status trackers. |
Common Failure Points and Troubleshooting Fixes
- Root Cause: Attempting to apply a strikethrough to a cell that is currently in edit mode while formulas or data are locked.
- Actionable Fix: Press the Escape key to exit formula editing mode, re-select the cell normally with a single click, and re-apply the strikethrough shortcut.
- Root Cause: Using the wrong key combination on non-Windows operating systems, causing Excel to ignore the command or trigger an unrelated function.
- Actionable Fix: Verify your operating system architecture. Mac users must use Command plus Shift plus X, as the Windows Ctrl plus 5 shortcut does not map natively.
- Root Cause: Conditional formatting strikethrough rules overriding manual formatting or failing to update when source data changes.
- Actionable Fix: Open the Conditional Formatting Rules Manager via the Home tab, review your absolute and relative cell references in the formula, and ensure rule precedence is ordered correctly.
Frequently Asked Questions
Can I remove a strikethrough without clearing my cell data?
Yes. Simply select the cell or highlighted text containing the strikethrough and repeat the exact method you used to apply it. Pressing Ctrl plus 5, unchecking the box in the Format Cells menu, or removing the conditional formatting rule will toggle the strikethrough off while preserving your underlying text and values.
Why is the strikethrough option grayed out in my Excel file?
The strikethrough option becomes inaccessible if the workbook is protected, if you are actively editing the contents of a formula inside the formula bar, or if the selected range includes items like charts or shapes that do not support standard text font effects. Exit edit mode or unprotect the sheet to restore formatting access.
Does striking out text affect formulas or calculations in Excel?
No. A strikethrough is strictly a visual font attribute, much like bold or italic formatting. It does not alter the underlying text string, number, or boolean value, meaning functions like SUM, COUNTIF, and VLOOKUP will continue to read and calculate the cell contents normally.
How do I apply a strikethrough using a custom macro or VBA?
You can automate strikethroughs by recording a macro or writing a short VBA script targeting the font property. Access the Visual Basic for Applications editor using Alt plus F11, insert a standard module, and write a command targeting your range font strikethrough property set to True. This approach is ideal for large enterprise reports requiring batch styling modifications.
Mastering text formatting features like the strikethrough elevates your spreadsheet presentation and makes dynamic tracking documents immediately intuitive for teams. Explore our advanced Excel guides to further streamline your data management workflows today.
