How To Cross Out On Excel: Complete Guide To Strikethrough Formatting
Applying a strikethrough in Microsoft Excel is a foundational text-formatting operation used to visually cross out obsolete data, track completed inventory items, or indicate editorial revisions without deleting underlying values. Mastering keyboard shortcuts, conditional formatting rules, and cell properties ensures rapid data management across desktop and web spreadsheet environments.
Pre-Operation Setup and Spreadsheet Planning
Before modifying spreadsheet data with strikethrough formatting, understanding how Excel handles typography layers and data retention is essential for maintaining robust documentation workflows. Strikethrough is strictly a visual text attribute applied via font properties; it does not alter cell values, mathematical calculations, or underlying data integrity.
- Essential tools and software requirements: Microsoft Excel for Windows or Mac, Excel for the Web, or a compatible spreadsheet application like Microsoft 365.
- Mandatory prerequisite knowledge: Basic navigation of Excel ribbon menus, understanding of keyboard shortcut modifiers, and familiarity with cell selection states.
- Estimated completion benchmarks: Less than 5 seconds per manual application, or under 1 minute for automated conditional formatting rules across thousands of rows.
Step-by-Step Execution of Excel Strikethrough Techniques
Step 1: Selecting the Target Cells
To cross out text in Excel, you must first define the scope of your operation by selecting the individual cells, entire rows, or continuous ranges containing the data you wish to modify. Click and drag your cursor across the target cells, or use keyboard navigation methods such as holding the Shift key while using arrow keys to expand your selection. For entire rows, click the row number on the far-left margin, or use the Shift plus Spacebar shortcut while your cursor rests inside the target row.
Pro-Tip: If you need to cross out specific words within a single cell rather than the entire contents, double-click the cell or press F2 to enter editing mode, highlight only the target characters with your cursor, and then apply your strikethrough method.
Step 2: Applying Strikethrough via Keyboard Shortcuts
The fastest method to cross out selected data in desktop versions of Microsoft Excel is utilizing the native keyboard shortcut combination. Ensure your cells are selected, then press Control and the number 5 on Windows, or Command, Shift, and X on macOS, to instantly toggle the strikethrough font property on and off.
Warning: Avoid pressing the numeric keypad 5 unless NumLock is explicitly disabled, as this may trigger alternative directional navigation rather than executing the format command.
Step 3: Utilizing the Format Cells Dialog Box
For users who prefer graphical interfaces or need to combine strikethrough with other typographic adjustments like underlines, bold styling, or color modifications, the Format Cells dialog box offers comprehensive control. Right-click your selected cells and choose Format Cells from the context menu, or press Control plus 1 on Windows or Command plus 1 on Mac to open the settings window. Navigate to the Font tab, locate the Effects section, click the checkbox next to Strikethrough, and click OK to commit the change.
Step 4: Automating Strikethrough with Conditional Formatting
When managing dynamic checklists or task trackers where rows must automatically cross out once a specific status changes, conditional formatting provides automated execution. Select your data range, navigate to the Home tab on the ribbon, click Conditional Formatting, and select New Rule. Choose the option to use a formula to determine which cells to format, input your logical evaluation formula referencing your status column, click the Format button, check the Strikethrough box under the Font tab, and click OK.
How To Do A Cross Join In Power Query
Comparison of Excel Strikethrough Application Methods
| Method Name | Operating System | Execution Speed | Best Use Case | Automation Potential |
|---|---|---|---|---|
| Keyboard Shortcut | Windows / Mac | Immediate (<1s) | Quick manual edits and ad-hoc task ticking | None |
| Ribbon Menu / Dialog Box | Windows / Mac | Fast (2-3s) | Combining strikethrough with borders, fills, or fonts | None |
| Conditional Formatting | Windows / Mac | Moderate setup | Automated checklist management and dynamic tracking | High (Fully automated) |
| Quick Access Toolbar | Windows / Mac | Fast (1-2s) | Users who prefer mouse clicks over key combinations | None |
Common Implementation Failures and Field Fixes
Problem: The keyboard shortcut Control plus 5 opens a different menu or fails to apply the strikethrough formatting.
- Root Cause: Interference from third-party macro applications, active cell edit mode, or utilizing the numeric keypad 5 while NumLock is engaged.
- Actionable Fix: Press Enter or Escape to exit active cell editing mode before attempting the shortcut, and ensure you are using the primary number row above the keyboard rather than the ten-key pad.
Problem: Strikethrough formatting disappears when sorting or filtering the spreadsheet data.
- Root Cause: Formatting was applied to static cells without tying the visual style to a dynamic data condition or updating the table structure correctly.
- Actionable Fix: Convert your range into an official Excel Table by pressing Control plus T, or use Conditional Formatting linked to cell values so the strikethrough travels with the data during sorting operations.
Problem: Strikethrough text cannot be removed or toggled off using the standard shortcut.
- Root Cause: The cell range contains mixed formatting states where some cells have strikethrough applied and others do not.
- Actionable Fix: Open the Format Cells dialog box (Control plus 1) where mixed states show a solid black square instead of a checkmark, click the box twice to completely clear the property across all selected cells, and click OK.
Frequently Asked Questions
What is the exact keyboard shortcut to cross out text in Excel on Windows?
Pressing Control plus 5 on your Windows keyboard instantly toggles the strikethrough effect on any highlighted text or selected cells. If you are editing inside a cell's formula bar, make sure to highlight the specific text characters first before applying the shortcut.
Can I cross out an entire row automatically based on a dropdown selection?
Yes, you can achieve this by setting up a custom conditional formatting rule that evaluates the value of a specific status cell. When the cell equals a term like Completed, the conditional formatting engine applies the strikethrough font property across the entire designated row range.
Does applying a strikethrough alter numerical values or calculations?
No, strikethrough is purely a visual text-formatting attribute similar to bold or italic styling. It has zero impact on numerical calculations, formulas, sums, or data integrity within your spreadsheet environment.
How do I remove a strikethrough from multiple cells at once?
Highlight the affected cells, and either press the original shortcut keys of Control plus 5 on Windows or Command, Shift, and X on Mac to strip the formatting. Alternatively, open the Format Cells dialog box and uncheck the Strikethrough option.
Can I apply a strikethrough in Excel for the Web?
Yes, Excel for the Web supports strikethrough formatting. You can access it by highlighting your text, opening the Home tab on the top ribbon, clicking the Font settings dialog launcher arrow, and checking the Strikethrough box.
Elevate your spreadsheet design capabilities and streamline your data management workflows by practicing these formatting techniques in your next workbook project.
