Strikethrough is the formatting effect that draws a horizontal line through the middle of selected text. In Excel, it is one of the fastest ways to mark something as done, removed, or simply not relevant anymore. The styling is universally understood, prints cleanly, copies into other Office apps, and survives most data exports without trouble. Think of it as Excel's built-in highlighter pen for tasks that no longer need your attention.

You'll see it on to-do lists, inventory sheets, budget trackers, and pretty much any workbook where someone wants to keep a record without deleting the original value. The good news? You don't need to dig through menus to apply it. A two-key shortcut handles the job in well under a second, and once it lives in your muscle memory you'll wonder how you survived without it.

The fastest way to strike text in Excel is the keyboard shortcut. On Windows that's Ctrl + 5, and on Mac it's Cmd + Shift + X (or Cmd + 5 in newer versions of Excel for Mac). Select a cell, press the shortcut, done. Press it again and the line disappears. It really is that simple once you know which keys to hit, and the same combo works inside the formula bar when editing partial text.

Excel also lets you reach the same setting through the Format Cells dialog, a ribbon button you can add yourself, conditional formatting rules that trigger automatically, and a one-line VBA macro if you really want to automate the action. You'll learn all of those below, along with the gotchas that catch out new users and the quick fixes that save the day. By the end you'll know every reliable path to strikethrough in Excel on Windows, Mac, and the web.

Why would anyone bother memorising this? Because strikethrough turns out to be one of those small workflow upgrades that pays back over and over. Once you can mark a row as done without deleting it, you start using Excel differently. Tasks don't vanish, they just fade. Decisions leave a trail. Spreadsheets become living records rather than disposable scratch pads. That's the real promise of the Ctrl + 5 shortcut: not the keystroke itself, but the way it changes how you think about your data over time.

Most people learn the shortcut once and never look back. But Excel actually gives you several ways to apply strikethrough depending on where you are and what you need. The keyboard shortcut is fastest for everyday use. The Format Cells dialog is the most reliable choice, especially on older versions of Excel where some shortcuts behave inconsistently. And on a touchscreen device, neither shortcut helps you much, which is why having a Quick Access Toolbar button matters.

Conditional formatting is the smart pick when you want strikethrough to appear automatically based on a value somewhere else in the sheet. And the Quick Access Toolbar gives you a mouse-friendly option for users who prefer clicks over keys. Pick the method that matches your situation, and feel free to mix them inside the same workbook.

One thing worth knowing upfront: the Ctrl key uses the number row 5, not the numeric keypad. A lot of users press Numpad 5 and wonder why nothing happens. Use the 5 along the top row of your keyboard, the one above the T and Y keys. If you're on a laptop without a numpad, you're already in the right spot. Some external keyboards even disable the top row when NumLock is off, so toggle NumLock first if your shortcut still won't fire.

This little gotcha trips up newcomers more often than you'd think, so it's worth flagging right at the start before we go any deeper. Test it on a single cell first to confirm your keyboard is sending the right key, then you can safely apply it to wider selections without surprise.

You'll find strikethrough useful in more places than you might expect. It's the go-to formatting for tracking what's complete, what's been removed, and what's no longer worth your attention. Teachers grade papers with it. Editors mark deleted phrases. Lawyers redline contracts. Once you start looking, you see strikethrough everywhere as a signal that something used to matter and now doesn't.

To-do lists are the obvious one: tick off a task by striking through it instead of deleting, and you keep a visible record of what got done. Inventory sheets work the same way, since marking items as sold or discontinued keeps the historical row intact for audits and reporting. Teams that share workbooks especially love this approach because nobody loses track of what was once on the list.

Budget trackers benefit too. Cross out paid bills as the month progresses and you've got an at-a-glance view of where the money has actually gone. Some folks combine strikethrough with a related shortcut for subscript in Excel when annotating chemistry or maths workbooks, since these formatting tools play nicely together for technical documents.

The principle is the same: small visual cues that communicate status without cluttering up your data. Used sparingly, strikethrough sharpens a workbook. Used everywhere, it turns the sheet into a mess, so save it for the moments that genuinely deserve a visible cross-out.

