5 Ways To Strikethrough In Excel

Using strikethrough in Excel can be a great way to visually distinguish between different types of data, indicate completed tasks, or highlight important information. Fortunately, Excel provides several methods to achieve strikethrough, each with its own set of benefits. In this article, we will explore five ways to strikethrough in Excel, helping you to enhance the readability and organization of your spreadsheets.

Method 1: Using the Strikethrough Button

The most straightforward way to strikethrough text in Excel is by using the built-in Strikethrough button. This method is easy to apply and can be used for individual cells or a range of cells.

To use the Strikethrough button:

1. Select the cell(s) you want to strikethrough.
2. Go to the Home tab in the Excel ribbon.
3. Click on the Font group dialog launcher (small arrow in the bottom right corner).
4. In the Font dialog box, check the Strikethrough checkbox.
5. Click OK to apply the changes.

Method 2: Using the Keyboard Shortcut

If you prefer to use keyboard shortcuts, you can use the following combination to strikethrough text in Excel:

1. Select the cell(s) you want to strikethrough.
2. Press Ctrl + 5 (Windows) or Command + Shift + X (Mac).

This method is quicker than using the Strikethrough button, especially when working with large datasets.

Method 3: Using Conditional Formatting

Conditional formatting allows you to apply strikethrough based on specific conditions, such as cell values or formulas. This method is useful when you want to automatically strikethrough cells that meet certain criteria.

To use conditional formatting:

1. Select the cell(s) you want to apply the formatting to.
2. Go to the Home tab in the Excel ribbon.
3. Click on the Conditional Formatting button in the Styles group.
4. Select New Rule.
5. Choose the type of condition you want to apply (e.g., "Format values where this formula is true").
6. Enter the formula that determines when to apply the strikethrough.
7. Click on the Format button and select the strikethrough option.
8. Click OK to apply the changes.

Method 4: Using VBA Macro

If you need to strikethrough a large number of cells or want to automate the process, you can use a VBA macro. This method requires some programming knowledge, but it can be efficient for repetitive tasks.

To use a VBA macro:

1. Press Alt + F11 to open the Visual Basic Editor.
2. In the Editor, click on Insert > Module to create a new module.
3. Paste the following code into the module:

Sub StrikethroughCells()
    Dim cell As Range
    For Each cell In Selection
        cell.Font.Strikethrough = True
    Next cell
End Sub

4. Close the Editor and return to your Excel spreadsheet.
5. Select the cell(s) you want to strikethrough.
6. Press Alt + F8 to open the Macro dialog box.
7. Select the StrikethroughCells macro and click Run.

Method 5: Using Formula

You can also use a formula to strikethrough text in Excel. This method is useful when you want to strikethrough text based on a specific condition or formula.

To use a formula:

1. Select the cell where you want to display the strikethrough text.
2. Enter the following formula:

=IF(A1>10,"Text to strikethrough","Text to display")

Replace A1 with the cell reference you want to use, and "Text to strikethrough" with the text you want to display.

Conclusion

In this article, we explored five ways to strikethrough in Excel, each with its own advantages and disadvantages. Whether you prefer to use the built-in Strikethrough button, keyboard shortcut, conditional formatting, VBA macro, or formula, there's a method that suits your needs. By applying strikethrough to your Excel spreadsheets, you can enhance readability, organization, and overall effectiveness.

We hope this article has been helpful in your Excel journey. If you have any questions or need further assistance, please don't hesitate to ask. Share your thoughts and experiences with strikethrough in Excel in the comments section below.

Gallery of Strikethrough Examples

FAQs

Gallery of 5 Ways To Strikethrough In Excel