How to Add a Strikethrough in Excel Using Format Options
Ultimately, this technique will strike through selected cell contents.
Step 1: Select the cells
Choose cells with the data for Formatting.
Step 2: Click the Format Cells
Click the Format Cells box button to access formatting options.
Step 3: Tap to Strikethrough
Click Strikethrough in the Format Cells box under Effects to apply the Formatting.
Step 4: Save the workbook
Save the workbook, then reopen it in Excel for the web to view changes.
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.
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
Contact Us