Sales teams keep struck rows on a pipeline sheet to remember which prospects fell through, what stage they died at, and roughly when. Recruiters do the same with candidate lists. Property managers cross out tenants who moved out. Event planners mark vendors who declined the brief. Coaches strike completed drills, project leads strike closed tickets, and travel planners strike booked legs of an itinerary.

The pattern is consistent: keep the data, dim the visual weight. Compared with deleting rows outright, strikethrough preserves analytical value while signalling status. Compared with a status column alone, it adds visual immediacy that you can spot in a quarter of a second across a dense table.

Now for the trick that makes strikethrough genuinely powerful: conditional formatting in Excel. Instead of striking cells one by one as tasks complete, you tell Excel to do it automatically whenever a status column shows "Done" or whatever value you choose. This shifts strikethrough from a manual action you remember to take into a passive system that runs in the background.

It's how busy spreadsheets keep themselves tidy without you babysitting them. The setup takes a minute, but once it's running you'll never type Ctrl+5 on that sheet again. Project managers, accountants, and analysts all rely on this technique to keep large workbooks readable.

The idea is straightforward. You pick the cells you want Excel to format. You write a formula that returns TRUE when those cells should be struck through. Then you tell Excel which formatting to apply when the formula is TRUE. Excel watches your sheet and applies the formatting on the fly as values change.

Magic, really, especially on a busy Excel dashboard where you want completed items to fade into the background automatically. The same approach works for due-date triggers, percentage thresholds, or any logical condition you can express as a formula.

A few practical formula patterns: =$B2="Done" strikes rows when a status column says Done. =$C2<TODAY() strikes rows past their due date. =$D2>=$E2 strikes rows where actual hours exceed budgeted hours. The dollar signs anchor the column reference while the row number stays relative so the rule scales correctly down your range.

And =COUNTIF($A:$A,$A2)>1 strikes duplicates. Mix and match these triggers to build sheets that essentially manage themselves. The first time you watch your spreadsheet apply strikethrough automatically because someone typed Done two columns over, you'll feel like you just unlocked a hidden level of Excel.

If you find yourself reaching for strikethrough constantly, add it to the Quick Access Toolbar. Excel ships with hundreds of commands tucked away in menus, and the Quick Access Toolbar is the strip at the very top where you can pin the ones you actually use. It's the simplest customisation in Excel and pays off the moment you stop hunting for the Format Cells dialog every time you need to strike a row.

Click File → Options → Quick Access Toolbar. Under Choose commands from, pick Commands Not in the Ribbon. Scroll to Strikethrough, click Add, then OK. Drag it up to the top of the list if you want it as the first button, since position one earns the Alt + 1 alt-key shortcut.

Once it's there, you can press Alt followed by the position number of your new button (Alt + 5 if it's the fifth icon, for example) for an alternative shortcut. Some people prefer this to Ctrl + 5 because it doesn't conflict with anything else, and it gives you a discoverable button that team members can spot without needing to know the keystroke.

The Quick Access Toolbar also persists across workbooks, so set it up once and you'll have strikethrough one click away forever. You can export your toolbar config from File → Options → Customize Ribbon if you want to share the setup with colleagues or move it to a new machine.

You can also right-click the Quick Access Toolbar and choose Show Below the Ribbon, which puts your custom buttons closer to the cells you're actually editing. It's a small ergonomic tweak that adds up over a long workday.

Similarly, you can right-click any ribbon command and pick Add to Quick Access Toolbar straight from the menu, skipping the Options dialog entirely. That's the fastest way to build a custom toolbar over time: every time you use a command twice, pin it.

That sequence isn't an accident. Microsoft built a clean pattern from Ctrl+1 through Ctrl+5 that covers the formatting basics every spreadsheet user needs. Bold, italic, underline, strikethrough, all sitting on the number row in logical order. Once you internalise the pattern, your fingers find the right key by feel rather than by sight, and you stop interrupting your thinking to format cells.

