How To Put A Line Through A Word In Excel: The Complete Guide To Strikethrough Formatting

Applying a line through a word in Excel, known as strikethrough, is achieved most efficiently by selecting the target cell and pressing the keyboard shortcut Ctrl + 5. Users can also access this feature via the Format Cells dialog (Ctrl + 1) under the Font tab or automate the process through Conditional Formatting rules to visually indicate completed tasks or deprecated data points.

Prerequisites for Professional Spreadsheet Formatting and Audit Preparation

Before implementing visual formatting like strikethrough, it is essential to understand that this action is purely cosmetic and does not alter the underlying data value or the cell's ability to be calculated in formulas. Strikethrough is a standard industry practice in auditing, project management, and inventory tracking to denote items that have been processed, cancelled, or verified without deleting the historical record.

• Software Requirements: Microsoft Excel (Office 365, Excel 2021, 2019, 2016, or Excel for the Web).
• Hardware Interface: Standard QWERTY keyboard for shortcut execution or a functional mouse/trackpad for GUI navigation.
• Mandatory Knowledge: Basic cell selection techniques and familiarity with the Excel Ribbon interface.
• Estimated Duration: 2 seconds for shortcuts; 30 seconds for manual menu navigation; 3 minutes for automated conditional formatting setup.
• Project Scope: Applicable to individual characters, full cell strings, or entire rows based on logic-based triggers.

Advanced Execution Workflows for Applying Strikethrough

Excel provides multiple pathways to apply strikethrough formatting, ranging from rapid-fire keyboard commands to sophisticated automated triggers. Understanding these different methods allows for greater flexibility depending on whether you are editing a single entry or managing a massive dataset.

Step 1: Rapid Application via Keyboard Shortcuts

The most efficient method for high-speed data entry is the dedicated keyboard shortcut. This method toggles the strikethrough effect on and off instantly without requiring menu navigation.

1. Navigate to the specific cell or range of cells containing the text you wish to strike through.
2. Press and hold the Control key (Ctrl) on your keyboard.
3. Press the number 5 key (located on the main keyboard, not the numeric keypad).
4. To remove the line, repeat the same command (Ctrl + 5) while the cells are selected.

Pro-Tip: If you are using a Mac, the shortcut is Command + Shift + X. This is one of the few shortcuts that differs significantly from the Windows standard of Ctrl + 5.

Step 2: Utilizing the Format Cells Dialog for Granular Control

When you require more than just a strikethrough—such as changing the font color or size simultaneously—the Format Cells dialog is the preferred professional interface.

1. Select the target cell or highlight a specific portion of text within the Formula Bar if you only want to strike through a single word in a sentence.
2. Right-click the selection and choose Format Cells from the context menu, or press Ctrl + 1.
3. In the dialog box that appears, ensure the Font tab is active.
4. Locate the Effects section in the lower-middle portion of the window.
5. Check the box labeled Strikethrough.
6. Click OK to apply the changes.

Warning: Applying strikethrough via the Format Cells dialog while in "Edit Mode" (double-clicking inside a cell) will only apply the format to the characters currently highlighted, not the entire cell contents by default.

Step 3: Customizing the Quick Access Toolbar for Single-Click Access

By default, the Strikethrough button is not visible on the Home tab of the Excel Ribbon (unlike Microsoft Word). Power users frequently add this button to their Quick Access Toolbar (QAT) for immediate mouse-driven access.

1. Click the small downward-facing arrow at the very top-left of the Excel window (the Quick Access Toolbar).
2. Select More Commands from the dropdown menu.
3. In the "Choose commands from" dropdown, select All Commands.
4. Scroll down the alphabetical list until you find Strikethrough.
5. Click the Add button to move it to the right-hand column.
6. Click OK. The Strikethrough icon will now appear at the top of your Excel window for one-click usage.

Step 4: Automating Strikethrough with Conditional Formatting

For project trackers and To-Do lists, manual application is inefficient. You can program Excel to automatically put a line through a word when another cell meets a specific criteria, such as a status changing to "Complete."

