Excel Shortcut for Strikethrough: Complete Guide to Crossing Out Text in Excel

The excel shortcut for strikethrough is one of those tiny productivity wins that transforms how you manage task lists, inventories, and project trackers inside spreadsheets. On Windows, the keystroke is Ctrl+5, while Mac users press Cmd+Shift+X to draw that crisp horizontal line through any selected cell or text fragment. Once you learn this combination, you stop reaching for the mouse, stop hunting through the Format Cells dialog, and start completing visual updates in under a second. It is genuinely one of the fastest formatting tools Microsoft ships with the application.

Strikethrough formatting matters because it communicates status without consuming a separate column. A line drawn through a row tells the reader the task is finished, the item is sold, or the entry should be ignored, all while preserving the original data for audit purposes. Unlike deletion, strikethrough is reversible and non-destructive. Pair it with conditional formatting and a checkbox column, and you can build self-updating to-do lists that visually decay as work completes, similar to how popular apps like Todoist or Notion handle done items.

Many people who reach for strikethrough also wrestle with adjacent skills like building dropdowns for status fields. If you handle those alongside, study the related lesson on how to create drop down list in excel to round out your formatting toolkit. The two features work hand in hand: a dropdown captures the status value, and conditional formatting applies strikethrough automatically when that value flips to Done, Closed, or Complete. Combined, they replace whole rows of clunky helper formulas with elegant interactive design.

This article walks through every angle of the strikethrough shortcut, from raw keystrokes to ribbon paths, from conditional rules to mobile workarounds. We cover Windows, Mac, Excel for the web, and Excel for iPad. We dig into partial-text strikethrough inside a cell, batch application across hundreds of rows, and the surprisingly common bug where the shortcut conflicts with system-level hotkeys. By the end, you will know not just the keystroke but the seven different ways to apply, automate, and remove strikethrough across any spreadsheet.

Strikethrough also plays a starring role in collaborative workflows. When five teammates share a workbook, the visual cue of a struck-through line carries meaning faster than reading a status column. Imagine reviewing a 400-row inventory: skimming for crossed-out items is instant, while reading every status cell takes minutes. That speed advantage compounds across daily standups, weekly reviews, and quarterly clean-ups. Strikethrough is small, but at scale it returns hours of attention back to higher-value work.

One important caveat before we dive deeper: strikethrough is a font attribute, not a value. It does not change what is stored in the cell, only how the cell displays. Formulas referencing struck-through cells return the same number they would otherwise. That is usually what you want, but if you need formulas to react to the formatting, you must use a helper column, VBA, or a checkbox-driven conditional rule. We will cover all three patterns so you can choose what fits your situation best.

Finally, this guide treats strikethrough as a gateway skill. Once Ctrl+5 lives in muscle memory, the leap to other format shortcuts like Ctrl+B for bold, Ctrl+I for italic, and Ctrl+U for underline becomes natural. By the time you finish reading, you will have a complete mental map of Excel's quick-format universe and the confidence to layer them together for richer visual reporting.

Applying strikethrough begins with selecting the right scope. You can target an entire cell, an entire row, a column, a contiguous range, or even a few characters within a longer string. Each scope responds to Ctrl+5 the same way, but the underlying behavior differs subtly. Selecting a whole cell stores the strikethrough attribute on the cell's font property, while selecting partial text stores it on a rich-text run inside the cell. Both look identical, but the partial-text version survives clipboard operations more reliably.

To strike through a single cell, click into it once so the cell is highlighted but you are not in edit mode, then press Ctrl+5. The entire visible value gains the horizontal line. To strike through several cells, drag-select or hold Shift and click the last cell in your range, then press the shortcut. Excel applies the format to every selected cell simultaneously, which is how power users mark dozens of completed tasks in a single keystroke.

Partial-text strikethrough requires entering edit mode. Press F2 on Windows or Control+U on Mac to drop the cursor inside the cell, then highlight just the characters you want to cross out. Press Ctrl+5 again. Only the highlighted run will display the line, while the rest of the cell remains untouched. This is invaluable when you want to indicate a price change inside a description, such as showing the old price struck out next to the new one in marketing materials.

For non-adjacent selections, hold Ctrl on Windows or Cmd on Mac while clicking each target cell. Excel keeps every selected cell active even though they are not touching. Press the shortcut once and every cell receives the format. This pattern shines when you are marking specific rows in a long list, such as defective serial numbers in an inventory or absent students in an attendance log. It is faster than filtering, marking, and removing the filter, and it keeps the surrounding context visible.

