strike through in excel

Strike Through in Excel: Quick Guide to Cross Out Text Easily

By
AD

Striking through text in Excel is a fundamental formatting technique that adds visual clarity to your data. Often used to indicate completed tasks, obsolete information, or corrections, this simple text decoration preserves the cell's content while signaling its status at a glance. Mastering this function enhances the professionalism and readability of your spreadsheets, making it an essential skill for anyone managing records or collaborating on financial models.

How to Apply Strikethrough Effectively

The most common method to activate this formatting is through the keyboard shortcut Ctrl + 5 on Windows or Command + Shift + X on Mac. After selecting the specific cell or range of cells you wish to modify, pressing this combination instantly draws a line through the center of the text. For users who prefer navigating the Ribbon, you can locate the "Font" group on the Home tab and click the icon featuring an "abc" with a horizontal line running through it.

Accessing the Format Cells Dialog

For users who require more control or are troubleshooting formatting conflicts, the traditional Format Cells dialog provides a reliable alternative. You can open this window by right-clicking the selected cell and choosing "Format Cells," or by pressing Ctrl + 1. Within the "Font" tab, you will find a checkbox labeled "Strikethrough." Checking this box and confirming the action applies the format, allowing you to adjust other font properties like style and color simultaneously.

AD
there is a sign that says 3 ways to apply strikethrough in excel
there is a sign that says 3 ways to apply strikethrough 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
Strikethrough in Excel
Strikethrough in Excel

Use Cases and Best Practices

Applying this formatting extends beyond simple aesthetics; it serves distinct logical purposes in data management. In inventory sheets, it clearly marks items as received or dispatched. In project management trackers, it visually differentiates between pending action items and those already fulfilled. When dealing with financial reconciliations, it helps highlight discrepancies that have been investigated and resolved, ensuring that reviewers do not waste time on settled figures.

  • Task Management: Crossing off completed to-dos to maintain team motivation.
  • Price Adjustments: Indicating old prices that are no longer valid while retaining historical records.
  • Data Correction: Signaling that specific data points have been reviewed and corrected in a subsequent cell.

Troubleshooting Common Issues

Occasionally, users may find that the strikethrough does not appear as expected. This is often due to conditional formatting rules or overlapping formats that override manual settings. To resolve this, check the "Conditional Formatting" rules manager to ensure no active logic is resetting your formatting. Furthermore, verify that the cell style is set to "Normal" rather than a custom style that locks specific font properties, which can prevent manual edits from taking effect.

How to strike through selection| How to change the font and font size in MS Excel|#shortcut(L#7)
How to strike through selection| How to change the font and font size in MS Excel|#shortcut(L#7)
Top 21 Excel Formulas
Top 21 Excel Formulas
How to Strikethrough text in Word or Excel
How to Strikethrough text in Word or Excel

Combining with Other Formatting

To maximize visual impact, consider combining this format with color coding. You might strike through text and change the font color to gray to signify that an item is archived, or use a red strike through to highlight critical errors that require immediate attention. Because Excel treats the underlying data as valid—even when visually marked—this technique allows for dynamic dashboards where calculations remain accurate while the display logic is transparent.

Advanced Implementation with Functions

For advanced users seeking automation, VBA (Visual Basic for Applications) allows you to programmatically apply or remove strikethrough based on specific conditions. By writing a simple macro, you can automate the formatting of entire rows when a checkbox is ticked or a date is reached. This moves the formatting from a static manual task to a dynamic component of your spreadsheet workflow, saving significant time in high-volume data environments.

AD
Complete Excel Formula Cheat Sheet | Excel Functions, Shortcuts & Tips for Students
Complete Excel Formula Cheat Sheet | Excel Functions, Shortcuts & Tips for Students
How to Use Excel Checkboxes with Strike Through
How to Use Excel Checkboxes with Strike Through
Common Errors in Excel
Common Errors in Excel
the top 15 microsoft excel tips
the top 15 microsoft excel tips
How to create Sparklines in Excel
How to create Sparklines in Excel
the top 30 excel formulas you must know to use in your workbook or notebook
the top 30 excel formulas you must know to use in your workbook or notebook
Progress Tracker in Excel – Visualize Your Goals & Milestones
Progress Tracker in Excel – Visualize Your Goals & Milestones
Fix Cut Off Text in Excel with Wrap Text
Fix Cut Off Text in Excel with Wrap Text
Helpful Excel T-Test Tips for Beginners
Helpful Excel T-Test Tips for Beginners
The easiest way to fix break lines in excel
The easiest way to fix break lines in excel
the excel power heat sheet is shown in green and white, with instructions on how to use
the excel power heat sheet is shown in green and white, with instructions on how to use
Work in Excel Faster Than Ever – Speed Up Your Workflow
Work in Excel Faster Than Ever – Speed Up Your Workflow
Excel Trick. Follow for more tricks.
Excel Trick. Follow for more tricks.
Excel Productivity Hacks That Save Time Daily
Excel Productivity Hacks That Save Time Daily
Most common excel errors solved
Most common excel errors solved
Common Excel Mistake: Sorting Names Incorrectly
Common Excel Mistake: Sorting Names Incorrectly
Mastering Excel's IF function is a total game-changer! 🤯 This incredible tool simplifies data analysis, whether you're grading students or tracking orders. From basic TRUE/FALSE scenarios to complex nested conditions, it handles it all with ease. Dive in and transform your spreadsheets! 📊✨ #ExcelTips #DataAnalysis #ProductivityHacks Productivity Hacks, Data Analysis
Mastering Excel's IF function is a total game-changer! 🤯 This incredible tool simplifies data analysis, whether you're grading students or tracking orders. From basic TRUE/FALSE scenarios to complex nested conditions, it handles it all with ease. Dive in and transform your spreadsheets! 📊✨ #ExcelTips #DataAnalysis #ProductivityHacks Productivity Hacks, Data Analysis
How to Align Text in Excel Step by Step
How to Align Text in Excel Step by Step
an image of a computer keyboard with the words ctrl and z below it
an image of a computer keyboard with the words ctrl and z below it
the excel shortcuts worksheet is shown in green and white, as well as
the excel shortcuts worksheet is shown in green and white, as well as
AD