How to Strikethrough Text in Excel: Easy Step-by-Step Guide
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.
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.
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.