If you prefer the ribbon, the strikethrough button lives inside the Font dialog launcher rather than directly on the Home tab. Click the small arrow at the bottom right of the Font group, then check the Strikethrough box under Effects. You can also add the button directly to the Quick Access Toolbar so it sits one click away from any worksheet. Many heavy users do this on day one and never reach for the dialog again, gaining the same speed as the shortcut.

Power users also chain strikethrough with other format shortcuts to communicate richer status. Apply Ctrl+5 plus Ctrl+B together to mark items as both complete and important, or combine it with a light gray font color to fade completed tasks into the background. Want even finer control? Pair it with the techniques you can pick up from the deeper guide on excellent face wash spreadsheet filtering, which complements visual status cues with selective rows.

Lastly, remember that strikethrough survives most copy-paste operations. If you copy a struck cell with Ctrl+C and paste it elsewhere with Ctrl+V, the line travels with the value. To paste only the value without the format, use Paste Special with the Values option, which is Ctrl+Alt+V then V on Windows. This is essential when you transfer working data into clean report sheets that should never display the visual status of the source workbook.

Conditional strikethrough is where the feature graduates from convenience to genuine workflow automation. Instead of pressing Ctrl+5 every time a task closes, you build a rule that tells Excel to apply the format whenever a specified cell contains a specified value. The most common pattern uses a Status column with values like Open, In Progress, and Done. When the status flips to Done, the entire row strikes itself through, no manual intervention needed.

To configure this, select the rows you want to govern, then open Home, Conditional Formatting, New Rule, and choose Use a formula to determine which cells to format. Enter a formula such as =$E2="Done" assuming column E holds your status. Click Format, switch to the Font tab, and tick Strikethrough. Click OK twice. Now every row whose status equals Done will display a line across all its cells, and the rule updates the moment the value changes.

You can extend this with multiple conditions. For example, strike rows where the status equals Done or where the due date has passed by thirty days. Use a formula like =OR($E2="Done",TODAY()-$D2>30) to chain the logic. This is especially useful for project trackers where stale tasks should fade out regardless of their status. The rule engine evaluates every row on every recalculation, so changes propagate instantly without lag, even in workbooks with thousands of rows.

Another powerful pattern uses a checkbox-driven column. With Microsoft 365 you can insert native checkboxes from the Insert menu. Each checkbox becomes a TRUE or FALSE value in its cell. Reference that cell in a conditional formatting rule, and clicking the checkbox now visually crosses out its entire row in real time. Combine this with subtle gray font color and you get a strikingly clean visual style that mirrors what apps like Things, Microsoft To Do, and Linear deliver natively.

For advanced control, color-bind your strikethrough rules. You might apply red strikethrough for canceled items, gray strikethrough for completed ones, and orange strikethrough for deferred ones. Each rule lives independently in the Conditional Formatting Rules Manager and you can reorder them so that the highest-priority rule wins when multiple conditions match a single row. This stacking is exactly how heavy-data teams manage hundreds of statuses without ever touching the format menu.

Conditional strikethrough also plays well with structured tables. Convert your range to a table with Ctrl+T, then apply the rule to the whole column. New rows added at the bottom inherit the rule automatically. That is the secret to maintenance-free trackers: build the rules once and add data forever. Pair this with sorting and filtering and your spreadsheet becomes a low-friction project tool that scales from a personal task list to a team-wide planning board.

Finally, document your rules. Conditional formats are invisible until they fire, which means a teammate inheriting your workbook may be baffled by self-striking rows. Drop a short legend in a corner cell or a hidden tab that explains the trigger values, the colors, and the meanings. Three sentences of documentation prevent hours of confusion later, especially when the original author moves to a different project and someone else inherits the workbook.

Most strikethrough problems trace back to one of four root causes: the wrong cell scope, a missing key combination on your platform, a lingering manual format overriding a conditional rule, or a font that does not render the strikethrough line cleanly. The first symptom is usually a shortcut that appears to do nothing. Before assuming the feature is broken, confirm you are in cell-select mode rather than edit mode, because the two modes interpret Ctrl+5 differently when no characters are highlighted.

If the shortcut still seems inert, open File, Options, Customize Ribbon, Keyboard Shortcuts on Windows and search for Strikethrough. Verify that Ctrl+5 is still assigned. Some add-ins or corporate IT policies remap shortcuts at install time, and that is the single most common reason long-time Excel users suddenly find Ctrl+5 inoperative. Reassign it by clicking Press New Shortcut Key, pressing Ctrl+5, and clicking Assign. Confirm in any blank workbook before relying on it again.

