How To Cross Out In Excel: Complete Guide To Strikethrough Formatting
Applying a strikethrough in Microsoft Excel visually indicates completed tasks, deprecated data, or reviewed items without deleting the underlying cell content. Mastering this formatting technique across desktop, web, and mobile platforms enhances data tracking efficiency and ensures clear visual communication in complex spreadsheets.
Initial Setup Requirements for Spreadsheet Formatting
Before executing formatting changes, ensuring your Microsoft Excel environment is properly configured prevents unexpected behavioral anomalies during data review. Strikethrough is a dynamic font property rather than a structural data type change, meaning the original numerical or text value remains completely intact and accessible for formulas.
- Essential tools and software: Microsoft Excel for Windows or macOS (Office 365, Excel 2021, Excel 2019), Excel for the Web, or the Excel Mobile application.
- Mandatory prerequisite knowledge: Understanding of cell selection states, range indexing, and the difference between formula bar editing and direct cell formatting.
- Time and efficiency benchmarks: Executing a single strikethrough via keyboard shortcuts takes approximately 1.5 seconds, whereas configuring conditional formatting rules for automated strikethroughs requires roughly 3 to 5 minutes of setup time.
Step-by-Step Strikethrough Execution Workflow
Step 1: Selecting the Target Cells or Ranges
- Locate the specific cells, rows, or columns you wish to modify within your active worksheet.
- Click and drag your cursor across the range, or use keyboard navigation keys while holding the Shift key to highlight multiple contiguous cells.
- If you need to apply the format to non-contiguous cells, hold down the Control key on Windows or the Command key on macOS while clicking each individual target cell.
Pro-Tip: To instantly select an entire contiguous data table, click any single cell within the dataset and press Control plus Shift plus Asterisk on Windows, or Command plus Shift plus Asterisk on Mac.
Step 2: Applying Strikethrough via Keyboard Shortcuts
- Once your desired cells are actively highlighted, ensure you are not currently inside the formula editing cursor mode.
- Press Control plus 5 on Windows or Command plus Shift plus X on macOS to instantly toggle the strikethrough font property on the selected text.
- Verify that the horizontal line renders across all characters within the chosen cells.
Warning: Pressing Control plus 5 on a Windows laptop with specialized function layers might require pressing the Fn key simultaneously if the top row defaults to hardware volume or brightness controls.
Step 3: Utilizing the Format Cells Dialog Box
- Right-click anywhere within your active cell selection and choose Format Cells from the context menu to open the comprehensive property window.
- Navigate directly to the Font tab within the dialog box, where you can manage font family, size, color, and special effects.
- Locate the Effects section at the lower right quadrant of the Font tab and check the box labeled Strikethrough.
- Click the OK button at the bottom right of the dialog window to commit the formatting changes to your worksheet.
Step 4: Automating Strikethrough with Conditional Formatting
- Highlight your interactive task list range, such as cells A2 through A50, where status values will change dynamically.
- Navigate to the Home tab on the Excel ribbon, click Conditional Formatting, and select New Rule to open the rule creation wizard.
- Choose the option to use a formula to determine which cells to format, and enter your evaluation logic, such as an exact match to a completed status text.
- Click the Format button, select the Font tab, check the Strikethrough box, and click OK to finalize the automated rule.
38,305 Crossed Out Document Stock Vectors and Vector Art | Shutterstock
Excel Strikethrough Methods Comparison
| Method Name | Operating System Support | Speed & Efficiency | Best Use Case |
|---|---|---|---|
| Keyboard Shortcut | Windows & macOS | Instant (Under 2 seconds) | Manual ad-hoc updates to task lists and checklists |
| Format Cells Dialog | Windows & macOS | Moderate (4 to 6 seconds) | Modifying strikethrough alongside font size and color changes |
| Ribbon Menu Access | Windows & macOS | Moderate (3 to 5 seconds) | Visual discovery for novice users unfamiliar with hotkeys |
| Conditional Formatting | Windows & macOS | Advanced Setup (Automated) | Dynamic tracking where changing status text strikes out rows automatically |
Common Site Failures and Field Fixes
- Root Cause: The strikethrough shortcut opens an unrelated menu or fails to trigger entirely due to conflicting third-party application hotkeys or laptop hardware function locks.
- Actionable Fix: Use the right-click Format Cells method as a reliable alternative, or inspect your operating system keyboard manager to disable conflicting background macro software.
- Root Cause: Strikethrough formatting disappears or fails to apply when attempting to edit text directly inside the formula bar or during active in-cell editing mode.
- Actionable Fix: Press the Enter or Escape key to exit active edit mode, select the cell normally, and then re-apply the strikethrough formatting command.
- Root Cause: Conditional formatting strikethrough rules fail to evaluate because cell references lack absolute locking symbols, causing formatting to shift incorrectly down the column.
- Actionable Fix: Open the Conditional Formatting Manager, edit your formula rule, and ensure column and row anchors (dollar signs) are correctly placed around the status cell reference.
Frequently Asked Questions
Can I apply a strikethrough to only a specific part of the text inside a single Excel cell?
Yes, you can format individual characters within a single cell by double-clicking the cell to enter edit mode or clicking directly inside the formula bar. Highlight only the specific words or characters you want to alter, right-click to open Format Cells, and check the Strikethrough box without affecting the rest of the text.
Why is the strikethrough option greyed out in my Excel ribbon or menu?
The strikethrough option becomes greyed out when Excel is currently in edit mode, meaning your cursor is actively blinking inside a cell or the formula bar. Press the Enter key on your keyboard to save or cancel the current edit, which restores full access to all cell formatting tools.
Does applying a strikethrough affect the numerical values or text strings used in formulas?
No, strikethrough is strictly a visual font attribute and does not alter the underlying data value, string length, or data type stored within the cell. Formulas referencing strikethrough cells will continue to calculate, sum, and evaluate the data normally.
How do I remove a strikethrough from a large range of cells?
Highlight the cells containing the strikethrough formatting, and simply re-apply the toggle command by pressing Control plus 5 on Windows or Command plus Shift plus X on macOS. Alternatively, open the Format Cells dialog box and uncheck the Strikethrough box under the Font tab.
Can I record a macro to apply strikethrough formatting automatically?
Yes, you can use the built-in Excel Macro Recorder while applying the Format Cells strikethrough routine to generate VBA code for automated workflow buttons. This allows you to assign the strikethrough action to a custom Quick Access Toolbar button for rapid spreadsheet management.
Master Your Excel Workflows Today
Enhancing your data presentation and task management capabilities in Excel streamlines your daily reporting and elevates professional output quality. Implement these advanced formatting techniques today to transform your static spreadsheets into dynamic, highly readable operational dashboards.
