strikethrough text in excel

How to Strikethrough Text in Excel: Easy Step-by-Step Guide

By
AD

Strikethrough text in Excel is a formatting option that draws a horizontal line through the center of the cell content. While the feature exists, many users struggle to locate it or understand the best scenarios for its application. This functionality is less about data calculation and more about visual communication within your spreadsheet.

Locating the Strikethrough Option

To apply a line through your text, you must first access the Home tab on the Ribbon. Within the Font group, you will find the Strikethrough button, which is represented by the letter "AB" with a horizontal line crossing through it. If the button appears grayed out, it usually means the cell is formatted as a number, which prevents the graphic from rendering correctly.

Using the Ribbon vs. Shortcuts

While clicking the icon is the standard method, power users often prefer keyboard efficiency. The standard shortcut is Ctrl+5, which toggles the strikethrough on and off instantly. However, this shortcut only works if the cell contains text or a manual line break; it will not function within a numeric value, regardless of how the number is displayed.

AD
How to Strikethrough Text in Word, Excel & PowerPoint
How to Strikethrough Text in Word, Excel & PowerPoint
How to Strikethrough Text in Excel!
How to Strikethrough Text in Excel!
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

Common Use Cases and Best Practices

One of the most professional uses of this feature is to mark tasks as complete without deleting the data. In a to-do list or inventory sheet, striking through an item provides a clear visual cue that the task is finished, preserving the historical record for accuracy. This approach is significantly cleaner than changing the font color to gray to simulate a removed item.

  • Task Management: Indicating completed action items.
  • Inventory Control: Showing discontinued stock items.
  • Data Revision: Denoting old figures while retaining them for audit trails.
  • Collaboration: Highlighting information that has been reviewed or superseded.

Limitations and Data Types

It is crucial to understand that strikethrough is purely a visual cosmetic change; it does not alter the actual value stored in the cell. If you strike through the number "100," Excel still treats that cell as the numeric value 100 in calculations. Consequently, you cannot sum "striked" and "unstriked" numbers to get a total of only the active items using standard functions alone.

How to Strikethrough text in Word or Excel
How to Strikethrough text in Word or Excel
Applying Strikethrough in Excel
Applying Strikethrough in Excel
How to Strikethrough in Excel – 3 Ways!
How to Strikethrough in Excel – 3 Ways!

Advanced Automation with Conditional Formatting

For dynamic spreadsheets, manually applying the format is inefficient. You can link the strikethrough to the cell's value using Conditional Formatting rules. For example, you can set a rule that automatically strikes through the text in a cell if it contains the word "Complete" or if the adjacent cell contains a specific date. This automation ensures that your formatting stays consistent as the underlying data changes.

Complementary Formatting Tips

Combining strikethrough with other formatting options can enhance readability. For instance, reducing the font color opacity or using a lighter font style alongside the line creates a more sophisticated "retired" look compared to a harsh black line. When dealing with large datasets, ensure there is sufficient row height to accommodate the line without it overlapping adjacent text, which can make the sheet difficult to read.

AD
Strikethrough in Excel
Strikethrough in Excel
How to Strikethrough in Microsoft Excel
How to Strikethrough in Microsoft Excel
Bold, Italic, Underline, and Strikethrough
Bold, Italic, Underline, and Strikethrough
Lifehacker Disclaimer
Lifehacker Disclaimer
3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells
3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells
Fix Cut Off Text in Excel with Wrap Text
Fix Cut Off Text in Excel with Wrap Text
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 Text in Word | Techwalla
How to Strikethrough Text in Word | Techwalla
How to use strikethrough, crossout and cancel out in LaTeX?
How to use strikethrough, crossout and cancel out in LaTeX?
How to Strikethrough in Excel: 4 Simple and Workable Solutions
How to Strikethrough in Excel: 4 Simple and Workable Solutions
How to Align Text in Excel Step by Step
How to Align Text in Excel Step by Step
TEXT Function: Combine Text with Numbers in Excel (+ video tutorial)
TEXT Function: Combine Text with Numbers in Excel (+ video tutorial)
Excel Formula Guide for Office & MIS Work
Excel Formula Guide for Office & MIS Work
the text tech tip of the day on a black background with red and white lines
the text tech tip of the day on a black background with red and white lines
the top 15 excel formulas are written on lined paper with different symbols and numbers
the top 15 excel formulas are written on lined paper with different symbols and numbers
How to Use FORMULA TEXT Function in Excel
How to Use FORMULA TEXT Function in Excel
a poster with instructions on how to use flash files in excel and wordpress, including the
a poster with instructions on how to use flash files in excel and wordpress, including the
the top 20 excel formulas in an iphone screen shot, with text added to it
the top 20 excel formulas in an iphone screen shot, with text added to it
the different types of text and numbers in each language, including one for each subject
the different types of text and numbers in each language, including one for each subject
Excel Shortcuts for All Levels: Boost Productivity | Hasnain Liaqat posted on the topic | LinkedIn
Excel Shortcuts for All Levels: Boost Productivity | Hasnain Liaqat posted on the topic | LinkedIn
AD