If you're learning Excel shortcuts, learning this run of five gives you a solid foundation for the rest. Want even more shortcut combos? Check the Excel formulas cheat sheet for a printable list of the most-used keys. Print it, stick it to the side of your monitor, and you'll absorb the rhythms of Excel formatting in days rather than months.

Removing strikethrough is just as fast as adding it. Select the struck cell, press Ctrl + 5 again, and the line disappears. The Format Cells dialog method works in reverse too: open it, uncheck Strikethrough, click OK.

If you want to nuke every bit of formatting on a cell, use Home → Clear → Clear Formats instead, but that strips everything including borders, fonts, and colours, not just the strikethrough. For surgical removal of just one effect, stick to the shortcut or the dialog. Use Format Painter from an unstruck cell to copy clean formatting onto a struck one as another quick alternative.

You can also apply strikethrough to part of a cell rather than the entire thing, which is handy for editing notes or marking specific words in a longer string. Double-click the cell to enter edit mode (or click into the formula bar). Highlight the exact characters you want to strike. Press Ctrl + 5. Hit Enter. Excel keeps the rest of the cell content perfectly intact.

Only the highlighted portion gets the line, and the rest of the cell stays untouched. This is useful for things like product descriptions where you want to mark one feature as discontinued without rewriting the whole entry. Editorial teams use the same trick to flag draft language for review without rewriting the surrounding sentence.

For users who like to mix formatting tools, strikethrough pairs nicely with superscript in Excel when annotating cells. You might strike a price and add a superscript footnote pointing to a discount, or strike a measurement and use superscript for units.

The combination keeps cells compact while still communicating multiple bits of information at once. Just keep accessibility in mind, since screen readers can't always announce strikethrough or superscript reliably, so for inclusive workbooks add a status column with plain-text labels alongside the visual cues.

VBA users have an extra option in their toolkit. With a tiny macro you can apply strikethrough to a selection on demand and bind it to a button or another shortcut. The code is just three lines: Sub ApplyStrikethrough() / Selection.Font.Strikethrough = True / End Sub. You can save it in your personal macro workbook to make it available across every file you open.

Paste it into a module via Alt + F11, save the workbook as macro-enabled (.xlsm), and run with Alt + F8. Swap True for False to make a removal macro. Add both to the Quick Access Toolbar and you have one-click strike and unstrike that works across selections of any size. Power users sometimes wire these macros into worksheet events so strikethrough fires the instant a checkbox is ticked.

One limitation worth flagging: you cannot apply strikethrough inside a formula. Formulas calculate values, not formatting, so there's no =STRIKE(A1) function. The workaround is conditional formatting with a formula trigger, which gets you the same result and updates automatically as soon as the trigger cell changes.

Some people try to fake it with Unicode combining characters, but that breaks copy-paste, sorting, and printing. Stick to conditional formatting for dynamic effects. If you genuinely need strikethrough inside text exported to another system, generate the formatting in the target tool, not in Excel.

A quick word on Excel for the Web. The browser version of Excel supports strikethrough through the shortcut and through Format Cells, so you can apply and remove it just like the desktop app. Conditional formatting with formula triggers also works fully. The main gap is VBA and macro automation, which aren't available in the web version, but for the vast majority of users that gap will never matter.

If you're collaborating with someone using Excel Online, they'll see strikethrough you applied on desktop and they can toggle it themselves with the same Ctrl + 5 shortcut. Cross-platform consistency is honestly one of Excel's quiet superpowers, and strikethrough is a good example of that consistency in action.

Beyond the basics, strikethrough is a tool you'll keep coming back to as your Excel workbooks grow. The shortcut takes a second to learn and saves hours over the long run. Pair it with conditional formatting and you've got self-updating to-do lists, dynamic inventory sheets, and budget trackers that mark themselves complete without anyone reaching for the keyboard.

Add it to the Quick Access Toolbar if you prefer mouse clicks. Whichever method you pick, you'll wonder how you managed before. The bottom line: master Ctrl + 5 on Windows or Cmd + Shift + X on Mac, set up one conditional rule on your busiest sheet, and you've covered ninety-five percent of what most people ever need from this feature. The rest is detail you can pick up as it comes.