Removing text by crossing it out in Excel helps you mark obsolete data while preserving the original entries for audit or reference. This approach is common in finance, inventory tracking, and compliance workflows where you need a visible strikeout without deleting content.
Below you will find a quick reference table, detailed workflow guides, practical tips, and answers to common questions to start crossing words out like a pro.
| Action | Keyboard Shortcut | Menu Path | Result |
|---|---|---|---|
| Select cell or range | Click or use arrow keys | Navigate with mouse or keyboard | Cell becomes active with border |
| Apply strikethrough | Ctrl+5 (Windows) or Cmd+Shift+X (Mac) | Home > Font > Strikethrough | Text shows a horizontal line through selected characters |
| Partial strikeout | Double-click cell, select substring, Ctrl+5 | Edit in cell, highlight portion, Home > Font > Strikethrough | Only chosen words crossed out, rest remains readable |
| Bulk formatting | Use Format Painter or a style with strikethrough | Home > Styles or Format Painter | Apply consistent crossing to multiple cells quickly |
Using Strikethrough Shortcut in Excel
The fastest way to cross words out in Excel is the Strikethrough shortcut, which instantly overlays a line on your text. This keeps your original data intact while clearly signaling that the content is no longer current.
To use it, select the cell or portion of text you want to mark, then press Ctrl+5 on Windows or Cmd+Shift+X on Mac. Excel applies a professional horizontal line through the characters without altering column width or other formatting.
For quick access, you can also add Strikethrough to your Quick Access Toolbar so the icon is a single click away, streamlining repetitive marking tasks during data review sessions.
Applying Strikethrough via the Home Tab
The Home tab gives you full control over font style, including the ability to cross words out with consistent visual weight. This method is helpful when you want to review multiple formats at once, such as bold, italic, and strikeout.
Select your cell or range, navigate to Home > Font, and click the Strikethrough icon. You can combine this with other formatting choices to create a clean, standardized mark for deprecated entries.
Use the Format Painter to copy the strikeout style across rows or sheets, which saves time and ensures every marked item follows the same visual convention across your workbook.
Crossing Out Text Partially Inside a Cell
When only part of a cell needs to be crossed out, partial strikethrough is the ideal solution. Double-click the cell to enter edit mode, highlight the specific words or characters, and apply Strikethrough using the shortcut or the Home menu.
This approach preserves context, such as crossing out an old product code while leaving the description visible. It is especially useful in annotations where you need clarity without removing the underlying note.
Consistent use of partial strikeout across your sheet makes it easier for teammates to scan and understand which elements are still active and which are deprecated.
Customizing the Strikethrough Appearance
Excel uses a single solid line by default, but you can adjust weight, color, and position through the Format Cells dialog. Open the format menu by pressing Ctrl+1 after selecting the cell, then switch to the Font tab for detailed tweaks.
Although the options are more limited than in a drawing tool, you can simulate double lines or colored strikeout effects by overlaying shapes and aligning them with cell text. This is helpful for high-visibility markers in shared review documents.
Keep branding and readability in mind when customizing, ensuring that crossed-out text remains legible and does not distract from the surrounding data.
Best Practices for Crossing Words Out in Excel
- Use Strikethrough to mark obsolete data while preserving it for compliance and reference.
- Apply consistent formatting across teams to ensure clarity and avoid confusion.
- Leverage keyboard shortcuts and Quick Access Toolbar for faster daily workflows.
- Use partial strikethrough when only specific words within a cell need deprecation.
- Combine with comments or version history if you need an audit trail beyond visual marking.
FAQ
Reader questions
How do I cross words out in Excel but keep the original text visible for audits?
Use the Strikethrough format, which overlays a line without deleting the content. This preserves the original text so auditors can verify what was changed and when.
Can I apply strikethrough to multiple cells at once in Excel?
Yes, select the range, then apply Strikethrough from the Home tab or with the keyboard shortcut to mark several cells consistently in one action.
How can I cross out only part of text inside a cell without affecting the rest?
Double-click the cell, highlight the specific segment, and apply Strikethrough. This partial crossing keeps the surrounding text readable and retains important context.
Will using strikethrough change how my formulas or data calculations behave in Excel?
No, strikethrough is a visual formatting option that does not affect cell values, references, or calculations in any way.