1. Highlight the range of cells where you want the strikethrough to appear automatically (e.g., Task Names in column A).
2. Click on the Home tab, then select Conditional Formatting, and choose New Rule.
3. Select the option: Use a formula to determine which cells to format.
4. In the formula box, enter a logical test. For example, if you want Column A to strike through when Column B says "Done," enter: =$B1="Done" (ensure the row reference is relative).
5. Click the Format button within the dialog.
6. Go to the Font tab and check the Strikethrough box.
7. Click OK on both windows to finalize the rule.

Comparison of Strikethrough Implementation Methods

The following table evaluates the various methods based on speed, scalability, and specific professional use cases to help you select the optimal workflow.

Common Formatting Failures and Corrective Measures

Formatting in Excel can occasionally yield unexpected results due to layer conflicts or cell properties. Addressing these issues requires a systematic approach to style hierarchy.

• Strikethrough Not Visible Despite Being Enabled

  
  
  
  • Root Cause: The cell may have a dark fill color or a background pattern that obscures the thin strikethrough line, or the row height is too small for the font size.
  • Actionable Fix: Increase the row height or change the cell fill color to "No Fill." Additionally, ensure the font color is not set to match the background color.

• Conditional Formatting Overriding Manual Strikethrough

  
  
  
  • Root Cause: Conditional Formatting rules take precedence over manual formatting. If a rule exists that explicitly turns off strikethrough, manual changes will be ignored.
  • Actionable Fix: Open the Conditional Formatting Rules Manager (Home > Conditional Formatting > Manage Rules) and check for conflicting rules. Move your preferred rule to the top or check the "Stop If True" box.

• Strikethrough Not Printing Correctly

  
  
  
  • Root Cause: Low-resolution print settings or "Draft Quality" printing modes often omit fine lines like strikethroughs to save ink and processing power.
  • Actionable Fix: Go to Page Layout > Page Setup (dialog launcher) > Sheet Tab. Ensure "Draft quality" is unchecked. Increase the print DPI in your printer properties.

• Ctrl + 5 Shortcut Fails to Respond

  
  
  
  • Root Cause: Conflict with third-party software or Excel Add-ins that have remapped the Ctrl + 5 command for other functions.
  • Actionable Fix: Disable recently installed Add-ins or use the Alt-key sequence (Alt, H, F, N then navigate to Font) to verify if the functionality is still present in the core application.

Frequently Asked Questions

Can I apply a strikethrough to only one word inside a cell containing a full sentence?

Yes. To do this, double-click the cell to enter Edit Mode, or select the cell and highlight the specific word in the Formula Bar. Once the specific text is highlighted, use the Ctrl + 5 shortcut or the Format Cells dialog. This applies the formatting only to the selected characters rather than the entire cell string.

How do I remove a line through a word if the shortcut isn't working?

Select the cells and navigate to the Home tab. Click the clear button (the eraser icon) in the Editing group and select Clear Formats. Note that this will remove all formatting, including bolding, borders, and colors. Alternatively, open the Format Cells dialog (Ctrl + 1) and manually uncheck the Strikethrough box.

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

No, unlike Microsoft Word or PowerPoint, Excel does not include a strikethrough button on the default Home tab Ribbon. Microsoft prioritized other data-centric tools for the limited Ribbon space. You must use the Ctrl + 5 shortcut, the Format Cells dialog, or manually add the button to your Quick Access Toolbar as described in the steps above.

Can I use a formula to strike through text in Excel?

There is no direct Excel function (like =STRIKETHROUGH()) that returns formatted text. Formatting is an attribute of the cell, not the data value. To achieve formula-like behavior, you must use the Conditional Formatting feature, which applies the strikethrough style based on the result of a logical formula.

Does strikethrough work on numbers and dates in Excel?

Yes, strikethrough can be applied to any data type in Excel, including numerical values, dates, and currency. This is particularly useful in accounting for marking voided transactions or reconciled entries without removing the original figures from the audit trail.

Optimize Your Data Management Workflow

Mastering visual cues like strikethrough formatting significantly enhances the readability and professional utility of your workbooks. For users managing complex projects, implementing these formatting standards ensures that team members can distinguish between active and completed data at a glance.