How to strikethrough in Excel

Excel offers seven ways to strike through cell contents for deletion or irrelevance.

Note:

Open Microsoft Excel spreadsheet

Open Microsoft Excel from Windows start icon that appears on the left bottom corner of your device screen. Open a file where you want to work.

Open Microsoft Excel spreadsheet

How to Strikethrough in Excel

Excel’s strikethrough formatting is beneficial for marking deleted or outdated cell entries while keeping them visible. It’s commonly used to track changes and completed tasks, maintaining a clear record of spreadsheet edits over time. It’s often used for tracking changes or completed tasks, visually indicating data deletions or invalidations while providing a clear record for spreadsheet reviews or edits. This feature visually highlights data that has been removed or is no longer valid, making it helpful in reviewing and editing spreadsheets.

How to Strikethrough in Excel

Table of Content

  • What is Strikethrough in Excel?
  • How to strikethrough in Excel
  • How to Strikethrough in Excel Shortcut
  • How to Add a Strikethrough in Excel Using Format Options
  • How to Add a strikethrough in Excel Using the Quick Access Toolbar
  • How to Add a Strikethrough in Excel Using it from Excel Ribbon
  • How to add a strikethrough in Excel Using Dynamic Conditional Formatting
  • How to add a strikethrough in Excel Using VBA
  • How to Remove Strikethrough in Excel
  • Remove Strikethrough Manually
  • Remove Strikethrough added with conditional Formatting
  • Conclusion
  • FAQ’s on Strikethrough in Excel

Similar Reads

What is Strikethrough in Excel?

In Excel, a strikethrough is a formatting option that adds a horizontal line through text or numbers in a cell, indicating irrelevance, deletion, or completion. It can be applied to cells or text parts, commonly used for tracking changes or marking completed tasks. This tool, also crucial in word processing, crosses out entered content in Excel cells....

How to strikethrough in Excel

Excel offers seven ways to strike through cell contents for deletion or irrelevance....

How to Strikethrough in Excel Shortcut

Step 1: Open Excel and Enter the data into the sheet...

How to Add a Strikethrough in Excel Using Format Options

Ultimately, this technique will strike through selected cell contents....

How to Add a strikethrough in Excel Using the Quick Access Toolbar

Use Quick Access Toolbar (QAT) for Excel strikethrough, and follow the steps:...

How to Add a Strikethrough in Excel Using it from Excel Ribbon

Use Ribbon for Excel strikethrough; follow the steps:...

How to add a strikethrough in Excel Using Dynamic Conditional Formatting

Use Dynamic Conditional Formatting for Excel strikethrough....

How to add a strikethrough in Excel Using VBA

Use Visual Basic Editor for Excel strikethrough, follow the steps:...

How to Remove Strikethrough in Excel

To remove Excel strikethrough, use various methods....

Remove Strikethrough Manually

Step 1: Remove Strikethrough...

Remove Strikethrough added with conditional Formatting

Step1: Select the cell...

Conclusion

In Excel, a strikethrough is a formatting option used to draw a line through text in cells, indicating information is outdated but visible. Apply it to cells or ranges for various uses, like in financial models, task lists, or checklists. Evaluate its purpose in your spreadsheet: if it enhances clarity, it’s beneficial; however, excessive or improper use can confuse readers. Consider the audience and context when using formatting tools like Strikethrough in Excel....

FAQ’s on Strikethrough in Excel

What is the shortcut key for Strikethrough in Excel? Ctrl + 5 is the Excel key for Strikethrough on Mac and Windows. To apply the strikethrough effect on Windows, open the format dialogue box and click Ctrl + 1....

Contact Us