How To Strike Out A Word In Excel: Step-by-Step Shortcuts And Advanced Formatting

To strike out an entire cell in Excel, select the target cell and press Ctrl + 5 on Windows or Command + Shift + X on Mac. To strike out only a single word within a cell, double-click the cell to enter Edit Mode, highlight the specific word, and apply the same shortcut or select Strikethrough from the Font dialog box. These techniques instantly visually signal completed tasks, deprecated values, or edited records across all versions of Excel.

Pre-Formatting Assessment and Required Environment Setup

Applying strikethrough formatting in Microsoft Excel requires a basic understanding of how the spreadsheet engine handles cell content. Unlike dedicated word processors, Excel distinguishes between formatting an entire cell and formatting individual characters within a cell. This distinction dictates whether you are working in Cell Selection Mode or Cell Edit Mode.

Before proceeding, ensure your spreadsheet environment meets the following baseline criteria to prevent formatting conflicts or lost data:

• Application Compatibility: These instructions apply to Microsoft 365, Excel desktop editions (2019, 2016, 2013), Excel for Mac, and Excel for the Web. Note that Excel for the Web supports basic cell-level strikethrough but has limitations regarding partial text formatting inside formulas.
• Prerequisite Knowledge: You must identify whether your target cell contains a static string, a number, or a dynamic formula. Formulas do not allow partial word formatting; you can only strike out the entire output of a formula cell.
• Estimated Execution Time: Under 10 seconds for keyboard shortcuts; 1 to 2 minutes for setting up automated conditional formatting rules.
• Required Tools: Standard keyboard, mouse, and a working installation of Microsoft Excel. No external plug-ins or add-ins are necessary.

Mastering Strikethrough Execution in Excel: Standard and Advanced Methods

Excel provides multiple workflows to strike out text depending on your efficiency preferences and presentation needs. Below are the step-by-step operational instructions for manual, partial, and automated strikethrough formatting.

Step 1: Striking Out a Specific Word Within a Cell (Partial Text Formatting)

If a cell contains multiple words and you only want to cross out a single word while leaving the surrounding text untouched, you must enter Excel’s internal Edit Mode.

1. Navigate to the cell containing the text you wish to edit.
2. Double-click the cell to place your cursor inside it. Alternatively, select the cell and press the F2 key on Windows, or Control + U on Mac, to enter Edit Mode. You can also click directly into the Formula Bar at the top of the worksheet.
3. Use your mouse to click and drag across the exact word you want to strike out. If using a keyboard, hold the Shift key and use the Left or Right Arrow keys to highlight the word character by character.
4. Press the keyboard shortcut Ctrl + 5 on Windows, or Command + Shift + X on Mac.
5. If you prefer using the graphical user interface, right-click the highlighted word, select Format Cells from the context menu, locate the Effects section on the Font tab, and check the box labeled Strikethrough. Click OK.
6. Press Enter on your keyboard to commit the changes and exit Edit Mode.

Warning: Do not attempt this on cells containing formulas like =A1&" "&B1. Excel will not allow you to enter Edit Mode to format individual components of a formula output. To format a single word in this scenario, you must first copy the cell and paste it as a static value by right-clicking and selecting Paste Values.

Step 2: Striking Out an Entire Cell Using Keyboard Shortcuts

When you need to cross out all contents within a cell, including numbers, dates, or whole sentences, the quickest execution method is the native toggle shortcut.

1. Click once on the cell or highlight a range of multiple cells you wish to format. Do not double-click or enter Edit Mode.
2. Press Ctrl + 5 on your Windows keyboard. If you are operating on macOS, press Command + Shift + X.
3. The strikethrough line will immediately appear horizontally through the center of all selected cell contents.
4. To remove the strikethrough formatting, select the same cells and press the exact same shortcut key combination. This acts as a global toggle.

Pro-Tip: This keyboard shortcut can be applied to entire rows or columns. Select the row number on the far left of the screen or the column letter at the top, then press Ctrl + 5 to instantly apply a line-through effect to thousands of data points at once.

Step 3: Accessing Strikethrough via the Font Dialog Box

If your keyboard shortcuts are intercepted by third-party background software, or if you prefer using the mouse, the standard Font Dialog box offers full formatting control.

1. Click on the cell or highlight the specific range of cells you want to modify.
2. Look at the Home tab on the top ribbon menu. Locate the Font section in the bottom right corner of this button group and click the small, diagonal arrow icon (the Dialog Box Launcher). Alternatively, press Ctrl + 1 on Windows or Command + 1 on Mac.
3. In the Format Cells window that appears, ensure you are on the Font tab.
4. Navigate to the middle-right section of the window under the Effects header.
5. Check the box next to Strikethrough. You will see a real-time rendering of the change in the Preview box at the bottom of the window.
6. Click the OK button to apply the setting and close the window.

Step 4: Automating Strikethrough with Conditional Formatting

