How To Strike Out Text In Excel | Mark Changes Cleanly

Excel has a lot of flashy tools, yet strikethrough is one of the handiest. It does one job, and it does it well: it tells the reader that something still matters, but not in the same way it did a minute ago. A task is done. A price is old. A name was swapped out. A step no longer applies.

That small visual cue keeps a sheet easier to scan. You don’t have to delete data and risk losing context. You don’t have to add extra notes in every row. You just draw a line through the text and move on.

If you want to learn how to strike out text in Excel, the process is simple. You can do it with a keyboard shortcut, a menu command, or the Format Cells box. The best method depends on where you work most: Windows, Mac, or Excel for the web.

Why Strikethrough Works So Well In Excel

Strikethrough earns its place because it leaves the text visible. That’s the whole point. Deleting a value wipes out the trail. Changing the font color can be too subtle. Adding a comment takes more clicks and can clutter the sheet.

A line through the text tells a clean story at a glance. You can see what changed, what is no longer active, and what has already been handled. In task trackers, that keeps completed items from blending in with open ones. In price lists, it lets readers compare old and current numbers without jumping between tabs. In draft planning sheets, it marks options that were dropped while still keeping a record.

It also pairs well with filters, fill color, and status columns. You don’t need to turn every worksheet into a rainbow to make progress visible. One plain formatting choice can do a lot of work.

How To Strike Out Text In Excel On Desktop And Web

The fastest path on Windows is the keyboard shortcut. Microsoft lists Excel keyboard shortcuts with Ctrl+5 for applying or removing strikethrough on Windows and Shift+Cmd+X on Mac. If you do this often, that shortcut will save you a pile of clicks over time.

Here’s the basic flow on each version:

Windows

Select the cell or range, then press Ctrl+5. Press it again to remove the line. That toggle behavior is handy when you’re cleaning up a list and need to mark items on the fly.

Mac

Select the cell or range, then press Shift+Cmd+X. Just like on Windows, the same shortcut removes the formatting if it is already there.

Excel For The Web

Select the cells, go to Home, and click the strikethrough button in the Font group. Microsoft also keeps a short page on the font strikethrough option in Excel for the web, which matches that path.

If the button is not easy to spot, widen the browser window or check whether the ribbon is collapsed. In tighter layouts, some commands can feel tucked away.

Using The Ribbon On Desktop

If shortcuts aren’t your thing, select the cells, open the Home tab, then use the Font area to turn strikethrough on. This route is slower than a shortcut, yet it is easy to remember when you’re not in Excel every day.

Using Format Cells

You can also open the Format Cells dialog, head to the Font tab, and tick Strikethrough. This method is useful when you’re already changing other font settings such as size, style, or color and want to do it all in one stop.

Whichever path you pick, the result is the same. Excel applies the line to the text in the selected cell or range. No formulas change. No values vanish. It is pure formatting.

Best Ways To Use Strikethrough In Real Sheets

Strikethrough is simple, but the way you use it can make a worksheet feel clean or messy. The neatest approach is to give it a clear meaning and stick with it. If a crossed-out item means “done,” don’t also use it to mean “wrong,” “late,” and “needs review.” That muddies the sheet fast.

Most people get the best results when they use it for one of four jobs: completed tasks, replaced entries, retired options, or old values that still need to stay visible.

It also helps to combine it with plain labels. A checkbox column, a short status word, or a muted fill color can back up the meaning without turning the page into clutter.

The table above shows the pattern. Strikethrough works best when it marks a state change, not random decoration. If you keep that rule, your sheet stays readable even when it grows.

How To Apply Strikethrough To Part Of A Cell

Sometimes you don’t want to cross out the whole cell. You only want to strike one word, one old size, or one part number inside a longer note. Excel can do that too.

Click the cell, then enter edit mode by double-clicking it or pressing the edit key for your setup. Highlight just the text you want crossed out, then apply strikethrough. That gives you finer control, which is handy in notes columns and revision logs.

There is one catch: partial formatting takes more care. If someone later rewrites the cell, that selective styling may get lost. It is best for text-heavy notes, not for fields that change all day long.

When Partial Strikethrough Makes Sense

Use it when one piece of text is outdated but the rest of the note still matters. A common case is a product note that shows an old size, a changed SKU, or a dropped phrase inside a draft line. It can also help in teaching sheets where you want to show the wrong term and the corrected one side by side.

If the whole value is outdated, though, crossing out the entire cell is cleaner.

Common Problems And Easy Fixes

Strikethrough is easy to turn on, yet a few snags show up again and again. Most of them come down to selection, view, or workbook setup.

Shortcut Does Nothing

Check whether you are editing inside the cell rather than selecting the cell itself. Some shortcuts behave differently in edit mode. Exit the cell, select it, then try again.

On laptops, function layers and custom keyboard settings can also get in the way. On Mac, another app shortcut can clash with Excel. If that happens, use the ribbon or Format Cells box instead.

Only Part Of The Text Changed

You likely highlighted text inside the cell instead of selecting the whole cell. That can be useful, though if you meant to cross out the entire entry, click once on the cell and apply the format again.

Strikethrough Won’t Show In Excel For The Web

Make sure the ribbon is open and you are in editing mode, not just viewing the file. If the screen is narrow, the command may be harder to spot until the toolbar has more room.

Copied Cells Lose The Look

If you paste values only, formatting does not come along. Use normal paste or paste formats when you want the crossed-out style to stay with the data.

When To Use Strikethrough Instead Of Deleting Data

This is where strikethrough shines. If the old entry still has context value, don’t delete it yet. Crossing it out leaves a breadcrumb trail that helps you or the next person reading the workbook.

That matters in planning sheets, work logs, quote drafts, and revision-heavy tabs. You can still see what was there, but the line makes clear that it is no longer live. That is a lot cleaner than keeping a pile of hidden columns or tacking notes onto every row.

Still, crossed-out text should not become a dumping ground. If a worksheet is full of outdated entries, archive the old material into another tab and keep the active sheet lean. Strikethrough is best for recent or useful history, not years of buildup.

How To Keep The Sheet Clean After You Start Using It

Once you start using strikethrough, a little discipline goes a long way. Pick one rule for your workbook and stick to it. You might decide that crossed-out rows are finished tasks. Great. Keep that meaning consistent in every tab that shares the same purpose.

It also helps to review old crossed-out entries once in a while. If they no longer help the reader, move them to an archive sheet or remove them. That keeps the active tab light and easy to scan.

Another smart move is to pair strikethrough with sort or filter settings. That way, you can hide finished items when you need a clean work view, then show them again when you want the record.

How To Strike Out Text In Excel Without Slowing Yourself Down

The fastest long-term habit is simple: use the shortcut on desktop, use the Home tab on the web, and save the Format Cells route for the times you are already changing several font settings at once.

If you work in checklists all day, Ctrl+5 on Windows or Shift+Cmd+X on Mac will feel natural after a few rounds. If you work in shared browser files, the ribbon button is the easiest path to teach others. If you only need strikethrough now and then, any method will do the job.

So, how to strike out text in Excel comes down to this: select the cell, apply strikethrough, and use it with a clear purpose. That one small line can make a worksheet easier to read, easier to update, and a lot less messy.

Send us your feedbackTell us what you thought about this post

Name * Email *

Your comment *

Quick check — what is …? *

Send feedback