Another common pitfall happens when a manual strikethrough fights a conditional formatting rule. Excel applies conditional formats on top of manual ones, but if the conditional rule does not specify font effects, the manual line remains visible. To strip everything cleanly, select the cells, press Ctrl+Spacebar to highlight whole columns or Shift+Spacebar for rows, then apply Clear Formats from the Home tab. This wipes both manual and conditional layers and lets you start fresh, especially helpful when inheriting a messy workbook.

Fonts also matter. Most modern fonts including Calibri, Arial, and Aptos render strikethrough as a clean horizontal line through the x-height of the characters. Decorative or script fonts sometimes render the line in unexpected positions, particularly with descenders. If you produce reports that will be exported to PDF or printed, test a sample first and switch to a more conservative font if the line looks off. Want to layer strikethrough with frozen reference rows? Read the companion guide on excellent family dogs for full freeze-panes coverage.

When working with shared workbooks on OneDrive or SharePoint, strikethrough applied through the desktop app sometimes fails to sync immediately to coauthors on the web. The usual remedy is to press Ctrl+S explicitly, wait two or three seconds for the cloud round-trip, and ask coauthors to refresh. If a coauthor is editing the same row at the moment of save, the format may revert when Excel resolves the merge. Avoid this by coordinating who edits which range during collaborative sessions.

For users on the web edition, the absence of a Ctrl+5 binding is the most reported friction. The workaround is to expose Strikethrough through the Home tab font menu and pin it via the customization panel. Microsoft has discussed adding the binding to parity with desktop, but as of this guide that change has not shipped. In the meantime, plan around the gap when sharing workbooks with users restricted to browser-only access.

Finally, watch for the bug where Ctrl+5 toggles strikethrough on the formula bar instead of the cell when you accidentally clicked into the bar. The shortcut works on whatever has focus, and the formula bar accepts formatting just like a cell. Press Escape to leave the bar without committing changes, click back on the worksheet, and press Ctrl+5 again. This small detail trips up newcomers more often than any other issue we see in support forums.

Practical mastery of strikethrough goes beyond the keystroke. Build a personal cheat sheet that lists Ctrl+5 alongside Ctrl+B, Ctrl+I, Ctrl+U, Ctrl+1, and Ctrl+T. Tape it to your monitor for a week. Within five working days your fingers will reach for these shortcuts without your conscious mind. That single week of intentional practice pays dividends for years, because formatting tasks happen dozens of times per day across spreadsheets, decks, and even some email clients that share keybindings.

Develop a visual vocabulary for your team. Decide together what strikethrough means: completed, canceled, deprecated, or duplicate. Inconsistent meanings dilute the signal and force readers to interpret each instance from context. A short standards page in your team wiki, listing colors, formats, and their meanings, makes every workbook self-documenting. Visual conventions compound: the more disciplined the team, the faster everyone can read each other's sheets without asking what a particular format signifies.

For more advanced cleanup, master the technique covered in the lesson on colleges of excellence spreadsheet hygiene. Knowing how to identify and consolidate unique entries pairs naturally with strikethrough, because you often strike duplicates as part of a deduplication review. Combined with the Remove Duplicates command from the Data tab, you get a two-step workflow: mark, then remove, with full audit trail intact thanks to the visible struck rows that preserve history.

Periodically audit your workbooks. Schedule a quarterly review where you scroll through long sheets and either delete struck rows or move them to an Archive tab. Visual debt accumulates the same way technical debt does, and stale strikethrough rows clutter sheets just as commented-out code clutters source files. A clean working area improves performance, both perceptually for the human reader and computationally for Excel, which spends fewer resources rendering hidden or stale formatting.

If you build dashboards, treat strikethrough as a status indicator rather than decoration. Combine it with sparklines, data bars, and color scales so readers can scan a board and absorb status in two or three seconds. Avoid mixing strikethrough with the same color you use for negative numbers, since that pairing reads as a red flag and can mislead executives. Thoughtful color discipline keeps the visual language precise, especially during quarterly business reviews when attention is at a premium.

For accessibility, remember that strikethrough alone is not a sufficient signal for users with low vision or colorblindness. Pair it with a redundant cue such as a status column, an icon, or a category label. Screen readers do not announce font strikethrough by default, which means a visually impaired user cannot tell a struck row from an active one. Always reinforce visual formatting with a text or symbol layer that assistive technology can convey, so your reports remain inclusive for every member of your audience.

Finally, keep learning. Strikethrough is one micro-skill in a much larger Excel landscape. Mastering it opens the door to conditional formatting, structured tables, dynamic arrays, and the wider keyboard-shortcut ecosystem. Each small win compounds. By the end of a focused year you will move through Excel with the confidence of a power user, and the casual observer will wonder how you produce in an hour what others take a day to assemble. Start with Ctrl+5 today, and let the momentum carry you forward.