Mastering Excel Strikethrough Text

Tyler Aug 04, 2026

Ever needed to strike through text in Excel to indicate corrections, deletions, or to draw attention to specific data? Excel provides a straightforward way to achieve this, enhancing the readability and interactivity of your spreadsheets. In this guide, we'll delve into the world of strikethrough text in Excel, exploring its uses, how to apply it, and some helpful tips to make the most of this feature. Let's dive right in!

How to Strikethrough Text in Excel - shortcut and example
How to Strikethrough Text in Excel - shortcut and example

Strikethrough text in Excel isn't just about aesthetics; it's a powerful tool for maintaining a clear audit trail, tracking changes, and communicating effectively within your team. By learning how to strike through text, you'll elevate your Excel skills and make your spreadsheets more intuitive and user-friendly.

How to Strikethrough Text in Word, Excel & PowerPoint
How to Strikethrough Text in Word, Excel & PowerPoint

Understanding Strikethrough Text in Excel

Excel's strikethrough feature allows you to cross out single or multiple cells with a horizontal line, making the text partially illegible while still retaining its content. This is particularly useful when working collaboratively or managing large datasets, as it enables you to denote outdated information, correction marks, or additional notes without deleting or cluttering the cell.

Strikethrough in Excel: How to Cross Out Text in Cells - Make Tech Easier
Strikethrough in Excel: How to Cross Out Text in Cells - Make Tech Easier

Strikethrough text is an essential aspect of Excel's conditional formatting options, allowing you to apply formatting changes based on specific rules or cell values. By mastering this feature, you'll unlock a myriad of formatting possibilities to suit your needs.

Why Use Strikethrough Text in Excel?

How to Strikethrough Text in Excel!
How to Strikethrough Text in Excel!

The primary use of strikethrough text in Excel is to denote that a part of the content has been replaced, deleted, or is no longer relevant. This could be due to updates, errors, or simply to draw attention to specific data points. Employing strikethrough text fosters clear communication, aids in tracking changes, and ensures all stakeholders remain informed and up-to-date.

Some common use cases include tracking corrections in data entry, highlighting outdated information, or indicating data that requires verification. By using strikethrough text effectively, you can minimize confusion and streamline workflows within your team.

Strikethrough Text vs. Text Highlighting and Colors

How to Strikethrough Text in Excel
How to Strikethrough Text in Excel

While Excel offers a variety of text formatting options, such as text highlighting and colors, strikethrough text serves a unique purpose. Unlike these alternatives, strikethrough text not only draws attention but also suggests that the text is no longer valid or relevant. It provides a clear signal that the reader should consider the content with caution or seek updates elsewhere.

In contrast, text highlighting and colors can serve as neutral indicators, drawing attention without conveying any additional semantic information. Understanding the difference between these formatting options helps you choose the most appropriate tool for your specific needs.

Applying Strikethrough Text in Excel

Bold, Italic, Underline, and Strikethrough
Bold, Italic, Underline, and Strikethrough

Applying strikethrough text in Excel is a breeze once you know the keyboard shortcut or how to access the conditional formatting rules. In this section, we'll explore both methods, ensuring you're equipped to strike through text with ease.

Before delving into the process, make sure your Excel version is up-to-date, as some features may vary depending on your specific version.

Applying Strikethrough in Excel
Applying Strikethrough in Excel
How to Strikethrough in Excel – 3 Ways!
How to Strikethrough in Excel – 3 Ways!
a screenshot of a computer screen with the text, loggle visual basic for applications
a screenshot of a computer screen with the text, loggle visual basic for applications
How to strikethrough in Excel
How to strikethrough in Excel
How to Strikethrough in Microsoft Excel
How to Strikethrough in Microsoft Excel
the format cells dialogg is highlighted in the text box above the font field
the format cells dialogg is highlighted in the text box above the font field
3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells
3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells
How to Strikethrough in Microsoft Excel
How to Strikethrough in Microsoft Excel
Tips for Working With Text and Text Functions in Excel
Tips for Working With Text and Text Functions in Excel

Keyboard Shortcut for Strikethrough Text

The keyboard shortcut for strikethrough text in Excel is quite simple, consisting of a single keystroke. Here's how to use it:

  1. Select the cell or range of cells containing the text you wish to strike through.
  2. Press the '~' key (tilde) on your keyboard. This key is typically located above the Tab key on most keyboards.
  3. The text within the selected cells will now appear with a single strikethrough line.

To remove the strikethrough formatting, simply repeat the process, or you can use the keyboard shortcut for removing formatting (Ctrl + Z or Command + Z on Mac).

Using Conditional Formatting for Strikethrough Text

Excel's conditional formatting feature allows you to apply strikethrough text based on specific rules or criteria. This is particularly useful when you want to automate the formatting process, ensuring consistency and accuracy across large datasets. Here's how to apply conditional formatting for strikethrough text:

  1. Select the cell or range of cells you wish to format.
  2. Click on the 'Home' tab in the ribbon.
  3. In the 'Styles' group, click on 'Conditional Formatting', and then select 'Highlight Cells Rules'.
  4. Choose the appropriate rule, such as 'Equal to', 'Less than', 'Greater than', or 'Between', depending on the condition you wish to apply.
  5. In the rule dialogue box, specify the value or values that will trigger the strikethrough formatting.
  6. Click on the 'Format' button, and in the 'Number' tab, select the font style as 'Strikethrough'.
  7. Click 'OK' to apply the rule. Repeat the process for any additional rules you wish to apply.

To edit or remove conditional formatting rules, right-click on the selected cells and choose 'Conditional Formatting', then select 'Manage Rules'.

Tips and Best Practices for Using Strikethrough Text

To maximize the effectiveness of strikethrough text in Excel, consider the following tips and best practices:

1. Be consistent: Establish a clear and consistent naming convention or shorthand to indicate why text has been struck through, ensuring smooth communication and understanding within your team.

2. Limit use to necessary cases: Strikethrough text works best when used sparingly. Avoid overapplying it, as this can confuse readers and diminish its impact.

3. Combine with other formatting choices: To emphasize the importance of strikethrough text further, consider pairing it with additional formatting options, such as text highlighting, colors, or bold font.

4. Provide context: When striking through text, ensure that the reader has sufficient context to understand the changes or updates you're indicating. This may involve providing additional notes, comments, or documentation.

Strikethrough Text in Excel: FAQs

To help address any common questions or concerns, let's explore some frequently asked questions about strikethrough text in Excel.

Q: Can I apply strikethrough text to headers, footers, or other non-celled text objects?

A: Currently, Excel's strikethrough feature only applies to cell contents, including values and formulas. You cannot apply it directly to headers, footers, or other text objects within your spreadsheet.

Q: Can I combine strikethrough text with other text formatting options?

A: Yes, you can combine strikethrough text with other formatting options, such as bold, italics, underlines, or text highlighting. This is particularly useful when you want to emphasize the text further or draw additional attention to it.

Q: Can I use strikethrough text in Excel for Mac?

A: Yes, strikethrough text is available in Excel for Mac, using the same keyboard shortcut (~) or conditional formatting rules as the Windows version. However, the user interface and some menu options may differ slightly between platforms.

Strikethrough text in Excel is an invaluable tool for maintaining clarity and communication within your spreadsheets, be it for personal use or collaborative projects. By mastering this formatting option, you'll elevate your Excel skills and unlock a world of possibilities for enhancing the readability and interaction of your data. So, go ahead and put those strikeovers to good use!