To create a dynamic task list or tracking sheet where a word or row automatically strikes itself out when a specific condition is met, use Excel's Conditional Formatting engine.

1. Highlight the range of cells containing the words you want to strike out automatically. For example, select cells A2 through A100.
2. Go to the Home tab on the ribbon menu, click the Conditional Formatting button, and select New Rule from the dropdown list.
3. In the New Formatting Rule dialog box, click on the option labeled "Use a formula to determine which cells to format".
4. In the formula input field, enter a rule based on your trigger column. For example, if you want cell A2 to strike out when cell B2 contains the word "Complete", type the formula: =$B2="Complete"
5. Click the Format button on the bottom right of the dialog box to open the formatting options.
6. In the Format Cells window, go to the Font tab and check the Strikethrough box. Click OK.
7. Click OK once more to save the rule. Now, whenever you type "Complete" in Column B, the corresponding word or text in Column A will instantly display a strikethrough.

Excel Strikethrough Methods: Compatibility and Functional Specifications

The table below outlines the core differences, system requirements, and structural limitations of the various strikethrough methods available within Microsoft Excel.

Resolving Excel Formatting Failures and Strikethrough Glitches

Even experienced users run into formatting roadblocks when managing complex Excel workbooks. Use these diagnostic pathways to resolve common strikethrough issues.

Strikethrough Option is Grayed Out in the Menu

• Root Cause: This occurs when your worksheet is protected, when you are trying to format cells in a shared workbook with restricted permissions, or when you are actively typing inside a formula that has unresolved syntax errors.
• Actionable Fix: First, press the Escape key to exit any active cell entry. Go to the Review tab on the top ribbon and check if the Unprotect Sheet button is visible. If the sheet is protected, click Unprotect Sheet (enter the password if prompted) to restore full formatting capabilities.

Strikethrough Shortcut Applies to the Whole Cell Instead of One Word

• Root Cause: You pressed the keyboard shortcut while the cell was in Selection Mode (highlighted with a thick green border) rather than Edit Mode (with an active flashing cursor inside the text).
• Actionable Fix: Double-click directly inside the cell first. Ensure the text insertion cursor is flashing, drag your mouse to select only the target word, and then press Ctrl + 5 or Command + Shift + X.

Conditional Formatting Rule Does Not Trigger Strikethrough

• Root Cause: The logic formula in your conditional formatting rule contains absolute reference errors (incorrect placement of the dollar sign $), or the trigger text has leading or trailing spaces that prevent an exact match.
• Actionable Fix: Select your formatted range and go to Home > Conditional Formatting > Manage Rules. Click Edit Rule. Verify that your formula uses a mixed reference, such as =$B2="Complete", which locks column B but allows the row number to change dynamically. Use the TRIM function if your source data contains accidental blank spaces.

Strikethrough Styling Disappears When Copying and Pasting Data

• Root Cause: The destination cells have conflicting cell styles, or you used a paste method that only transfers values, discarding all font formatting metadata.
• Actionable Fix: When pasting your text, do not use the standard value paste. Instead, press Ctrl + V, or right-click and choose Paste Special, then select Formulas and Number Formats or keep source formatting to preserve the strikethrough design.

Frequently Asked Questions

How do you strike out text in Excel on Mac?

To strike out text on a Mac, select the cell or highlight a specific word inside the cell, and press Command + Shift + X. Alternatively, you can press Command + 1 to open the Format Cells dialog box, navigate to the Font tab, and check the Strikethrough option under the Effects settings.

Can you apply strikethrough to a formula result in Excel?

Yes, you can apply strikethrough to a cell containing a formula, but you can only apply it to the entire evaluated output of the formula. Excel does not allow you to enter Edit Mode to select and format individual words generated by dynamic formulas. If you must format only one word, you must first convert the formula to static text by copying the cell and pasting it as a value.

How do you automatically strike out completed tasks in Excel?

You can automate this process by using Conditional Formatting. Select your task list, create a new rule, and use a custom formula like =$B2="Completed" (assuming your status column is Column B). Click the Format button, go to the Font tab, enable Strikethrough, and click OK. The task text will cross out instantly as soon as you mark the status as Completed.

How do you remove strikethrough formatting in Excel?

To remove strikethrough, select the formatted cells and press the Ctrl + 5 shortcut on Windows or Command + Shift + X on Mac to toggle the effect off. If the strikethrough was applied via a Conditional Formatting rule, you must clear the rule by going to Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells.

Is there a strikethrough button on the Excel Home tab by default?

No, Microsoft Excel does not include a dedicated strikethrough button on the default Home ribbon. To access it with a single click, you must customize your Quick Access Toolbar by going to Excel Options, choosing Quick Access Toolbar, selecting All Commands, searching for Strikethrough, and clicking Add to place it at the top of your interface.

Streamline Your Data Management Workflows

Mastering cell formatting options is key to building clear, professional, and readable spreadsheets. Elevate your data analysis capabilities by integrating automated conditional rules that keep your project trackers accurate and visually intuitive.