Ever wished you could simply cross out a word or number in Excel to show something is done, outdated, or out of scope? Striking through text is a tiny visual cue that can make your spreadsheets feel more interactive and easier to read, turning plain cells into a living list of progress. It’s perfect for tracking completed tasks, marking items that no longer apply, or just adding a playful touch to a personal budget.
Imagine you’re managing a project checklist: each line represents a task, and once you finish it you strike it through, instantly revealing what remains without scrolling through a long list. Or picture a supplier invoice where you strike out items that were cancelled, giving a quick, visual audit trail for your accounting team.
Another fun idea is using strikethrough in a recipe spreadsheet. As you gather ingredients, you cross out the ones you’ve already bought, turning the sheet into a handy shopping tool that updates itself as you shop. For a playful twist, try it on a reading list: after you finish a book, strike its title to celebrate your accomplishment.
Must Read
Getting started is simple. Select the cell, open Format Cells, go to the Font tab, and check the Strikethrough box. Need it faster? Just press Ctrl + 5 on Windows or ⌘ + Shift + X on a Mac, and the line will appear instantly. If you love shortcuts, you can even create a custom ribbon button through VBA to apply the effect with a single click.
How to Strike Through Text in Excel - Xelplus - Leila Gharani
For more dynamic spreadsheets, combine strikethrough with conditional formatting. Write a rule that automatically strikes out a row when its status column says “Completed” or “Cancelled,” so the sheet updates itself as data changes. This hands‑off approach saves time and keeps your presentation looking neat.
Finally, keep readability in mind: use strikethrough sparingly, pair it with a different font color or an icon, and always test the visual on a printed copy. With these simple tricks, you’ll turn ordinary Excel cells into informative snapshots that convey progress at a glance. Happy striking!
