Removing unwanted text in Excel can be as simple as striking through cells while preserving the data structure. This guide walks through practical techniques for crossing out words, phrases, or entire entries so your spreadsheets stay readable and well organized.
These methods work across modern desktop and web versions of Excel, helping you visually mark items without deleting content or breaking formulas.
| Technique | When to Use | Steps at a Glance | Impact on Data |
|---|---|---|---|
| Font Formatting | Quick visual mark inside a cell | Select cell, press Ctrl+1, choose Strikethrough | Does not alter value, only display |
| Wrap Text + Line Tool | Cross out across multiple columns | Merge or align text, draw a line over the range | Visual only; underlying text unchanged |
| Drawing Shapes | Annotation over a block of cells | Insert shape, line or freeform, position on text | Purely visual; no cell modification |
| Conditional Formatting + Custom Number | Automatically strike based on rules | Create rule, apply custom format ";;@ strike" | Dynamic display while keeping real value |
How to Cross Out Words in Excel Using Font Strikethrough
The quickest way to cross out a word inside a cell is to use the built-in Strikethrough format. This method works for any edition of Excel and requires just a few clicks or a keyboard shortcut.
Begin by selecting the cell or range you want to mark, then open the Format Cells dialog, often with Ctrl+1, and tick Strikethrough under Effects. The text appears with a line through it immediately, while the actual cell value remains intact for calculations or exports.
Use this approach when you want a consistent, lightweight method to flag completed tasks, canceled items, or deprecated labels without changing the underlying data structure.
Crossing Out Multiple Words Across Adjacent Cells
When you need to visually cross out a phrase spread over several neighboring cells, merging text is unnecessary. Instead, draw a line or use a shape to overlay the block while keeping each cell editable.
Merge the content visually by aligning text left, center, and right, then insert a line shape from the Insert tab and drag it over the range. Alternatively, group cells by selecting them and applying a border or shape that spans the entire selection for a clean strike effect.
This technique is helpful for marking headers, time periods, or categories without disrupting the grid layout or complicating sorting and filtering operations.
Using Shapes and Comments for Flexible Strikethrough
Shapes give you full control over where and how the line appears, making them ideal for presentations, reports, or dashboards where clarity matters. Insert a line, customize its color and weight, and position it precisely over the text you want to cross out.
For collaborative files, combine shapes with comments to explain why an item was struck through. Readers can hover over the comment to see context while still viewing the original text crossed out, which supports traceability and reduces follow-up questions.
Remember to group shapes with nearby cells or freeze panes so line positions stay aligned when you scroll or resize the view.
Automating Strikethrough with Custom Number Formats
Conditional number formats can automatically apply strikethrough based on cell values, dates, or other criteria, saving time on large lists. This method changes how numbers or text look without altering the actual content, and it updates dynamically as data changes.
Create a new rule using a formula or a built-in condition, then assign a custom format that includes an "at" mark and an escaped "@" symbol with a strike instruction. For instance, a format string like [>=100]"0";"[red]"0";@@ strike" can visually mark target values while preserving the original numbers for reporting.
Use this approach for inventory lists, task boards, or project trackers where status changes should automatically trigger a visual update across many rows.
Best Practices for Managing Strikethrough in Excel
- Use Ctrl+1 for fast access to the Format Cells dialog and consistent formatting.
- Reserve strikethrough for status signals like completed, canceled, or deprecated items.
- Combine shapes and comments when context is needed for crossed-out entries.
- Leverage conditional number formats to automate visual updates across large datasets.
- Avoid merging cells just to draw a line; lines and shapes work independently of the grid.
FAQ
Reader questions
How do I cross out text in a single cell without losing the value?
Select the cell, press Ctrl+1 to open Format Cells, go to the Font tab, and check Strikethrough. The text will show a line while the underlying value stays unchanged.
Can I apply strikethrough to an entire row or column automatically?
Yes, select the row or column, open Conditional Formatting with a formula like =A1<>"", and add a custom number format that includes strikethrough. Cells meeting the condition will display crossed-out text dynamically.
Will drawing a line over text delete the underlying words?
No, inserting a line or shape is a visual layer only. The original text remains fully intact in the cells, and formulas referencing those cells continue to work as expected.
How can I remove strikethrough formatting later if needed?
Select the cell(s), open Format Cells, uncheck Strikethrough under Effects, and confirm. For conditional formats, adjust or delete the rule so the strikethrough no longer applies automatically.