Crossing out text in Excel helps you correct mistakes, mark completed items, or highlight changes without deleting important data. This guide walks through several reliable ways to add a strike through effect so your notes remain clear and easy to read.
Unlike word processors, Excel does not include a one click Strikethrough button on the Home tab, but you can still achieve the same visual result through the Font dialog, keyboard shortcuts, and custom settings. The following sections outline practical methods suitable for different workflows.
| Method | Steps | Quick Access | Best For |
|---|---|---|---|
| Keyboard Shortcut | Select cell(s), press Ctrl+5 | Very Fast | Daily repetitive tasks |
| Font Dialog | Select text, open dialog, check Strikethrough | One click after adding to Quick Access | Custom formatting control |
| Quick Access Toolbar | Add Strikethrough button, then click | Always visible | Frequent users |
| Conditional Formatting Rule | Create rule to apply strike through based on condition | Automated | Dynamic reports |
Applying Strikethrough Using Keyboard Shortcuts
Keyboard shortcuts provide the fastest way to add or remove a line through your text. Once you select the cell or range, a single combination toggles the style on and off.
Press Ctrl+5 on Windows or Command+Shift+X on Mac to instantly apply a strike through line. This shortcut works regardless of whether the button exists on your ribbon, as long as the feature is enabled in Excel.
Using the Font Dialog for Detailed Control
When you need precise formatting, the Font dialog lets you adjust multiple text attributes at once. This is useful if you also want to change color, style, or underlining along with the strike through line.
Open the dialog with Ctrl+1, click the Font tab, check the Strikethrough option, then press Enter. The change applies immediately to the selected cells and can be reused by opening the same dialog later.
Adding Strikethrough to the Quick Access Toolbar
Placing the command on the Quick Access Toolbar turns a hidden feature into a one click tool. You can customize the toolbar to keep your most used actions visible above the ribbon.
Click the arrow next to the Quick Access Toolbar, choose More Commands, select Commands Not in the Ribbon, pick Strikethrough, add it, and then confirm with OK. After this setup, you can apply the line with a single mouse tap.
Conditional Formatting for Automated Strikethrough
Conditional formatting can automatically add a strike through when a cell meets specific criteria, such as a completed task or an expired date. This approach keeps your sheet visually aligned with current data.
Open the Conditional Formatting menu, choose New Rule based on a formula, enter a condition like =D2=TRUE, set the format to Strikethrough, and apply the rule. The line appears only when the condition evaluates to true, reducing manual updates.
Best Practices and Recommendations
- Use strike through consistently to represent completed tasks or obsolete data.
- Combine with cell colors or icons for faster visual scanning in large tables.
- Add the command to the Quick Access Toolbar to save time on repetitive formatting.
- Document your conventions in a help sheet so team members understand the meaning of crossed out text.
- Test conditional rules to ensure they trigger correctly and do not overwrite manual changes.
FAQ
Reader questions
Does using strikethrough in Excel affect the cell value or calculations?
No, applying a strike through only changes the visual appearance of the text. The underlying value, date, or formula remains unchanged, so calculations and data references continue to work normally.
Can I remove strikethrough from multiple cells at once?
Yes, select the range, press Ctrl+5 again to toggle it off, or click the Strikethrough button on the Quick Access Toolbar to remove the line from all selected cells in one action.
Will strikethrough print when I print my worksheet?
By default, the strike through formatting is included in the printed output, so reviewers can see which items are marked as completed or crossed out on paper.
Can I apply strikethrough using VBA or macros?
Yes, you can use a short VBA line like Selection.Font.Strikethrough = True to automate the process across worksheets, especially when combined with event driven triggers or button controls.